At a Glance
- Tasks: Lead enterprise data modelling and create reusable semantic models for a major government agency.
- Company: Join BLACKROC, partnering with a large Australian Government agency.
- Benefits: Hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Diverse and inclusive workplace with excellent career advancement opportunities.
- Why this job: Make a real impact on data analytics while working with cutting-edge technologies.
- Qualifications: Extensive experience in data modelling and strong Snowflake skills required.
The predicted salary is between 90000 - 110000 $ per year.
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.
Data Modeller in Sydney employer: Blackroc
At BLACKROC, we pride ourselves on being an exceptional employer, offering Full Stack Developers the chance to work on impactful projects within a supportive and inclusive environment. Located in Brisbane, our team enjoys flexible work arrangements, including two days of remote work, and is dedicated to fostering professional growth through hands-on experience with cutting-edge technologies like AWS and modern development frameworks. Join us to be part of a collaborative culture that values diversity and empowers you to take ownership of your work while contributing to meaningful government initiatives.
