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. Find out more about us and our purpose . 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 (details via AccessPay ) Free external, confidential counselling and access to chaplaincy support 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 [email protected] or visit our Careers page for additional contact details. 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 [email protected] Find out more about a career with Mission Australia . How to apply Click ‘Apply’ and send your application today! As a committed Circle Back Initiative employer, we will respond to your application. Applications are shortlisted as they are received. Please apply as soon as possible to be considered. Thank you