Data Modeller

Talent; Canberra; Hybrid; AUD 120,000 - 160,000; Full time

Job summary

Talent is seeking a Data Modeller to own the full modelling lifecycle for enterprise data warehouse initiatives. You will lead conceptual, logical and physical modelling across multiple environments, and contribute to standards and data dictionary practices.

You will develop SQL analytical and ETL code, collaborating with data consumers, developers, testers and support teams to ensure consistent delivery and quality.

Qualifications

• Strong experience in enterprise data modelling using metadata or model-driven frameworks.
• Ability to lead development of conceptual, logical and physical data models across EDW environments.
• Experience with data dictionary practices, standards and peer reviews.

Responsibilities

• Lead conceptual, logical and physical data modelling across enterprise data warehouse initiatives.
• Own data dictionary development, modelling standards, peer review and release practices.
• Develop and maintain SQL analytical and ETL code while supporting technical implementation.
• Work with data consumers, developers, testers and support teams to improve quality and delivery.

Skills

Enterprise data modelling

Strong SQL capability

DevOps basics

Tools

MS SQL

Teradata

Snowflake

Redshift

Databricks

Python

SAS

R

Java

AWS S3

AWS Glue

Job description

Data Modeller | Enterprise Data Modelling, EDW & Metadata

• Location: ACT / NSW (Hybrid)
• Security Clearance: Baseline-Cleared (Mandatory)
• Contract Length: 12 Months + 12 Month Extension (Based on the Department's sole discretion)

About the Position:

This is a data modelling role with genuine ownership across the full modelling lifecycle.

You'll lead the development of conceptual, logical and physical data models across enterprise data warehouse environments, while helping establish the standards, review processes and data dictionary practices that keep those models consistent and usable.

The role sits close to both data engineering and analytics. You'll work from requirements through to technical implementation, collaborate with developers, testers and data consumers, and contribute to the SQL and ETL work that supports delivery.

There is also a strong capability uplift component. You'll help improve modelling standards, documentation, release practices and knowledge sharing across the team.

What You'll Do:

• Lead conceptual, logical and physical data modelling across enterprise data warehouse initiatives.

• Own data dictionary development, modelling standards, peer review and release practices.

• Develop and maintain SQL analytical and ETL code while supporting technical implementation from analysis through to delivery.

• Work closely with data consumers, developers, testers and support teams to improve modelling quality and delivery consistency.

What We Are Looking For:

• Strong experience in enterprise data modelling using metadata or model-driven frameworks

• Demonstrated capability across at least two enterprise data warehouse technologies such as MS SQL, Teradata, Snowflake, Redshift or Databricks.

• Strong SQL capability, including experience reverse-engineering complex end-user SQL and reviewing technical code.

• Understanding of DevOps, version control and modern delivery practices, supported by programming capability across languages such as Python, SAS, R or Java.

Technology & Environment:

• Conceptual, Logical & Physical Data Modelling

• MS SQL, Teradata, Snowflake, Redshift & Databricks

• SQL, ETL, Metadata & Data Dictionary Management

• AWS S3, AWS Glue, SAS, DevOps & Version Control

Applicants must be Australian Citizens and hold a Baseline Security Clearance.