Lead Data Modeller (EL1)

Talent; Melbourne; Hybrid; AUD 140,000 - 170,000; Full time

Job summary

Our client, a large Federal Government Agency, seeks a Lead Data Modeller (EL1) to lead enterprise data modelling across a modern data platform and analytics environment. Hybrid role in VIC with 37.5 hours weekly in a privacy-conscious, security-focused team.

You'll design scalable data models, translate complex requirements into semantic models, and collaborate with architects, engineers and stakeholders to improve reporting quality and consistency, using Snowflake, SQL, dimensional modelling

Qualifications

• Extensive enterprise data modelling experience within large, complex data environments.
• Strong hands-on Snowflake experience, including analytical modelling and query optimisation.
• Advanced understanding of logical, physical, dimensional and semantic data modelling.
• Experience with star schemas, fact/dimension tables and ER modelling.
• Proficiency with ERwin or equivalent data modelling tools.
• Strong experience developing semantic models for Power BI.

Responsibilities

• Lead the design and development of enterprise data models across Snowflake and BI environments.
• Translate business requirements into logical, physical, dimensional and semantic data models.
• Develop star schemas, fact and dimension tables, relationships and hierarchies.
• Design presentation-layer structures, SQL transformations and analytical datasets.
• Build reusable semantic models, KPIs and business measures for enterprise reporting.
• Collaborate with data engineers, architects and analysts on modelling standards and integration requirements.
• Support data governance, documentation and consistent business logic across reporting products.

Skills

Snowflake

Dimensional modelling

SQL

Power BI

Stakeholder engagement

Tools

ERwin

Job description

Our client is a large values-focused Federal Government Agency seeking an experienced Lead Data Modeller (EL1 level) to lead enterprise data modelling across a modern data platform and analytics environment.

This is a senior technical role combining Snowflake, SQL, dimensional modelling, semantic data models and Power BI, working closely with data architects, engineers and business stakeholders to improve data quality, consistency and enterprise reporting capabilities.

ROLE DETAILS:

Location: Richmond OR Geelong, VIC
Contract: 12 months + 12-month extension option
Working arrangement: Hybrid
Hours: Full time, 37.5 hours per week
Security: NV1 Clearance preferred (Baseline minimum)
Eligibility: Australian Citizen mandatory
Applications close: Wednesday 11 November 2026

ABOUT THE ROLE:

You'll take a leading role in designing and improving enterprise data models that underpin reporting, business intelligence and analytics across multiple initiatives.

Working across business and technical teams, you'll translate complex requirements into scalable data structures, establish reusable semantic models and improve the consistency of business metrics, datasets and reporting outputs.

KEY RESPONSIBILITIES:

• Lead the design and development of enterprise data models across Snowflake and BI environments.
• Translate business requirements into logical, physical, dimensional and semantic data models.
• Develop star schemas, fact and dimension tables, relationships and hierarchies.
• Design presentation-layer structures, SQL transformations and analytical datasets.
• Build reusable semantic models, KPIs and business measures for enterprise reporting.
• Optimise data models and queries to improve performance and reporting accuracy.
• Collaborate with data engineers, architects and analysts on modelling standards and integration requirements.
• Support data governance, documentation and consistent business logic across reporting products.

SELECTION CRITERIA:

• Extensive enterprise data modelling experience within large, complex data environments.
• Strong hands-on Snowflake experience, including analytical modelling, complex SQL, presentation layers and query optimisation.
• Advanced understanding of logical, physical, dimensional and semantic data modelling.
• Experience with star schemas, fact/dimension tables, data normalisation and ER modelling.
• Proficiency with ERwin or equivalent data modelling tools.
• Strong experience developing semantic models for Power BI or similar enterprise BI platforms.
• Understanding of data governance, metadata, naming conventions and modelling standards.
• Excellent stakeholder engagement skills, including technical workshops and translating business requirements into data designs.

HIGHLY DESIRABLE:

• Cloud data platform experience across AWS, Databricks, MS Fabric, Redshift or similar.
• Experience with enterprise data transformation, architecture or data strategy initiatives.
• Knowledge of master data management, data quality and governance frameworks.
• Previous Australian Federal Government or highly regulated industry experience.