Lead Data Modeller (EL1)

Talent Corp; Melbourne; Hybrid; AUD 180,000 - 240,000; Full time

Job summary

Talent Corp is assisting a federal government agency in Melbourne, seeking a Lead Data Modeller (EL1) to lead enterprise data modelling across a modern data platform and analytics environment. The role focuses on Snowflake, SQL, dimensional and semantic modelling, with close collaboration to data architects, engineers and business stakeholders.

You'll design scalable data models, establish reusable semantic models and improve data quality for enterprise reporting across multiple initiatives, in

Qualifications

• Extensive enterprise data modelling experience in large, complex environments.
• Strong hands-on Snowflake experience with analytical modelling and SQL.
• Advanced understanding of logical, physical, dimensional and semantic modelling.
• Experience with star schemas, fact/dimension tables and data normalisation/ER modelling.
• Proficiency with ERwin or equivalent data modelling tools.
• Experience developing semantic models for Power BI or similar BI platforms.
• Knowledge of data governance, metadata, naming conventions and modelling standards.

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.

Skills

Snowflake

SQL

Dimensional modelling

Semantic data modelling

Power BI

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.