Power BI & Data Analyst - Hybrid, Governance & Insights

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

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.