12 Month Fixed-Term Opportunity

Centacare is an agency of the Catholic Archdiocese of Brisbane that provides community services and support to individuals, families, and communities across Queensland. Through a wide range of programs including childcare, aged care, disability support, family and relationship services, counselling, and youth support, Centacare is committed to enhancing wellbeing, promoting dignity, and supporting vulnerable members of the community. Guided by Catholic values, Centacare works to build stronger, more connected, and inclusive communities through compassionate and professional service delivery.

Centacare is seeking an experienced Subject Matter Expert (SME) - Power BI & SQL to lead the design, development and optimisation of our business intelligence and reporting solutions. This is an exciting opportunity for a senior BI skilled who enjoys solving complex data challenges, partnering with stakeholders, and delivering high-quality reporting that supports strategic and operational decision-making.

About the Role

As our Power BI & SQL Subject Matter Expert, you'll be the technical lead for business intelligence across the organisation. You'll design and build scalable Power BI solutions, develop and optimise SQL queries and data models, and champion best practice in reporting, governance and analytics. Working closely with business leaders and technical teams, you'll translate business requirements into insightful dashboards and reporting solutions that enable informed, data-driven decisions.

Key Responsibilities

- Design, develop and maintain engaging Power BI dashboards, reports and executive scorecards.
- Build reusable datasets, semantic models and interactive visualisations.
- Develop, optimise and maintain complex SQL queries, stored procedures and database views.
- Design logical and physical data models, including star and snowflake schemas.
- Perform data extraction, transformation and validation to ensure data accuracy and integrity.




- Collaborate with stakeholders to understand reporting requirements and deliver fit-for-purpose solutions.
- Lead workshops and present analytical insights to business leaders.
- Establish and promote Power BI development standards, governance and reporting best practices.
- Provide Level 2/3 support for BI solutions and identify opportunities to improve automation and reporting efficiency.
- Maintain technical documentation, reporting standards and user procedures.
- Keep abreast of emerging Microsoft technologies and industry best practice.

About You

You are a collaborative and technically capable Business Intelligence professional who enjoys working with stakeholders to solve business problems through data.

- Expertise in enterprise Power BI reporting, dashboard development, data modelling, and ETL using Power Query (M).
- Advanced SQL development and database management across SQL Server, Azure SQL, and HCM/Payroll reporting solutions.
- Strong analytical, stakeholder engagement, and business partnering skills, delivering executive reporting and data-driven insights.
- Proficiency in Microsoft Fabric, SSIS/SSRS, Agile delivery, and continuous improvement across enterprise BI environments.

Why Join Centacare?

At Centacare, our people use their skills to make a positive impact in the community every day. In this role, your expertise will directly support better decision-making, improved services and meaningful outcomes for the people and communities we serve.

If you're an experienced Business Intelligence professional looking for an opportunity where your technical expertise and leadership can make a real difference, we'd love to hear from you.

The Archdiocese of Brisbane has standards of conduct for workers to maintain a safe and healthy environment for children. Our commitment to these standards requires that we conduct working with children checks and background referencing for all persons who will engage in direct and regular involvement with children and young people (0 - 18 years) and/or vulnerable adults. The organisation is fully committed to child safety and has a 0 tolerance to abuse of children or vulnerable adults.

#J-18808-Ljbffr

📌 Subject Matter Expert - Power BI & SQL (Brisbane)
🏢 Centacare
📍 Brisbane