Data Modeller

Data Engineering and Analytics Specialist Recruitment Consultant

Snowflake / SQL

We’re looking for a Data Modeller / Principal Data Modeller to design clear, consistent data models that power analytics, drive trustworthy insights, and underpin transformation across the business.

In this role, you’ll lead conceptual, logical, and physical modelling across cloud (Snowflake on AWS) and on-prem sources, define standards and patterns (dimensional, Data Vault, 3NF), and partner with data engineers, analysts, and product teams to deliver governed, high‑performing data assets.

What you’ll do

• Translate business needs into conceptual, logical and physical data models and data contracts.
• Design and maintain dimensional / star schemas, Data Vault 2.0 structures, and reference / master data domains.
• Own canonical definitions, entities, and relationships; steward business glossaries and semantic layers / metrics.
• Guide model implementation in Snowflake (schemas, views, materialisations) and SQL Server / Oracle where needed.
• Define modelling and testing standards in dbt (docs, tests, exposures) and ensure lineage is captured (e.g., OpenLineage).
• Collaborate with data engineers on efficient ELT patterns and with BI teams to optimise models for Tableau / Power BI.
• Establish governance across metadata, naming, versioning, privacy and retention; contribute to cataloguing (e.g., Amundsen).
• Review designs, run modelling workshops, and produce clear documentation and ERDs.

What you’ll bring

Base pay range : A$145,000.00 / yr - A$165,000.00 / yr

If you’re passionate about clear data design, strong governance, and models that make analytics effortless, we’d love to hear from you.

Click apply now or send your CV to dan.wotherspoon@changerecruitment.com.au

#J-18808-Ljbffr