Lead Data Modeller – Snowflake & Power BI Expert

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

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