Lead Data Modeller: Power BI & Snowflake

HCM Australia Pty; Sydney; Hybrid; AUD 140,000 - 190,000; Full time

Job summary

HCM Australia is seeking a Lead Data Modeller to shape enterprise semantic models supporting Power BI and Snowflake for a federal government contract. This greenfield role blends data modelling, governance and analytics delivery in a large, regulated environment.

You will lead design and governance of enterprise semantic models, collaborate with data engineers, and deliver scalable, governance-compliant analytics across Power BI and Snowflake platforms.

Qualifications

• Extensive experience leading enterprise data modelling in large and complex environments.
• Strong semantic data modelling experience, particularly for Power BI.
• Hands-on Snowflake experience covering analytical models, presentation layers, complex SQL, optimisation and validation.
• Advanced conceptual, logical, physical, ER and dimensional modelling capability.
• Practical experience with ERwin or an equivalent modelling tool.
• Source-to-target mapping and close collaboration with data engineering teams.
• Knowledge of metadata, model documentation, naming conventions and governance standards.
• Excellent workshop facilitation, stakeholder engagement and communication skills.

Responsibilities

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs and business metrics.
• Translate complex business requirements into conceptual, logical, physical, dimensional and semantic data models.
• Design enterprise-grade star schemas, including facts, dimensions, relationships, hierarchies and appropriate granularity.
• Develop and optimise analytical models in Snowflake, including presentation-layer tables, views and complex SQL transformations.
• Build reusable and scalable semantic models for Power BI and governed self-service analytics.
• Define reusable measures, KPIs, calculations and business logic.
• Collaborate with data engineers on source requirements, source-to-target mapping and modelling challenges.
• Optimise model performance, including relationships, cardinality, filter propagation and database query performance.
• Enable reporting and analytics teams to use governed models without duplicating business logic.

Skills

Enterprise data modelling

Power BI modelling

Semantic data modelling

Stakeholder engagement

Workshop facilitation

Governance standards

Tools

Snowflake

Power BI

ERwin

Job description

HCM Australia is seeking a Lead Data Modeller to shape enterprise semantic models supporting Power BI and Snowflake for a federal government contract. This greenfield role blends data modelling, governance and analytics delivery in a large, regulated environment.

You will lead design and governance of enterprise semantic models, collaborate with data engineers, and deliver scalable, governance-compliant analytics across Power BI and Snowflake platforms.