Lead Data Modeller

National Disability Insurance Agency; Canberra; Hybrid; AUD 120,000 - 150,000; Full time

Job summary

The National Disability Insurance Agency is seeking an EL1 Data Modeller to lead enterprise data modelling, governance and design for our modern data platform. You will collaborate with architects, engineers, analysts and stakeholders to ensure scalable, semantic data models across projects.

Responsibilities include designing star-schema dimensional models, defining KPIs, and delivering analytics-ready data assets, while improving performance and consistency for enterprise reporting and decision

Qualifications

• Lead design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
• Translate business requirements into logical, dimensional and semantic data models.
• Design and develop enterprise grade dimensional models using star schema principles.

Responsibilities

• Lead the design and governance of semantic models and KPIs.
• Translate requirements into logical, dimensional and semantic models.
• Develop star-schema dimensional models for data warehouses.
• Create analytical data models to support reporting and analytics.
• Define business measures and reusable KPI calculations.
• Collaborate with data engineers to identify data sources and data needs.
• Improve semantic model performance and query efficiency.
• Ensure reporting reuse by avoiding duplication of business logic.

Skills

Data modelling

Semantic modelling

Dimensional modelling

KPIs

SQL transformations

Data governance

Business metrics

BI tools

Tools

BI tools

Job description

• Length of Contract: 12 months with 1 x 12 months extension possibility
• The role closes on 10/11/2026
• Location: QLD, ACT, VIC, NSW (Hybrid)

Job details

The EL1 Data Modeller role is responsible for leading enterprise data modelling activities across multiple projects and initiatives. Working closely with architects, engineers, analysts and business stakeholders, the position drives best practice data modelling, governance and design to support the Agency's modern data platform and analytics capability.

Key duties and responsibilities

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
• Engage with business stakeholders and data architects to understand business requirements and translate them into logical, dimensional and semantic data model.
• Design and develop enterprise grade dimensional models using start schema principles, including fact tables, dimensions, relationships, hierarchies and appropriate data granularity.
• Develop and optimise analytical data models within data warehouse, including presentation layer tables, views and SQL transformations to support semantic model requirements.
• Design, develop and maintain reusable and scalable semantic models in BI tools to support enterprise reporting and analytics.
• Define and implement business measures, KPIs, calculations and reusable business logic.
• Collaborate with data engineering teams to identify source data requirements, resolve data modelling challenges and ensure data is structured appropriately for analytical consumption.
• Optimise semantic model performance including relationships, cardinality, filter propagation and underlying database query performance.
• Work closely with reporting and analytics teams to enable consumption of governed semantic models without duplicating business logic across individual reports.

(Note: responsibilities may change based on business priorities.)

About the team

The Data Platforms and Services Branch is committed to building a world class, modern data platform, providing high quality data assets and products, and strengthening data capabilities across the NDIA to better manage and leverage data.

Our Data Office leads the Data Governance framework and helps the agency treat data as a critical strategic asset, manage it effectively across its lifecycle, and use it responsibly to improve efficiency and decision-making.

Our Data Platform and Services teams build and maintain the agency's data pipelines, data and reporting platforms, with specialised technical capabilities in data architecture and modelling, data engineering, technical business analysis, analytics and reporting.

Our data assets and products support analysis and reporting teams across the agency as well as external stakeholders and public reporting, but products are also integrated into business systems to support agency workflows and decision making.

SFIA Skills Sought:

The development of models to represent and communicate data requirements and to enable organisations to understand their data assets and the relationships between real-world entities. The investigation, analysis and scoping of data requirements to support the development of software systems, data integration and data retrieval activities. The iteration, review and maintenance of data requirements and data models.

Sets standards for data modelling and design tools and techniques, advises on their application, and ensures compliance. Manages the investigation of corporate data requirements, and co‑ordinates the application of data analysis, design and modelling techniques, based upon a detailed understanding of the corporate information requirements, in order to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). Manages the iteration, review and maintenance of data requirements and data models.

\"We warmly welcome applications from individuals of all backgrounds, including First Nations Australians, Australian Defence Force and First Responder veterans, women in STEM, and people of all abilities, including those registered with the NDIS.\"