Business Intelligence Developer

At Peter Mac we aim to continuously improve cancer care, research and education across all cancers and for all people affected by cancer: changing lives, breaking new ground. Everything we do is underpinned by our core values, Excellence, Compassion and Innovation. Welcoming people from a wide variety of different backgrounds and experiences is critical to fostering innovation, cultivating compassion, attracting and retaining top talent and providing the best possible cancer care for our patients.

YOUR ROLE IN OUR FUTURE

Business Intelligence Developer

• 12-month fixed term, full time position
• CBD location, with flexible, hybrid working
• Base salary + salary packaging + super + 5 weeks annual leave

About the team

The Business Intelligence and Analytics team operates the hospital's Azure-based data warehouse and analytics platform, which provides management reporting and performance insights across the organization. The team supports strategic decision-making and operational performance management for hospital leadership and department managers.

About the role

This role reports to the Manager of Business Intelligence and Analytics and will contribute to the design of data solutions, implementing pipelines, extending dimensional models, and developing reporting solutions. You'll work alongside an experienced data developer, and collaborate with data analysts to understand requirements and translate them into technical solutions, with the judgment to flag when exceptions or improvements make sense.

About you

You are someone that is conceptually strong who can understand our data architecture, work semi-independently on implementation, and bring thoughtful questions and suggestions when something could be improved.

You'll bring with you:

• Strong experience with Microsoft BI stack: SQL Server (T-SQL, query optimization), SSAS (tabular/multidimensional models), SSIS, Power BI
• Azure Data Factory: designing and implementing data pipelines, orchestration, and integration patterns
• Designing and implementing database systems, ETL/ELT pipelines, and data integration solutions
• Experience maintaining and extending existing OLAP cubes and dimensional data models
• Knowledge of performance tuning and monitoring across data pipelines and models (e.g. query plans, DAX optimisation, partitioning)
• Experience collaborating on enterprise data platforms and semantic layer design
• Understanding of data lifecycle management, including lineage, retention, and auditability
• End-to-end data delivery: development, testing, deployment, and version control (Git)
• Strong conceptual understanding of data modeling, data architecture, and BI design patterns
• Ability to provide input into data solutions, from business requirement to designing the technical approach
• Proactive problem-solving: identify issues, propose solutions, and challenge existing approaches when appropriate
• Ability to translate analyst requirements into technical solutions and troubleshoot data issues
• Strong communication skills for working with non-technical stakeholders (data analysts, managers)
• Self-directed with ability to work autonomously and manage priorities
• Experience with documentation tools (Confluence or similar)
• Attention to detail and commitment to data quality

Our benefits

We offer a range of benefits which support our people both personally and professionally, including:

• Up to $11,660 in salary packaging to increase your take home pay
• Discounted health insurance and eye care
• A comprehensive health and wellbeing program
• Public transport options at our doorstep and end of trip facilities for cyclists
• Onsite eateries and coffee shops and inviting rooftop garden spaces
• Pathways for professional development and new career opportunities
• Five weeks annual leave, 17.5% leave loading & purchased leave options
• Flexible, hybrid working practices

Inclusion and belonging

Peter Mac celebrates, values and supports a diverse and inclusive environment which reflects our vibrant community. We encourage applications from anyone identifying as Aboriginal and/or Torres Strait Islander. We also welcome anyone who identifies as LGBTQIA+, linguistically, culturally and/or gender diverse, people with disability, and people of any age to apply for our roles.

Join us

If you feel this role is right for you we warmly invite you to apply, and encourage your early application. All appointments are made subject to a satisfactory police check and may include vaccination requirements. Should you need assistance or require any adjustments or accommodations to fully participate in the application or interview process, you are welcome to reach out to the contact person listed. We acknowledge that not all applicants will meet the full list of selection criteria outlined, and wherever possible we will consider applications where relevant experience can apply.

Applicants to this role should provide a covering letter outlining relative key skills and experience to assist us with our assessment.

For further information about this opportunity, click Apply to be redirected to the Peter Mac Careers page where you can review the position summary. Alternatively, please contact us using the information below for a confidential discussion.

Hiring Manager: Sebastian Dubrovsky

Email:

Applications Close: 27 October 2025
______________________________________________________________________________________________________

Position Summary

The Business Intelligence and Analytics team operates the hospital's Azure-based data warehouse and analytics platform, which provides management reporting and performance insights across the organization. The team supports strategic decision-making and operational performance management for hospital leadership and department managers.

The role offers the chance to work with rich clinical and operational datasets where your solutions directly impact patient care quality and hospital performance - it's technically challenging work that matters.

With the hospital's EPIC EMR now operational, we're continuously expanding our data coverage and analytical capabilities to support more sophisticated decision-making across the hospital. This is primarily a development role (80%) with some maintenance responsibilities (20%). We're actively modernizing our platform (transitioning from SSIS to Azure Data Factory, optimizing our tabular models) so there's opportunity to work with both established and emerging technologies.

This role reports to the Business Intelligence Manager and will contribute to the design of data solutions, implementing pipelines, extending dimensional models, and developing reporting solutions. You'll work alongside an experienced data developer, and collaborate with data analysts to understand requirements and translate them into technical solutions, with the judgment to flag when exceptions or improvements make sense.

We need someone conceptually strong who can understand our data architecture, work semi-independently on implementation, and bring thoughtful questions and suggestions when something could be improved.

Enterprise Agreement
Health and Allied Services, Managers and Administrative Workers (Victorian Public Sector) (Single Interest Employers) Enterprise Agreement Classification or Salary Range
HS4 Immunisation Risk Category
Immunisation Category C Key Relationships

Internal

• Business Intelligence and Analytics team 
• Information Technology 
• Users and creators of data within the organisation including clinicians, data managers, finance and HR staff

External

• Peers in other health organisations
• Software and Application suppliers and vendors

Education
Skills

Essential Requirements 

• Strong experience with Microsoft BI stack: SQL Server (T-SQL, query optimization), SSAS (tabular/multidimensional models), SSIS, Power BI
• Azure Data Factory: designing and implementing data pipelines, orchestration, and integration patterns
• Designing and implementing database systems, ETL/ELT pipelines, and data integration solutions
• Experience maintaining and extending existing OLAP cubes and dimensional data models
• End-to-end data delivery: development, testing, deployment, and version control (Git)
• Strong conceptual understanding of data modeling, data architecture, and BI design patterns
• Ability to provide input into data solutions, from business requirement to designing the technical approach
• Proactive problem-solving: identify issues, propose solutions, and challenge existing approaches when appropriate
• Ability to translate analyst requirements into technical solutions and troubleshoot data issues
• Strong communication skills for working with non-technical stakeholders (data analysts, managers)
• Self-directed with ability to work autonomously and manage priorities
• Experience with documentation tools (Confluence or similar)
• Attention to detail and commitment to data quality

Desirable Requirements 

• Healthcare sector experience, particularly Victorian public hospital data systems
• Familiarity with EMR/electronic medical system data structures
• Experience with Azure data services (Data Factory, Synapse, or similar)
• Performance tuning for large healthcare datasets
• Understanding of healthcare data privacy and compliance requirements

Certifications, Licenses & Registrations
Key Accountabilities

Key Accountabilities 
Demonstrated by / Key Performance Indicators 

1. Data Platform Development and Maintenance

• Maintain and optimize the data warehouse, tabular models, and OLAP cubes ensuring data accuracy and performance
• Design and implement new data pipelines using ADF and SSIS to extend data coverage
• Build and maintain dimensional models that support efficient analytics and reporting
• Develop semantic models that meet analyst requirements
• Manage deployments through testing, version control, and production releases

2. Technical Problem Solving

• Troubleshoot data quality issues, pipeline failures, and performance bottlenecks
• Respond to urgent data requests and system issues
• Translate analyst requirements into technical specifications and solutions
• Identify opportunities to improve existing data infrastructure.

3. Delivery & Collaboration

• Balance ongoing maintenance, planned enhancements, and ad-hoc requests
• Work autonomously while keeping the manager and team informed of progress and blockers
• Provide technical guidance to analysts on data structure and availability

Key Accountabilities (Contd..)

______________________________________________________________________________________________________

For further information about this opportunity, click Apply to be redirected to the Peter Mac Careers page where you can review the position profile. Alternatively, please contact us for a confidential discussion.

Peter Mac is a child safe organisation and has a commitment to child safety and wellbeing.

WHY WORK FOR PETER MAC

• Peter Mac offer a range of benefits which support our people both personally and professionally.
• Our staff benefits include award winning facilities, professional development and events, a health and wellbeing program, flexible work practices and policies and financial benefits such as salary packaging.
• We encourage applications from Aboriginal and Torres Strait Islander people, all members of the LGBTQI community and people with a disability.

---