Transformation Data Analyst: Initiatives & Data Quality

Davidson; Geelong; Hybrid; AUD 120,000 - 203,000; Full time

Benefits offered by this job

Competitive day rates

Contract till end of December 2026

Hybrid work

Job summary

Davidson is seeking an experienced Business Analyst / Data Analyst to support a government transformation portfolio in Geelong. You will consolidate multiple source registers into a single validated dataset and create a consistent view of active initiatives.

The role involves working with complex Excel-based registers, identifying discrepancies, and documenting remediation steps for management validation. A strong analytical mindset is essential.

Qualifications

• Experience integrating and reconciling data from multiple inconsistent source systems.
• Strong Excel skills: formulas, pivot tables and data validation.
• Experience using Power Query or equivalent to merge/manage large datasets.
• Knowledge of project and portfolio management artefacts: schedules, RAID logs, baselines.

Responsibilities

• Develop a master initiative crosswalk across multiple source registers.
• Consolidate schedule, risk, issue, benefits, status and forecast data under common identifiers.
• Reconcile initiative population against inclusion rules and document exceptions.
• Populate baseline templates for all active initiatives with dates, dependencies, resources, and key info.
• Validate and releink schedule dependencies (predecessors/successors).
• Review risk/issue registers with ownership, dates and status.
• Assess risk/issue data against the organisation's framework and RAID conventions.
• Reconcile financial reporting bases and document the basis for each figure.
• Review health indicators to reflect delivery performance.
• Log data conflicts between sources for management review.
• Maintain a data quality tracker with fields, sources, issues, remediation.

Skills

Excel

Power Query

Data reconciliation

Attention to detail

Tools

Power Query

Job description

Davidson is seeking an experienced Business Analyst / Data Analyst to support a government transformation portfolio in Geelong. You will consolidate multiple source registers into a single validated dataset and create a consistent view of active initiatives.

The role involves working with complex Excel-based registers, identifying discrepancies, and documenting remediation steps for management validation. A strong analytical mindset is essential.