Lead Data Modeller - Power BI and Snowflake

About the role

HCM Australia is recruiting a Lead Data Modeller for a senior, EL1-equivalent Federal Government contract. It is a greenfield opportunity to build an enterprise semantic modelling capability for a new Power BI environment, with Snowflake as the data warehouse. The role is individual contributor with no direct reports, joining a data area of about 50 professionals.

Key responsibilities

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

Required profile

• Extensive experience leading enterprise data modelling in large, complex environments.
• Strong semantic modelling experience, especially for Power BI.
• Hands-on Snowflake experience, including analytical models, presentation layers, complex SQL, optimisation and validation.
• Advanced conceptual, logical, physical, ER and dimensional modelling; practical ERwin or equivalent tool experience.
• Experience with cloud data platforms such as AWS, Databricks, Snowflake, MS Fabric or Redshift.
• Experience supporting enterprise architecture, data strategy or large-scale data transformation programs.
• Knowledge of data governance, metadata management, master data management and data quality frameworks.
• Previous experience in the Australian Government or other highly regulated environments.
• Australian citizenship is mandatory, and an Australian Government NV1 security clearance must be obtainable.

Required skills

• Power BI semantic modelling
• Snowflake and complex SQL
• Dimensional modelling and ERwin or equivalent
• Source-to-target mapping

Contract details: initial 12 months with a 12-month extension option, 37.5 hours per week, hybrid with at least 3 days in the office, expected start December 2026. Locations are QLD, ACT, VIC or NSW. Apply through HCM Australia with a resume and a brief summary of semantic modelling experience.