Business Intelligence Analyst

Full Time, Max Term contract to 31/08/2027

Location: Sydney, NSW with Work from Home Options!

Salary $126,000 + Super + NFP Salary Packaging Benefits

Make a meaningful difference to the lives of Australians in need

Life at Mission Australia

When you join the team at Mission Australia, you become part of a community who are determined to end homelessness and ensure people in need can thrive. United by our Christian purpose and values, we advocate for a fairer Australia, to meet the growing needs of people across the country. Together we’re building hope and possibility for all.

Your opportunity

Behind every meaningful service outcome is reliable data that helps people make better decisions. As a Business Intelligence Analyst, you will play a critical role in transforming complex information into actionable insights that improve service delivery, strengthen organisational performance, and help Mission Australia meet its commitments to the people and communities we support.

Working as part of a collaborative Business Intelligence team, you will develop sophisticated reporting solutions, analyse data from multiple sources, and contribute to the ongoing evolution of our Azure and Microsoft Fabric data environment.

This is an opportunity to combine technical expertise with purpose, helping ensure data-driven decisions contribute to building stronger communities and creating pathways to a better future for Australians.

Your key responsibilities will be to:

Develop and enhance business intelligence reporting to measure KPIs, business performance and client outcomes.

Design and build reporting data structures using SQL and appropriate analytics methodologies.

Analyse data from multiple platforms and source systems to provide meaningful business insights.

Deliver contractual and performance reporting that meets funder requirements.

Produce validation and quality assurance reports to support accurate data collection and reporting.

Establish and maintain reporting definitions, data standards and business rules.

Translate business needs into technical specifications and reporting solutions.

Conduct data validation and participate in user acceptance testing to ensure reporting accuracy.

Build strong relationships with stakeholders and communicate insights to both technical and non-technical audiences.

Contribute to cross-functional projects, continuous improvement initiatives and the ongoing development of Mission Australia's data platforms.

Requirements for success

Looking for someone with 3 to 5 years years’ experience, ideally with a mixed skill set of Data Engineer/BI Developer/Analyst, with experience of ETL/ELT environment.

Proficiency in writing complex, accurate SQL queries to develop reporting data structures for Power BI (CTE, dynamic PIVOT, FETCH, INDEX, DEX).

Experience in Azure Data Lake and MS Fabric desirable

Deployment experience via DevOps

Experience of working on Azure Analytics, Python script under MS Fabric, desirable.

Demonstrated ability to manage quality of data from multiple sources by tracing from reports to source system. (Data QA / UAT)

Knowledge of the report development lifecycle and drafting business requirements for end users.

Experience in using data and analytics capability to help inform decision making and deliver project outcomes.

Before starting work with us, you will need to undertake a national police history check, qualifications, and referee checks, and have a clearance to work with children/vulnerable people.

Your benefits

To ensure our employees feel valued, empowered, and celebrated, we provide a range of employee benefits including:

Rewarding work – every day you know you’re making a real difference

Not-for-profit salary packaging, reducing your tax

Free external, confidential counselling

Volunteering opportunities

Opportunity to purchase additional annual leave

Extra leave including: Mission Australia Thank You Day & Work Anniversary Day off

Our culture

Our innovative and inclusive culture will ensure you feel valued at Mission Australia as you help Australians in need and develop in your career.

We prioritise the safety and wellbeing of everyone, both within our team and the individuals we serve.

We are committed to creating a diverse and inclusive working environment. We actively support and encourage people of all backgrounds; gender, age, ethnicity, race, cultural background, disability, religion, and sexual orientation to submit an application and aim to ensure that the recruitment and employee experience is as accessible and inclusive as possible. So, whoever you are, if you’re skilled and actively support our purpose and values, you would be welcome at Mission Australia.

If you live with disability and require support to submit your application, please email talentattraction@missionaustralia.com.au

We strongly encourage applications from people who identify as Aboriginal or Torres Strait Islander. For culturally safe support or assistance with your application, please contact us at Deadlycareers@missionaustralia.com.au