Power BI & Data Analyst

St John Ambulance NSW; Sydney; Hybrid; AUD 110,000 - 140,000; Full time

Benefits offered by this job

Salary packaging benefit

Birthday leave

Job summary

St John Ambulance NSW seeks a hands-on Power BI specialist to own reporting, build automated reports and transform financial and operational data into clear insights. You will shape the data platform as Microsoft Fabric evolves and collaborate with stakeholders across finance and operations.

Join a trusted not-for-profit and drive data governance, automation, and scalable BI solutions with a focus on accuracy and actionable insights.

Qualifications

• Proven commercial experience building and supporting Power BI solutions end to end.
• Advanced DAX and Power Query skills, and sound data modelling (including star schema).
• Solid SQL for querying, preparing and validating data.
• Experience integrating data from multiple systems and automating data preparation.
• Hands-on experience with the Power BI Service, including scheduled refresh, gateways and Row Level Security.
• Strong analytical skills, with experience in financial or operational analysis and advanced Excel.
• Close attention to detail and the habit of checking your numbers against the source.
• The confidence to question requests and recommend the simplest solution that works.
• Clear communication with non-technical people.
• A tertiary qualification in a related field, or equivalent experience.

Responsibilities

• Design, build and maintain Power BI reports, dashboards and semantic models used across finance, operations and member services.
• Write DAX, Power Query and SQL to bring together data from multiple systems.
• Build data integration pipelines and dataflows, including in Microsoft Fabric as we adopt it, so data is modelled once and reused.
• Automate data refreshes and routine tasks with Power Query, Fabric and Power Automate, removing manual, spreadsheet-based steps.
• Build validation and reconciliation checks into reports so issues are caught before they reach users.
• Manage our Power BI Service, including workspaces, refresh schedules, access and Row Level Security.
• Analyse financial and operational data, explain what it means in plain language and recommend action.
• Help set and apply data governance standards: definitions, ownership, certified datasets and access controls.
• Keep a register of our reports, review it with the business and retire what is not adding value.
• Document reports and processes so they do not depend on any one person, and train backup users.
• Work with system owners and IT on data quality, system changes and testing, including data migration for our move to Business Central.

Skills

Power BI

DAX

Power Query

SQL

Data modelling

Microsoft Fabric

Power Automate

Data integration

Education

Tertiary qualification in a related field

Tools

Microsoft Fabric

SQL

Power BI Service

Job description

Salary packaging benefits available – access up to $15,900 General benefits plus an additional $2,650 Meal & Entertainment card tax-free, helping you reduce your tax and increase your take-home pay.

Competitive Salary + Salary Packaging Benefit + Birthday Leave

Join one of Australia's most trusted First Aid Organisations

Hybrid work from head office, home and on site at various locations

St John Ambulance NSW is a for purpose not-for-profit organisation committed to saving lives through first aid. Our voluntary first aid work is enabled through the delivery of first aid training, products and services that support communities across New South Wales. Driven by our values of Respect, Integrity, Leadership, Communication and Collaboration, we are one of Australia's most recognised and trusted brands. Every commercial partnership and revenue opportunity we secure helps fund programs that build safer, healthier and more resilient communities.

St John Ambulance NSW is looking for a hands-on Power BI specialist with strong analytical skills to own our reporting environment and help our leaders make better, data-informed decisions. You will build reliable, automated Power BI reports, turn financial and operational data into clear insight, and bring structure and discipline to how data is integrated, automated and governed across the organisation. It is a chance to help shape our data platform as our Microsoft environment evolves, including Microsoft Fabric.

About the Role

Reporting to the Chief Financial Officer, you will be our go-to person for Power BI and data analysis. Our Power BI environment has grown over time to cover a wide range of needs, and some of it relies on manual effort to keep running. A big part of this role is helping us get that right: agreeing with the business what is genuinely needed, automating and documenting what we keep, and recommending where a source system’s own reporting would do the job better.

You will also work with our system owners and technology team on data quality, system changes and testing. Systems support is part of the role, but Power BI and analysis are at its core.

What You Will Do

• Design, build and maintain Power BI reports, dashboards and semantic models used across finance, operations and member services.
• Write DAX, Power Query and SQL to bring together data from multiple systems.
• Build data integration pipelines and dataflows, including in Microsoft Fabric as we adopt it, so data is modelled once and reused.
• Automate data refreshes and routine tasks with Power Query, Fabric and Power Automate, removing manual, spreadsheet-based steps.
• Build validation and reconciliation checks into reports so issues are caught before they reach users.
• Manage our Power BI Service, including workspaces, refresh schedules, access and Row Level Security.
• Analyse financial and operational data, explain what it means in plain language and recommend action.
• Help set and apply data governance standards: definitions, ownership, certified datasets and access controls.
• Keep a register of our reports, review it with the business and retire what is not adding value.
• Document reports and processes so they do not depend on any one person, and train backup users.
• Work with system owners and IT on data quality, system changes and testing, including data migration for our move to Business Central.

About You

To be successful in this role, you will bring:

Proven commercial experience building and supporting Power BI solutions end to end.

Advanced DAX and Power Query skills, and sound data modelling (including star schema).

Solid SQL for querying, preparing and validating data.

Experience integrating data from multiple systems and automating data preparation.

Hands‑on experience with the Power BI Service, including scheduled refresh, gateways and Row Level Security.

Strong analytical skills, with experience in financial or operational analysis and advanced Excel.

Close attention to detail and the habit of checking your numbers against the source.

The confidence to question requests and recommend the simplest solution that works.

Clear communication with non‑technical people.

A tertiary qualification in a related field, or equivalent experience.

Highly regarded

• Experience with Microsoft Fabric (lakehouses, Dataflows Gen2 or pipelines) or Azure data services.
• Experience with Power Automate.
• Experience with Dynamics 365 Business Central or other ERP data, including ERP migrations.
• Experience with CRM, contact centre, finance system data.

Why Join Us?

Own and shape Power BI, data integration and analytics at a well‑known not‑for‑profit, as we modernise our Microsoft data platform.

Work directly with the key stakeholders including the Executive team, Sales and Operations teams, with real influence on how reporting is done.

Hybrid working, with a minimum of 3 days per week in our Macquarie Park office and the balance from home.

A chance to make a real difference to the community and to commercial outcomes.

If you enjoy turning complex data into reporting people trust, and can explain what the numbers mean, we would love to hear from you.

Applications will be reviewed as they are received so candidates are encouraged to get in early.

Please note that we require you to obtain a Working with Children's Check and Police Check.

St John Ambulance (NSW) is committed to providing an inclusive workforce and encourages applications from people of culturally diverse backgrounds, including those who identify as part of the Australian Aboriginal and/or Torres Strait Islander Community

St John Ambulance (NSW) cares about keeping children and young people safe.Protecting and promoting the emotional, physical, cultural, and spiritual wellbeing of children and young people is central to all aspects of the operations and culture of St John Ambulance (NSW).St John Ambulance (NSW) commits to creating and maintaining an environment where members act in the best interest of children and young people and has zero tolerance to any form of abuse.