Lead Data Analyst

Salary: $130 - $150 per hour (inc. super)

• 12 + 12 + month contract – December start
• NV1 Security Clearance - Deakin, ACT
• Flexible hybrid arrangements
• Analyse data using SQL/SAS - Support large-scale data migration

Our client, a Federal Government statutory authority based in Deakin, ACT, requires the services of a Lead Data Analyst for a 12 + 12 month contract.

Duties of the Lead Data Analyst:

• Lead data discovery and profiling across complex internal and external datasets to understand their structure, content, quality, lineage, relationships, constraints, sensitivity and fitness for purpose.
• Develop and maintain source-to-target mappings, data dictionaries, field definitions, data contracts, transformation rules, join logic, filtering rules, matching logic and other implementation-ready data specifications.
• Analyse data using SQL and relevant analytics tools to identify duplicates, outliers, nulls, invalid values, inconsistent formats, referential issues and other data quality concerns.
• Define practical options for cleansing, standardising, transforming, matching, de-duplicating and reconciling data, including exception handling, rejected records, historical data, initial loads, incremental loads and refresh processes.
• Support the design and delivery of data pipelines, bulk ingestion processes, system integrations, migrations and data refreshes across cloud and on-premises environments by clarifying requirements, resolving data questions and reviewing technical outcomes.
• Develop or prepare reusable datasets, SQL queries, analytical code, scripts, notebooks and supporting artefacts.
• Validate source and target data against approved mappings and data contracts, reconcile counts and key measures, investigate failed or incomplete loads, and support resolution of defects, exceptions and production data issues.

Skills and Experience - Lead Data Analyst:

Essential

• Demonstrated extensive experience undertaking data discovery, profiling and analysis across complex datasets in an ICT, digital transformation or data delivery environment.
• Strong practical experience using SQL and contemporary data analysis tools.
• Demonstrated experience developing source-to-target mappings, data contracts, data definitions, transformation and business rules, join and matching logic, exception handling and other implementation-ready data specifications.
• Demonstrated experience working across the end-to-end data lifecycle.
• Demonstrated ability to translate complex business and technical requirements into clear data artefacts and delivery specifications.

Desirable criteria

• Experience using SAS Viya or SAS Studio, Snowflake, SQL, Python, Power BI, Talend, Azure data services.
• Experience supporting large-scale data migration, bulk ingestion, cloud data platforms, system integration, data refresh or digital transformation initiatives in a complex environment.
• Experience with data modelling, entity and relationship data, reference data, de-duplication, matching, lineage or reconciliation approaches.
• Knowledge of Australian Government data governance, privacy, security and information management requirements.

How to Apply

For a copy of the full job description, including the application instructions, please get in touch with Andy at Recruitment Hive by clicking the Quick Apply button. Alternatively, you can reach Andy on (02) 6299 1006 to discuss further.

Please note that applications close at 11am on Wednesday the 4th of Nov 2026. Recruitment Hive welcome late applications to be considered for future opportunities.

We Value Diversity

The Recruitment Hive is a proud Equal Opportunity Employer. We recognise the value of diverse perspectives and experience and are committed to an inclusive workplace where everyone feels valued and respected for who they are. We encourage people with disability, indigenous, veterans and people of all backgrounds and abilities to express their interest in this role.

Job ID: AE 680300 | LH-07858