Data Warehouse Developer, Centre For Vic Data Linkage

Victorian Department of Health; City of Melbourne; Hybrid; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Growth opportunities

Flexible working arrangements

Work-life balance

Job summary

Victorian Department of Health is seeking a Data Warehouse Developer to design, develop, automate and support ETL and data processing across SQL Server, Azure and Databricks. You will onboard new datasets, create derived data assets and improve operational resilience of data pipelines.

The role requires experience with MS SQL Server, T-SQL and Azure data products, plus the ability to document data models and technical specs. Flexible work arrangements are available.

Qualifications

• Tertiary IT qualification desirable.
• Experience with MS SQL Server and T-SQL: queries, procedures, views, indexes.
• Experience developing, maintaining or supporting ETL processes.
• Experience with Azure data products (Azure SQL, Azure Data Factory).

Responsibilities

• Design, develop, test and maintain data integration, ETL and data processing solutions.
• Develop data warehouse solutions across SQL Server, Azure and Databricks platforms.
• Onboard new datasets and build derived data assets and data dictionaries.
• Document technical specifications, data models and operational procedures.

Education

Bachelors in IT/CS

Data warehousing concepts

Tools

SQL Server

Azure SQL

Azure Data Factory

Job description

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 enabling Victorians 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 [e-mail]. For more information on our commitment to inclusion and diversity see inclusion and diversity at the Department of Health. If you have any queries in relation to participation in recruitment processes at Health, or experience any issues in applying, please feel free to email [e-mail].

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.