Senior Data Modeller / Azure Data Engineer
Senior Data Modeller / Azure Data Engineer
Long term Contract | Immediate Start | Flexible Hybrid | Sydney (Eveleigh/Redfern)
We are seeking an experienced Senior Data Modeller / Azure Data Engineer to join a major transformation program within a large NSW Government organisation. This is a unique opportunity to play a key role in designing and delivering a modern data platform while helping shape the organisation’s future-state data architecture.
This role is ideal for someone who enjoys solving complex data challenges, working with imperfect legacy environments, and combining strong data modelling expertise with hands-on Azure data engineering capabilities.
About the Role
As a Senior Data Modeller / Azure Data Engineer, you will work closely with Data Engineers, Technical Business Analysts, business stakeholders, and external vendors to design, build, and optimise enterprise data solutions.
You will be responsible for developing dimensional data models, supporting data migration initiatives, improving data quality, and contributing to the design of a scalable Azure-based data platform.
This is not a pure modelling role. We’re looking for someone who can confidently move between data architecture, modelling, engineering, and stakeholder engagement.
Key Responsibilities
* Design and develop enterprise-scale dimensional data models and star schemas
* Analyse and interpret complex legacy data structures
* Profile source data and identify data quality issues
* Build and support Azure-based data engineering solutions
* Develop and optimise SQL queries, data pipelines, and transformations
* Support data migration and integration activities
* Create and maintain data documentation and technical findings
* Collaborate with business stakeholders, vendors, and technical teams
* Support the redevelopment of Power BI reporting solutions
* Contribute to the design of the organisation’s future-state data platform
Required Skills & Experience
* Strong experience in Dimensional Data Modelling and Star Schema design
* Hands-on experience with:
o Azure Synapse Analytics
o Azure SQL
o Azure Data Lake Storage
o Python and PySpark
o Git / Version Control
* Advanced SQL skills, including complex data analysis and reconciliation
* Experience implementing Medallion Architecture (Bronze, Silver, Gold layers)
* Strong understanding of data warehousing principles and best practices
* Experience working with large, complex, and imperfect datasets
* Ability to investigate, diagnose, and document data quality issues
* Excellent written and verbal communication skills
Highly Regarded
* Microsoft Dynamics CRM
* Dataverse
* Power BI
* Metadata-driven ELT frameworks
* Data migration and modernisation projects
* NSW Government experience
What’s on Offer?
* Immediate start opportunity
* Initial 6-month contract with strong extension potential
* Flexible hybrid working environment
* Opportunity to contribute to a significant data transformation program
* Collaborative and supportive team environment
* Exposure to modern Azure technologies and enterprise-scale data initiatives
If you are a hands-on Data Modeller who enjoys working across both modelling and engineering disciplines and wants to make a tangible impact on a large-scale transformation program, we’d love to hear from you.
Apply now or contact anastasia.kikteva@talentinternational.com.