12 + 12 Month contract - ASAP Start
NV1 Security Clearance
ACT, VIC, QLD, NSW, Hybrid WFH
EL1 Equivalent

Our client, a Commonwealth Government organisation whose focus is to provide support to Australian's living with disability, require the services of Lead Data Modeller.

Duties of the Lead Data Modeller:

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.

Skills and Experience

Extensive experience leading enterprise data modelling activities within large and complex data environments, with a strong understanding of enterprise data modelling principles, naming conventions, metadata management, model documentation and governance standards.
Proven ability to analyse complex business requirements, identify business entities, relationships, measures, KPIs and dimensions, and translate these into logical, physical and semantic data models.
Strong hands-on experience designing and developing analytical data models in Snowflake, including presentation layer design, complex SQL transformations, query optimisation, and validation of semantic models against business requirements to ensure accuracy and consistency of business metrics.
Demonstrated proficiency in data modelling tools and techniques, including ER modelling, dimensional modelling, data normalisation, and the use of ERWIN or equivalent modelling tools.
Extensive experience architecting and developing scalable semantic data models that support self-service reporting, analytics and business intelligence solutions, including Power BI and similar platforms.

How to Apply

For a copy of the full job description, including the application instructions please get in touch with Alex at the Recruitment Hive by clicking the Quick Apply button. Alternatively, you can reach Alex on (02) 6299 1006 to discuss further.

Please note, applications close on Wednesday, 11th November 2026 at midday, Canberra time.

Recruitment Hive welcome late applications to be considered for future opportunities

Job ID 680667 | LH-08399

We Value Diversity

The Recruitment Hive is a proud Equal Opportunity Employer. We recognise the value of diverse perspectives and experience and are committed to an inclusive workplace where everyone feels valued and respected for who they are. We encourage people with disability, indigenous, veterans and people of all backgrounds and abilities to express their interest in this role.