Lead Data Analyst

The Recruitment Hive Pty Ltd; Canberra; Hybrid; AUD 110,000 - 150,000; Full time

Job summary

The Recruitment Hive Pty Ltd in Deakin, ACT, is seeking a Lead Data Analyst for a 12 + 12 month contract with flexible hybrid arrangements. The role emphasizes data discovery, profiling and governance across diverse datasets.

Responsibilities include developing mappings, data dictionaries and data pipelines, using SQL and tools such as SAS Viya/SAS Studio, Snowflake, Python and Power BI to deliver high-quality data artefacts and ensure data integrity.

Qualifications

• Extensive experience data discovery, profiling and analysis across complex ICT/digital transformation environments.
• Strong practical experience using SQL and contemporary data analysis tools.
• Experience developing source-to-target mappings, data contracts and data definitions.
• Experience across end-to-end data lifecycle.
• Ability to translate complex requirements into clear data artefacts and delivery specs.
• Experience with SAS Viya or SAS Studio, Snowflake, SQL, Python, Power BI, Talend, Azure data services.
• Experience supporting large-scale data migration, cloud data platforms, system integration or data refresh projects.
• Knowledge of data modelling, lineage, de-duplication and reconciliation.
• Knowledge of Australian Government data governance, privacy, security and information management.

Responsibilities

• Lead data discovery and profiling across datasets to assess structure, quality and lineage.
• Develop and maintain source-to-target mappings, data dictionaries and data contracts.
• Analyse data using SQL to identify duplicates, outliers and data quality issues.
• Define cleansing, transformation and matching approaches for data quality.
• Support data pipelines, integrations and data refreshes across cloud and on-premise environments.
• Prepare reusable datasets, SQL queries, scripts and notebooks.
• Validate data against mappings and contracts and investigate data issues.

Skills

Data profiling

SQL

Data lifecycle

Data artefacts

Requirements translation

Tools

SAS Viya

SAS Studio

Snowflake

Python

Power BI

Talend

Azure data services

Job description

• 12 + 12 + month contract – December start
• NV1 Security Clearance - Deakin, ACT
• Flexible hybrid arrangements

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:

• 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.
• 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.

Please note that applications close at 11am on Wednesday the 4th of Nov 2026.

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.