Business Intelligence Analyst
- Develop and maintain enterprise Power BI dashboards, reports and semantic models using SQL, Power Query and DAX.
- Analyse and validate data, define consistent KPIs, and translate trends and findings into useful business insights.
- Partner with stakeholders and technology teams to gather requirements, improve reporting quality and support data governance.
Why join us at SCC?
We have a long history of providing exceptional care that empowers older people to live a full life. When you join us, you will be provided with not-for-profit salary packaging benefits and the support of an experienced leadership team.
At Southern Cross Care (NSW & ACT), We're transforming the way we support older Australians across Residential Aged Care, Home Care, Retirement Living and Corporate Services.
Role/Title: Business Intelligence Analyst
Location: Epping Head Office, NSW
Employment Type: Full Time
About the Role
As a Business Intelligence Analyst, you'll turn data into meaningful insights that drive smarter decisions and better business outcomes. Working with teams across the organisation, you'll deliver impactful Power BI dashboards and enterprise reporting solutions that help shape our future.
If you're passionate about data, enjoy solving business challenges and want your work to make a difference, we'd love to hear from you!
What You'll Do
Business Intelligence and Reporting
- Design, develop, maintain and enhance enterprise reports, Power BI dashboards, visualisations and semantic models using SQL, Power Query, DAX and other approved tools.
- Extract, combine and analyse data from approved sources to deliver recurring reporting and agreed ad-hoc analysis.
- Work with business owners to define and apply consistent KPIs, measures and business definitions across reporting solutions.
- Analyse trends, variances, anomalies and exceptions and translate findings into clear, meaningful business insights.
Data Quality and Governance
- Profile, validate and reconcile source data, transformed datasets and reporting outputs to support accurate and consistent reporting.
- Investigate data discrepancies and quality issues, identify contributing factors and work with relevant stakeholders to resolve or escalate them.
- Maintain appropriate reporting documentation, including data definitions, transformation logic, assumptions and user guidance.
- Apply SCC requirements for security, privacy, access and appropriate use of organisational data.
Business Requirements and Stakeholder Partnership
- Partner with stakeholders to understand business questions and translate reporting needs into practical business intelligence solutions.
- Define requirements including intended users, KPIs, data sources, reporting logic, priorities and acceptance criteria.
- Coordinate and support testing of new and changed reports and dashboards before implementation.
- Explain reports, dashboards, measures and data limitations in plain language and support stakeholders to use reporting effectively.
Data Solutions and Continuous Improvement
- Develop reusable datasets, queries and semantic models that improve the consistency, efficiency and maintainability of enterprise reporting.
- Collaborate with the Data Engineer, other analysts and relevant technology teams on data integration, Microsoft Fabric, warehouse and reporting dependencies.
- Troubleshoot reporting and data issues and optimise queries, models and dashboards where required.
- Identify opportunities to automate and standardise reporting, reduce duplication and progressively modernise legacy reporting solutions.
- To interpret information and use approved self-service reporting.
What You'll Bring
Education and Experience
- Relevant tertiary qualification in data analytics, information technology, computer science, mathematics, business, or a related discipline.
- At least 3-5 years’ experience in a business intelligence analyst, reporting analyst, data analyst or similar role, with a focus on enterprise reporting and dashboard development.
- Experience designing, developing and maintaining enterprise reports, Power BI dashboards and semantic models, including data preparation, KPI measures, testing and deployment.
- Experience using SQL to extract, transform, analyse and validate data from multiple sources.
- Experience gathering and documenting enterprise reporting and dashboard requirements and translating them into business intelligence solutions.
- Experience working with Microsoft Fabric, data warehouses, data integration or ETL/ELT processes (Desirable).
- Experience within aged care, health, community services or another regulated service environment (Desirable).
What’s in it for you?
- Salary Packaging ($15,900), plus meal and entertainment benefit package to the value of $2,650
- Heart HQ - our Southern Cross Care (NSW & ACT) People Platform, packed with exclusive retail discounts, and features designed to help you celebrate, connect and succeed
- Fitness Passport - Discounted workplace health and fitness program available to you and your family. Gain full access to nominated gyms, pools, health and leisure centres across NSW & ACT
- Discounted private health insurance
- Wellbeing initiatives such as Reward and Recognition Program, Employee Assistance Program
- Ongoing Training and Development
- Linkedin Training - SCC's Senior Leaders and Support Office teams can access a digital library of over 6000 courses
- Genuine Career Progression Pathways – Buddy Program, New Grad Elevate Program, Study Support
We vet all employer accounts and do our best to keep job ads safe, but scams can still occur. Be cautious when sharing personal information — never provide financial details or make payments during the application process. For extra security, use the Apply button on our site when proceeding.
Skills
0 of 20 matchedLicenses & certifications
0 of 1 matchedSouthern Cross Care NSW & ACT