Data Warehouse Developer, Centre for Vic Data Linkage

Department of Health; City of Melbourne; On-site; AUD 90,000 - 130,000; Full time

Job summary

The Department of Health seeks a Data Warehouse Developer within the Centre for Victorian Data Linkage to design, develop and maintain data integration, ETL and warehouse solutions across SQL Server, Azure and Databricks platforms. The role involves technical design, development, implementation, monitoring and maintenance of complex ETL processes and onboarding new datasets.

You will contribute to data models, data dictionaries and operational procedures, supporting policy development and

Qualifications

• Experience with Microsoft SQL Server and T-SQL, including queries, procedures, views and indexes.
• Experience developing, maintaining or supporting data extraction, transformation and loading processes.
• Experience with Microsoft Azure data products, such as Azure SQL and Azure Data Factory.
• Ability to prepare clear technical documentation, including data models, data dictionaries and operating procedures.

Responsibilities

• Design, develop, automate and support data integration, data warehouse and analytical data processing solutions.
• Onboard new datasets and develop derived data assets.
• Improve operational resilience of data processing frameworks.

Skills

SQL Server

T-SQL

ETL

Azure Data Factory

Documentation

Education

IT qualification

Job description

Data Warehouse Developer, Centre for Vic Data Linkage

The Department of Health plays a critical role in the Victorian health system and is responsible for shaping it to meet the health needs of all Victorians. We’re focused on
supporting Victorians to be as healthy as they can; whether through alerting them to seasonal risks like thunderstorm asthma, notifying them of contact with
communicable diseases, safeguarding their drinking water, developing the best health, wellbeing and care facilities in the world, being at the forefront of mental health and
wellbeing treatment or accelerating medical research. It’s all part of the way we partner with the community to help every individual lead a healthy life.

About the role:

The Data Warehouse Developer is located within the Centre for Victorian Data Linkage, Victoria's specialist data linkage agency. CVDL acquires, integrates and links administrative and clinical datasets for policy development and research purposes.

The role designs, develops, automates and supports data integration, data warehouse and analytical data processing solutions across Microsoft SQL Server, Azure and Databricks platforms. This includes the technical design, development, implementation, monitoring and maintenance of complex ETL and data transformation processes, onboarding new datasets, developing derived and value-added data assets, and improving the operational resilience of data processing frameworks.

About us:

At the Victorian Department of Health we want a future where Victorians are the healthiest people in the world. A Victoria where our children and people thrive, our workplaces are productive and safe, and our communities are more connected.

We see it as our job to support Victorians to stay healthy and safe. And to deliver a world-class healthcare system that ensures every single Victorian can access safe, quality care that leads to better health outcomes for all.

About you:

• A tertiary qualification in Information Technology would be desirable.
• Experience with Microsoft SQL Server and T-SQL, including developing queries, stored procedures, views and indexes.
• Experience developing, maintaining or supporting data extraction, transformation and loading processes.
• Experience with Microsoft Azure data products, such as Azure SQL and Azure Data Factory.
• Ability to prepare clear technical documentation, including data models, data dictionaries, technical specifications and operational procedures.

What we offer:

• The opportunity to perform meaningful work, making direct contributions toward enablingVictorians to be the healthiest people in the world.
• A wide range of growth and development opportunities within the department and wider Victorian Public Service.
• A strong commitment to work-life balance, including a diverse array of flexible working arrangements.

Preferred applicants may be required to complete a police check and other pre-employment checks. Information provided will be treated in line with our Privacy Policy.