Data Modeller

Blackroc; Sydney; Hybrid; AUD 150.000 - 210.000; Vollzeit

Zusammenfassung

BLACKROC is partnering with a large Australian Government agency to recruit an EL1 Data Modeller in a 12-month initial contract with potential extension. The role offers hybrid work arrangements across Sydney, Melbourne or Brisbane, with 3 days in the office and 2 days working from home.

You will lead enterprise data modelling across multiple projects, turning complex business needs into governed, reusable semantic models for a single trusted source of numbers.

Qualifikationen

• Experience leading enterprise data modelling in large, complex environments with governance.
• Ability to translate business requirements into logical and physical models.
• Hands-on Snowflake experience: design, SQL, optimization, validation.

Aufgaben

• Lead design and governance of enterprise semantic models, datasets, KPIs and business metrics.
• Run requirements sessions with stakeholders and data architects and translate results into data models.
• Design enterprise-grade dimensional models using star schema with correct grain.

Kenntnisse

Enterprise data modelling

SQL development

Snowflake

Dimensional modelling

Power BI

Stakeholder engagement

Workshop facilitation

Governance standards

ER modelling

Metadata management

Tools

Snowflake

ERwin

Power BI

Jobbeschreibung

Duration: 12-month initial contract + 12-month extension
Location: Sydney, Melbourne or Brisbane
Work Arrangements: Hybrid, 3 days in the office and 2 days WFH
Start: Early December 2026

Company Overview

BLACKROC is partnering with a large Australian Government agency to recruit an EL1 Data Modeller.

Role Purpose

You’ll lead enterprise data modelling across several projects that support the agency’s modern data platform and analytics capability. You’ll work with architects, engineers, analysts and business stakeholders. Your job is to turn complex business needs into governed, reusable semantic models, so the whole organisation reports from one trusted version of its numbers.

Key Responsibilities

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs and business metrics
• Run requirements sessions with business stakeholders and data architects, and translate the results into logical, dimensional and semantic data models
• Design enterprise-grade dimensional models using star schema principles: facts, dimensions, hierarchies and the right level of detail (grain)
• Build and optimise presentation-layer tables, views and SQL transformations in Snowflake
• Develop reusable, scalable semantic models in Power BI, including measures, KPIs and business logic
• Tune model performance across relationships, cardinality, filter propagation and query performance
• Partner with data engineering on source data requirements and modelling challenges
• Enable reporting teams to use governed models instead of duplicating logic in each report

Required Skills & Experience

• Extensive experience leading enterprise data modelling in large, complex environments, including naming conventions, metadata, documentation and governance standards
• Proven ability to translate business requirements into logical, physical and semantic models
• Strong hands‑on Snowflake experience: presentation‑layer design, complex SQL, query optimisation and validating models against business requirements
• Expertise in ER modelling, dimensional modelling and normalisation, using ERwin or an equivalent tool
• Extensive experience building scalable semantic models for self‑service BI in Power BI or similar
• Excellent stakeholder engagement and workshop facilitation skills, including presenting to senior stakeholders
• Australian citizenship and the ability to obtain a Negative Vetting Level 1 clearance

Preferred Skills & Qualifications

• Experience with cloud data platforms such as AWS, Databricks, MS Fabric or Redshift
• 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 Australian Government or highly regulated industry experience

At BLACKROC Recruitment, we are committed to fostering diversity, equity, and inclusion. We welcome applications from individuals of diverse backgrounds, including those with lived experiences. If you require any adjustments during the recruitment process, please don’t hesitate to reach out to the above-mentioned BLACKROC Consultant.