About the role:
The Data Warehouse developer is located within the Centre for Victorian Data Linkage (CVDL), Victoria's specialist data linkage agency. CVDL acquires and links together 40 plus administrative and clinical datasets for policy development and research purposes.
The role designs, develops, and supports data linkage and analytics data warehouse and ETL processes. This includes technical design, development, implementation and maintenance of large and complex SQL databases and data transformation. The role involves extraction of administrative and clinical datasets from various sources and automating extraction where possible. In addition, the Data Warehouse Developer will assist in the implementation of PowerBI reports and documentation.
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:
Can you demonstrate the following?
* Provide technical design, development, implementation of large and complex SQL databases to support data linkage and integration processes and advanced analytics.
* Utilise Microsoft Azure data products (e.g. Data Factory) to build end-to-end ETL processes from a variety of data sources.
* Provide expert input to projects to improve the quality and effectiveness of data linkage and integration processes and access to and usability of the de-identified linked data resource.
* Build and maintain effective working relationships with key stakeholders including data administrators, data analysts and policy and program staff.
* Communicate complex technical information and concepts to a range of stakeholders including non-technical audiences.
* Develop and maintain relevant technical specifications and documentation to facilitate usage of the integrated data resource.
Qualifications / Specialist Expertise
Qualifications
* A tertiary qualification in Information Technology would be desirable.
* Minimum of 2 years' experience in a similar role
* Experience in agile methodologies is desirable
Specialist Expertise
* Demonstrated experience in:
* Microsoft SQL Server RDBMS.
* Delivery of large scale, information management, information governance and analytics solutions.
* Experience with some of the Microsoft Azure data products including:
* Azure SQL
* Data Factory
* Minimum 2 years of experience with Microsoft SQL Server stack (SSAS, SSRS, SSIS).
* Minimum 2 years of experience with T-SQL skills including creating stored procedures, views, and indexes as well as performance tuning queries.
* Experience in data modelling and the understanding of data structures (relational tables, normalised etc).
* Performance tuning of resources for efficient and fast running processes.
* Experience using Azure DevOps release pipelines.
* Experience in unit testing their work and achieving this primarily with automation.
* Experience in preparing documentations such as, Data Models, Release Documents, Data Dictionaries etc.
* Exposure to Databricks platforms considered a strong advantage.
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 & Sector.
* A strong commitment to work-life balance, including a diverse array of flexible working arrangements.
How to apply:
Applications should include a resume and a cover letter. Click the `Apply' button to view further information about the role including key contact details and the advertisement closing date.
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 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 recruitment processes at Health, or experience any issues in applying, please feel free to email Please note that unsolicited applications will not be replied to. If you have questions regarding the role specifically, we would advise you to reach out to the contact listed on the advertisement directly.
Preferred applicants may be required to complete a police check and other pre-employment checks. Information provided will be treated in the strictest confidence in line with our Privacy Policy.