The Royal Melbourne Hospital is one of Australia’s leading public healthcare providers. Join the team. Build a career. We are looking for a passionate and dedicated individual to join The Royal Melbourne Hospital.

Business Intelligence Developer

The Royal Melbourne Hospital

•  Full time, 18-month fixed term opportunity!
• Join our Health Intelligence team and play a critical role in integrating complex healthcare data systems
• Design and develop robust ETL processes to extract, transform and load data into our enterprise data warehouse

About The Royal Melbourne Hospital

The Royal Melbourne Hospital (RMH) part of the Parkville Precinct and is one of Australia's leading public hospitals, providing a comprehensive range of specialist medical, surgical, and mental health services, as well as rehabilitation, aged care, specialist clinics and community programs.

RMH is seeking a skilled Business Intelligence Developer to join our Health Intelligence team. Reporting to the Lead Warehouse Architect, you will play a critical role in integrating PowerBilling & Revenue Collection (PBRC) data into our enterprise data warehouse, along with other source systems. You'll work closely with the Health Intelligence team, IT infrastructure teams, and business stakeholders to design, develop, and implement robust data integration solutions.

Benefits of working at RMH

• Salary packaging options, earn up to $12,000 tax free earnings!
• 5 weeks annual leave plus monthly ADO's for full time employees
• Flexible working arrangements including remote work options
• Discounted gyms and health centre access with Fitness Passport
• Fantastic learning and development opportunities
• RMH prides ourselves on our Speaking Up for Safety Culture and our values -- People First, Lead with Kindness and Excellence together!

About the role:

• Design and develop ETL processes to extract data from source systems and transform it to meet data warehouse standards
• Implement comprehensive data quality checks, validation procedures and optimize data loading processes for performance
• Develop and maintain data models that support reporting requirements and create optimized database structures
• Establish data integration schedules, monitoring procedures and alerting systems for integration failures
• Collaborate with business users to understand data requirements and provide technical guidance on data availability and best practices

About you

Qualification

• Bachelor's degree in Computer Science, Information Systems, or related field

Essential

• Minimum 5 years' experience in business intelligence and data integration
• Strong expertise in SQL, database design, and data warehousing concepts
• Strong understanding of the Microsoft SQL Server Stack (SSMS, SSAS, and SSIS in particular)
• Knowledge of data modelling techniques and dimensional modelling
• Advanced analytical and problem-solving capabilities with excellent communication skills

Desirable

• Experience in healthcare or hospital environments
• Experience in translation of data for improvement and health care audiences
• Experience working with a complex enterprise data warehouse
• Understanding of healthcare revenue cycle and billing processes
• Proven ability to complete data extractions and transformations

Click here to view the full position description

Interested? Click on the apply button! We will be arranging interviews as soon as suitable applicants come in.

All appointments are made subject to a satisfactory Criminal History Record Check. Successful applicants will be required to provide evidence of an immunisation assessment prior to commencement.

The RMH stands in solidarity with Aboriginal and Torres Strait Islander people in work and care. We are proud to be a workplace that champions diversity, inclusion and equality for our staff and our community.  Our goal is for our people to feel safe, included and supported so that they can be at their best every single day. We encourage talented people from all backgrounds, abilities, and identities to apply to our vacancies, and will consider adjustments to support such applications.