Senior Data Modeller

At Sydney Water, we’re passionate about making a difference to the lives of our customers and communities, and our employees. We have a proud heritage and a progressive future, providing world class drinking water and beautiful waterways from the mountains to the sea. Our people and their jobs are as diverse as the communities we serve.

What You’ll Bring

Develop and deliver data models, data mappings, and business glossaries for data and analytics solutions.

Collaborate with business stakeholders to understand requirements, translate them into data needs, and facilitate data provisioning from source systems for analytics and reporting.

Work with the team to design, deliver, and document end-to-end data solutions, presenting proposed designs to business and developers for stakeholder approval.

Apply industry-standard capabilities, data models, and frameworks as governance mechanisms.

Engage with Sydney Water business SMEs, business analysts, and other resources for projects and engagement

Qualification and Experience

Bachelor’s degree in computer science or equivalent with demonstrated experience in delivery of data model and design for Data and analytics project delivery.

Either certification or proven experience in data architecture / modelling using Industry model.

Sound experience in a data modeller and/or similar role and significant years of experience in IT.

Demonstrated experience in Azure or other cloud-based data and analytics data platform

Broad expertise across data modelling capabilities, principles and policies

Skills Requirement

Strong experience in conceptual, logical, and physical data modelling

Deep knowledge of

Dimensional modelling (Star, Snowflake schemas)

ER modelling (3NF, normalized models)

Data Vault (preferred for modern architectures)

Expertise in

Slowly Changing Dimensions (SCD Types 1, 2, 3)

Handling hierarchical and complex relationships

Experience modelling data in Databricks Lakehouse architecture

Strong understanding of: Delta Lake (schema enforcement, evolution)

Ability to: Design Bronze, Silver, Gold layer data models

ERwin Data Modelling Tool

Advanced proficiency in ERwin Data Modeler

Experience in

Creating and maintaining enterprise data models

Performing forward and reverse engineering

Expertise in: Model versioning and change management

Ability to: Enforce data standards, naming conventions, and templates

Integration of ERwin with: Data governance and metadata tools

Applicants must be Australian Citizens or Permanent Residents.

Dive into Our Great Benefits

Competitive Compensation: We’ll ensure that your skills and contributions are valued and rewarded appropriately.

Hybrid Work Environment: We offer a hybrid work model that balances remote work and office collaboration, supporting our team's productivity and well-being.

Continuous Professional Growth: We will invest in your career with leadership and development programs to propel your success.

Novated Leasing: Get in the driver's seat of your financial future with our novated lease options.

Closing date: 21 June 2026

Please see the position description for the role’s full accountabilities.

For more information, you can contact ***email_hidden***

Sydney Water welcomes you to apply if you feel you meet the selection criteria. The successful completion of a Criminal History Check and Medical Assessment form part of the application process. Please advise if you require any adjustments to actively participate in the application and recruitment process.

Our vision is to create better lives through world-class services, and we believe that starts with our people. Our people and their jobs are as diverse as the communities we serve. Our diverse skills, mindsets and backgrounds work together on exciting and challenging projects that make a difference and help ensure Sydney remains one of the most iconic and liveable cities in the world.

We welcome and encourage applications from diverse backgrounds, including First Nations people, LGBTQIA+ people, people with disability, people with caring responsibilities, people from culturally and linguistically diverse backgrounds, and veterans.

As part of the application process, Sydney Water will be collecting your personal information to assess your suitability for the role. We will also use your personal information to establish a LiveHire talent profile in our Talent Community. We look at our Talent Community first when new opportunities come up when you apply for a role. Your personal information will be collected in accordance with LiveHire’s Terms, Privacy Policy and Sydney Water’s Privacy