Data Analyst

teamchildfund; Sydney; On-site; AUD 90,000 - 130,000; Full time

Job summary

ChildFund Australia is seeking a data insights professional to turn supporter and program data into trusted information for fundraising and performance analysis. You will build and maintain Power BI reports, validate outputs, and partner with teams to drive informed decisions.

The role focuses on data quality, reconciliation, and producing recurring reporting while documenting data products and governance. Strong SQL, Power BI, and stakeholder communication are essential.

Qualifications

• Strong SQL skills with multi-step transformations.
• Experience building Power BI reports with data modelling (DAX).
• Demonstrated accuracy: reconciling figures and tracing discrepancies.
• Experience gathering requirements from non-technical stakeholders and delivering results.
• Tertiary qualification in a relevant discipline or equivalent practical experience.

Responsibilities

• Deliver, validate and monitor recurring reporting and campaigns data.
• Own data quality rules and reconciliation processes; investigate exceptions.
• Gather stakeholder requirements and translate into well-scoped data products; document usage.
• Keep code and report logic in source control; ensure secure handling of data.

Skills

SQL queries

Power BI reports

Data reconciliation

Requirements gathering

Data analysis

Education

Bachelor's degree or equivalent

Tools

Microsoft Fabric

Databricks

Spark

Git

Job description

PURPOSE OF THE POSITION

You will turn ChildFund Australia’s supporter and program data into trusted information that teams rely on to raise funds, understand performance and make informed decisions. Working in the Data Insights team, you will also deliver recurring reporting and campaign data, while owning key data quality, validation and reconciliation processes.

KEY DUTIES

Reporting and campaign data

• Delivery, validation and monitoring of recurring reporting
• Prepare campaign data selections and produce forecasts to support next-year planning
• Build, maintain and improve Power BI reports and dashboards and action change requests from teams
• Validate reporting outputs and investigate discrepancies before information is distributed to stakeholders.

Data quality and reconciliation

• Own repeatable data quality rules and reconciliation processes
• Investigate exceptions and work with data owners to resolve them
• Match and reconcile supporter records across systems and support data cleanup
• Identify data anomalies such as invalid or automated sign-ups

Working with teams

• Gather requirements directly with stakeholders and turn them into clear, well-scoped data products
• Explain data, trends and limitations in plain language so teams can make informed decisions
• Write user guides and technical documentation so what you build can be used, supported and handed over

Ways of working

• Keep all code, report logic and definitions in source control and documented, so no data product depends on one person's knowledge
• Handle supporter and personal information securely and in line with ChildFund's privacy obligations
• Manage your work with the team, raising risks and blockers early

QUALIFICATIONS & EXPERIENCE

• Strong SQL skills, including writing and debugging multi-step transformation queries
  
• Experience building Power BI reports, including data modelling and DAX
• Demonstrated accuracy: reconciling figures, validating outputs and tracing discrepancies back to source
• Experience gathering requirements from non-technical stakeholders and delivering against them
• Tertiary qualification in a relevant discipline or equivalent practical experience

DESIRABLE

• Experience with Microsoft Fabric, Databricks, Spark or another lakehouse platform
• Experience working with Salesforce data (objects, relationships, reporting)
• Experience using Git or another version control system
• Experience with not-for-profit fundraising data
• Experience with international development program or MEL data

ChildFund Australia believes in a global community where children are safe and can reach their full potential. We take extensive steps to safeguard children in any work done by our people, i.e., our staff, volunteers and interns, supporters, partners, board members, ambassadors and suppliers. We strive to keep children safe through child safe practices, and rigorously ensure we prevent, oppose, and combat all exploitation and abuse of children and vulnerable people.

As part of this commitment, all people working with us will undergo relevant background checks before joining ChildFund Australia. Staff will acquire the knowledge and skills needed to understand our Child Safeguarding and PSEAH policies & procedures, promote strong safeguarding practices, and conduct themselves consistent with these policies