Data Warehouse Developer, Centre for Vic Data Linkage

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

Benefits offered by this job

Growth and development opportunities

Flexible working arrangements

Meaningful work contributing to Victor

Job summary

Department of Health Victoria's Centre for Victorian Data Linkage in Melbourne seeks a Data Warehouse Developer to design, build, automate and support data integration and warehousing solutions across Microsoft SQL Server, Azure and Databricks.

You will onboard datasets, develop ETL processes, and create data assets while documenting technical specs and data models. The role emphasizes reliability, governance and collaboration in a public health setting.

Qualifications

• 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.

Responsibilities

• Design, develop, and maintain data integration and ETL processes.
• Onboard new datasets and build derived data assets.
• Develop data warehouse solutions across SQL Server, Azure and Databricks.
• Prepare and maintain data models and data dictionaries.

Skills

SQL Server

T-SQL

ETL

Azure Data Factory

Azure SQL

Databricks

Education

Tertiary qualification in Information Technology

Job description

Data Warehouse Developer, Centre for Vic Data Linkage

Department of Health Victoria – Melbourne VIC

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.

We are committed to developing and supporting a workforce that is well equipped and highly motivated to provide responsive and quality services to all Victorians. We continue to build an inclusive workplace that embraces diversity of backgrounds and differences to realise the potential of our employees for innovation and delivering services aimed at enhancing the lives of all Victorians. All roles can be worked flexibly and we encourage applications from Aboriginal people, people with disability, LGBTIQ+ and people from culturally diverse backgrounds. Please contact us if you require any adjustments to participate in the recruitment process at*********@health.vic.gov.au. For more information on our commitment to inclusion and diversity seeinclusion and diversity at the Department of Health.

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.