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.

• 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 and 17.5% leave loading
• 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