Lead Data Modeller - Power BI and Snowflake
- 05 Nov 2026
- Sydney
- Contract
- Contract role - Federal Government
- 12 months + 12 months
- Power BI, Snowflake Data Modeller
Greenfield opportunity for a Lead Data Modeller to shape enterprise semantic models supporting Power BI, Snowflake and governed analytics
The Opportunity
HCM Australia is recruiting a Lead Data Modeller for a senior, EL1-equivalent Federal Government contract. This is a greenfield opportunity to help establish and shape an enterprise semantic modelling capability supporting a new Power BI environment.
The organisation uses Snowflake as its data warehouse. The role requires strong semantic modelling capability across Power BI and Snowflake, together with traditional data modelling skills and the ability to work closely with data engineering, architecture, analytics and business teams.
This is an individual contributor role with no direct reports. You will join a broader data area of approximately 50 professionals across data engineering, architecture, operations, reporting and data modelling.
What You Will Do
Locations: QLD, ACT, VIC or NSW
Working arrangement: Hybrid, with a minimum of 3 days each week in the office
Contract: Initial 12 months with one 12-month extension option
Hours: 37.5 hours per week
Expected commencement: December 2026. Candidates available in early January may also be considered.
Eligibility: Australian citizenship is mandatory. Candidates must be able to obtain an Australian Government NV1 security clearance.
Apply Through HCM Australia
Please apply with your current resume and a brief summary of your experience building semantic models for Power BI and Snowflake. Your resume should also show your traditional data modelling capability, including ERwin or equivalent tools, conceptual, logical and physical models, dimensional modelling and source-to-target mapping.
Email: cris.nunes@hcmaustralia.com.au | Phone: 0421 055 702
HCM Australia has specialised in placing technology professionals across Australian Federal and State Government since 2006. We provide straightforward communication, personal service and support throughout the recruitment process.
The Opportunity
HCM Australia is recruiting a Lead Data Modeller for a senior, EL1-equivalent Federal Government contract. This is a greenfield opportunity to help establish and shape an enterprise semantic modelling capability supporting a new Power BI environment.
The organisation uses Snowflake as its data warehouse. The role requires strong semantic modelling capability across Power BI and Snowflake, together with traditional data modelling skills and the ability to work closely with data engineering, architecture, analytics and business teams.
This is an individual contributor role with no direct reports. You will join a broader data area of approximately 50 professionals across data engineering, architecture, operations, reporting and data modelling.
What You Will Do
- 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.
- 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.
- Strong knowledge of metadata, model documentation, naming conventions and governance standards.
- Excellent workshop facilitation, stakeholder engagement and communication skills.
- Experience working with cloud data platforms including AWS, Databricks, Snowflake, MS Fabric, Redshift or similar technologies.
- 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 working within the Australian Government or other highly regulated environments.
Locations: QLD, ACT, VIC or NSW
Working arrangement: Hybrid, with a minimum of 3 days each week in the office
Contract: Initial 12 months with one 12-month extension option
Hours: 37.5 hours per week
Expected commencement: December 2026. Candidates available in early January may also be considered.
Eligibility: Australian citizenship is mandatory. Candidates must be able to obtain an Australian Government NV1 security clearance.
Apply Through HCM Australia
Please apply with your current resume and a brief summary of your experience building semantic models for Power BI and Snowflake. Your resume should also show your traditional data modelling capability, including ERwin or equivalent tools, conceptual, logical and physical models, dimensional modelling and source-to-target mapping.
Email: cris.nunes@hcmaustralia.com.au | Phone: 0421 055 702
HCM Australia has specialised in placing technology professionals across Australian Federal and State Government since 2006. We provide straightforward communication, personal service and support throughout the recruitment process.