About the Company 
This organisation is a large, well-established enterprise delivering essential services across Australia. Currently undergoing a significant data and analytics uplift, they are investing in modern cloud platforms to transform how data is managed, accessed, and leveraged across the business.

You’ll be joining a collaborative and forward-thinking environment where data is a key strategic priority, with the opportunity to influence platform design, establish best practices, and drive meaningful business outcomes. 
Responsibilities

• Translate complex business requirements into scalable ADLS Gen2 lakehouse and Azure Synapse Serverless SQL designs;

• Design, build, and optimise ELT pipelines using Synapse Pipelines / Azure Data Factory patterns;

• Develop and maintain curated data models, datasets, views, and semantic layers for reporting and analytics;

• Drive best practice across data modelling and lakehouse architecture;

• Monitor, tune, and optimise query performance, storage formats, and partitioning strategies;

• Ensure high standards of data quality, integrity, and governance across the platform;

• Contribute to data platform initiatives, including planning, delivery, and continuous optimisation; and

• Leverage modern tools, including AI-assisted development (e.g. Copilot), to enhance delivery efficiency.

Key Requirements

• Proven experience working as a Data Modeller within modern cloud data platforms (Azure Synapse / Fabric);

• Strong hands-on expertise with ADLS Gen2, Synapse Serverless SQL, and data integration tools;

• Demonstrated experience designing conceptual, logical, and physical data models across complex environments;

• Deep understanding of modelling methodologies (dimensional, Data Vault, 3NF, SCDs, conformed dimensions);

• Strong SQL (T-SQL) skills and experience with performance tuning and optimisation;

• Experience with data modelling tools (e.g. ER/Studio, erwin, Sparx EA, SQLDBM or similar);

• Solid understanding of data quality, governance, and testing frameworks;

• Experience working in Agile environments with strong stakeholder engagement skills;

• Exposure to Power BI and semantic modelling for reporting; and

• Excellent communication skills, with the ability to translate technical concepts to business audiences.

Nice to have:

• Exposure to Microsoft Fabric and platform modernisation initiatives;

• Familiarity with AI-assisted development tools (e.g. GitHub Copilot); and

• Exposure to machine learning concepts.

Benefits

• Opportunity to work on a large-scale data transformation program;

• Ability to shape and influence data modelling best practices;

• Collaborative, high-performing team environment;

• Flexible working arrangements; and

• Strong career growth and development opportunities.

How to Apply  
For more information or a confidential discussion please reach out to Nabil Boumoughdab at u&u on Nabil.boumoughdab@uandu.com quoting reference number 44894.  
 
At u&u Recruitment Partners, we value diversity, equity and inclusion. We welcome applications from Aboriginal and Torres Strait Islander people, people with diverse cultural and linguistic backgrounds and people with disability. 
 
Should you require reasonable adjustments or have a preferred method of communication throughout the recruitment process, we encourage you to make a request via adjustments@uandu.com or phone the above-mentioned u&u consultant to discuss. In response to these requests, we will collaborate closely with you to implement the appropriate adjustments. 
 
Additionally, for a barrier-free and inclusive online experience, you can access u&u’s opportunities using accessibility software Recite Me at https://www.uandu.com/jobs.  
 
Please submit your resume in Word format only.