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.
- Robust 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.

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.

Be careful - Don’t provide your bank or credit card details when applying for jobs. Don't transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad .

📌 Lead Data Modeller (Canberra)
🏢 The Recruitment Hive
📍 Canberra