Senior Data Modeller

Apply Job no: FGJPP Category: Finance, Commercial & Digital About us 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 protected] 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 Related documents Senior Data Modeller - 0051523 Published on 05 Jun 2026, 3:31 AM