Job description
THE ROLE
Working closely with the Director, Business Intelligence (BI), the Data Modeller is
responsible for ensuring that data is structured, transformed, and optimised for reporting
and analytical purposes. By designing robust and efficient data models, they enable
business intelligence teams to generate meaningful insights and decision-making reports.
They work closely with business stakeholders and technical teams to ensure that the data
aligns with business needs, is of high quality, and can be accessed efficiently for reporting
purposes.
We are looking for someone to join the State Gov Department team and utilise their high-level skills in data
modelling experience. The collaborative team values continuous development, creative
thinking, and well-developed communication skills. In this role, you will collaborate with
fellow team members and stakeholders at varying levels across the department to deliver
data assets that support the strategic direction of the Department.
RESPONSIBILITIES
- Provision of technical subject matter expertise to support the design and implementation of a modern data platform through effective collaboration with Data & Analytics and broader Strategic Delivery stakeholders.
- Create logical and physical data models that support the creation of business reports and dashboards. This includes working with structured and unstructured data sources.
- Structure data in a way that is optimised for reporting, which may involve either normalising data for relational models or denormalising it for data warehouses or reporting purposes (e.g., star schema or snowflake schema).
- Define and implement data transformation logic required for preparing raw data into usable forms for reporting (e.g., aggregations, calculations, time-series formatting).
KEY SKILLS
- Demonstrated expertise in creating data models (logical, physical) for reporting purposes. Familiarity with database design principles such as normalisation, denormalisation, star and snowflake schema (Kimball modelling), entity relationship modelling, and reference data management.
- Experience in designing and implementing large scale data loading, manipulation, processing, analysis and exploration data solutions (preferably with strong SQL skills in a Microsoft Data and Analytics environment).
- Demonstrated initiative and problem-solving skills to recommend innovative approaches to data management, ensuring accurate and timely outputs.
- Demonstrated understanding of master data management principles and processes.
- Well-developed interpersonal skills with the ability to build and sustain positive relationships and consult, negotiate, liaise and influence others to achieve mutually beneficial solutions and provide advice and recommendations to internal and external stakeholders
To be considered for the role click the 'apply' button or for more information about this and other opportunities please contact Jack McDougall 07 3339 5611 or email: [email protected] and quote the above job reference number.
Paxus values diversity and welcomes applications from Indigenous Australians, people from diverse cultural and linguistic backgrounds and people living with a disability. If you require an adjustment to the recruitment process, including the application form in an alternate format, please contact me on the above contact details.
