Description:
About the role:
The Principal Data Engineer responsible for a data platform usually plays a significant and wide-ranging role within an organisation. This includes, but is not limited to, designing the architecture, building and maintaining cloud-based data warehouses and ETL processes, implementing technical standards, and offering advisory support to various stakeholders.
The Principal Data Engineer will be responsible for supporting key platforms, including Common Data Layer (CDL), Advanced Analytics Platform (AAP), VAHI Information Management Environment (VIME), and other platforms within Data Services domain as determined by leadership priorities.
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:
We are looking for someone who can:
- Provide leadership, guidance and authoritative advice to internal and external stakeholders and prepare and present detailed and comprehensive reports.
- Deliver high-quality business intelligence, authoritative advice, and recommendations to senior management on the technical aspects of data profiling and integration, as well as development and advisory services to a diverse range of stakeholders.
- Provide ETL development expertise to create physical models from requirements and conceptual/logical models; reverse engineer code and algorithms from legacy systems as needed and develop comprehensive ETL processes from source data to future data models.
- Provide timely expert advice and develop open and effective communication strategies including collection of highly complex, contentious, or sensitive information on matters of staff or business.
- Manage and oversee the full life cycle of projects to meet departmental objectives
Qualifications / Specialist Expertise
- A relevant IT related degree or qualification related to information management is required for this role.
- Extensive demonstrated experience and expertise in designing, developing, and supporting data warehousing, ETL and analytic and reporting assets from complex and disparate administrative data sources.
- Experience using the following Azure components essential:
- Azure SQL
- Azure Data Factory
- Azure Databricks
- Azure Active Directory
- Azure Functions
- Azure Web App
- Azure Analysis Services
- Advanced skills in SQL and SSIS and demonstrated experience in an Azure environment.
- Experience in Python / PySpark.
- Experience in Microsoft Fabric.
- Experience developing within a Kimball star schema data warehouse.
- Extensive demonstrated experience in visualisation and communication of complex datasets using business intelligence tools such as Power BI.
- Experience designing and developing tabular cubes.
- Can read and write DAX and MDX.
- Can work with SME's, Scrum Master, Business Analyst, and other internal and external customers to extract requirements to build test cases.
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 inclusion@health.vic.gov.au . For more information on our commitment to inclusion and diversity see inclusion 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 the strictest confidence in line with our Privacy Policy . If you have any queries in relation to the application or recruitment processes, please email talentacquisition@health.vic.gov.au .