Senior Data Modeller - Snowflake & Power BI, Hybrid

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, 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