Business Intelligence Developer
MELBOURNE, VIC, AU, 3000
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: Sebastian.Dubrovsky@petermac.org
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
Classification or Salary Range
Immunisation Risk Category
Key Relationships
| Internal |
|
| External |
|
Education
Skills
| Essential Requirements |
|
| Desirable Requirements |
|
Certifications, Licenses & Registrations
Key Accountabilities
| Key Accountabilities | Demonstrated by / Key Performance Indicators |
| 1. Data Platform Development and Maintenance |
|
| 2. Technical Problem Solving |
|
| 3. Delivery & Collaboration |
|
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.