Road Safety Data Analyst: Insights That Drive Safety

Transport for NSW; Sydney; On-site; AUD 110,000 - 140,000; Full time

Job summary

ChildFund Australia is seeking a Data Analyst to transform supporter and program data into trusted information for teams to raise funds, assess performance and support decision making. You will join the Data Insights team, delivering recurring reporting while owning data quality, validation and reconciliation processes.

The role focuses on delivering robust data products, working with stakeholders, and writing user guides to ensure sustainability and handover of solutions across teams.

Qualifications

• Strong SQL skills incl. writing & debugging multi-step queries.
• Experience building Power BI reports, data modelling and DAX.
• Demonstrated accuracy: reconciling figures, validating outputs, tracing discrepancies to source.
• Experience gathering requirements from non-technical stakeholders and delivering against them.

Responsibilities

• Delivery, validation and monitoring of recurring reporting.
• Prepare campaign data selections and forecasts for next-year planning.
• Build, maintain and improve Power BI reports and dashboards; action change requests.

Skills

PL-SQL

Teradata

Power BI

Stakeholder management

Communication

Adobe Analytics

Education

Tertiary qualification in a relevant discipline

Tools

PL/SQL

Teradata

Power BI

Azure

Job description

We are looking for Immediate open position for Data Analyst with below mentioned skillset:

Extensively worked in PL-SQL ( 3+ yrs)

6+ years Overall IT experience

Good working knowledge in Teradata

Good stakeholder management and communication skills.

Good to have Digital Analytics knowledge ( Adobe/Google)

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

• 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

Australian Citizens residing in Australia with Baseline Clearance only respond.

1. Experience designing ETL/ELT processes for data movement and transformation.25%

2. Experience exploring and analysing structured and non-structured data for ingestion into data transformation processes25%

3. Azure Cloud technology experience working with Engineering, Storage and Analytics services.25%

4. Working with multi-disciplinary teams using an Agile methodology25%

1. Experience working with Infrastructure as Code delivery (Terraform)50%

2. Experience working with Data Lakes50%

Job Description:

Australian Citizens residing in Australia with Baseline Clearance only respond.

Essential criteria Weighting

1. Experience designing ETL/ELT processes for data movement and transformation.25%

2. Experience exploring and analysing structured and non-structured data for ingestion into data transformation processes25%

3. Azure Cloud technology experience working with Engineering, Storage and Analytics services.25%

4. Working with multi-disciplinary teams using an Agile methodology25%

Desirable criteria Weighting

1. Experience working with Infrastructure as Code delivery (Terraform)50%

2. Experience working with Data Lakes50%

Required Skills:

Storage Analytics Infrastructure Engineering

• Strong experience with SQL/Oracle SQL, data analytics, coding;
• Strong knowledge and experience on data models, schemas and data lineage
• Experience working with enterprise reporting platforms, delivering reporting related projects
• Ability to collect business reporting requirements,
• Ability to read the data codes, understand complex logic in the rules and translate them into business language and assess if there is the underlying weakness in the logic. (core skill)
• Strong data quality, control and exception handling mindset
• Domain knowledge
• Banking sectors
• Payments knowledge
• Regulatory knowledge relating to banking operations incl. Privacy Act, AML Act, Spam Act.
• Business Analysis Skills
• Strong experience producing: Functional & technical requirement documents, Reporting specifications, and Data dictionaries and metric definitions
• Ability to challenge assumptions and identify downstream impacts early
• Can do attitude, growth mindset and willing to go above and beyond;
• Comfortable operating independently in ambiguous, fast-moving environments
• Strong ownership mindset with a bias toward delivery

Built isn’t waiting for the future. We’re building it.

Join a team that is transforming how data drives decision-making across the business. This is an opportunity to work with modern analytics technologies, including Microsoft Fabric and Power BI, while helping shape trusted data products, performance insights and reporting that influence real business outcomes.