Lead Data Analyst - SQL, SAS Viya - Federal Govt!

Hitech Asia Pacific; Northern Territory; Hybrid; AUD 90,000 - 120,000; Full time

Job summary

Hitech Asia Pacific is seeking an experienced Data Analyst to lead discovery, analysis and delivery across complex ICT programs. The role offers hybrid working arrangements across QLD, ACT, VIC, NSW, NT, SA and TAS, with an initial 12-month contract and extension option.

You will translate business needs into data requirements, source-to-target mappings and transformation rules, using SQL and analytics tools to cleanse, standardise and integrate data across cloud and on-premises environments.

Qualifications

• Extensive discovery, profiling and analysis of complex datasets in ICT, digital transformation or data delivery.
• Strong SQL and analytics skills, including coding, scripting, data quality analysis and technical investigation.
• Experience producing implementation-ready mappings, data contracts, definitions, transformation and business rules, join and matching logic, and exception handling specifications.
• End-to-end data lifecycle experience: discovery, lineage, ingestion, integration, migration, initial and incremental loads, validation, reconciliation, defect investigation and implementation support.
• Desirable: SAS Viya/Studio, Snowflake, Python, Power BI, Talend, Azure or comparable tools; large-scale migration, ingestion, cloud or integration projects; data modelling, entity relationships, reference data, matching and lineage; and Australian Government data governance and information management knowledge.

Responsibilities

• Leading internal and external data discovery and profiling to assess structure, quality, lineage, relationships, sensitivity and suitability.
• Translating business needs into data requirements, source-to-target mappings, dictionaries, contracts, transformation rules, and join and matching logic.
• Using SQL and analytics tools to investigate data quality and develop reusable queries, scripts, notebooks and datasets for cleansing, standardisation, transformation, de-duplication and reconciliation.
• Partnering with business and technical teams on pipelines, ingestion, integration, migration, and initial and incremental refreshes across cloud and on-premises environments.
• Validating source and target data, reconciling counts and measures, investigating load failures and defects, and defining test scenarios, expected results and traceability with testers.

Skills

Data analysis

SQL

Data profiling

Data governance

Tools

SAS Viya/Studio

Snowflake

Python

Power BI

Talend

Azure

Job description

• Lead complex data discovery, analysis and delivery across major ICT and digital programs!
• Hybrid work arrangements available across QLD, ACT, VIC, NSW, NT, SA & TAS!
• Initial 12-month contract + 1 x 12-month extension option!

An exciting opportunity is available for an experienced Data Analyst to provide specialist data analysis, discovery and delivery support across complex ICT programs, projects and digital services. Working within multidisciplinary delivery teams, you will translate business needs into clear data requirements, mappings, rules and analytical outputs across the end-to-end data lifecycle. The position offers hybrid working arrangements across QLD, ACT, VIC, NSW, NT, SA and TAS, with an initial 12-month contract and one 12-month extension option.

The successful Data Analyst will be responsible for, but not limited to:

• Leading internal and external data discovery and profiling to assess structure, quality, lineage, relationships, sensitivity and suitability.
• Translating business needs into data requirements, source-to-target mappings, dictionaries, contracts, transformation rules, and join and matching logic.
• Using SQL and analytics tools to investigate data quality and develop reusable queries, scripts, notebooks and datasets for cleansing, standardisation, transformation, de-duplication and reconciliation.
• Partnering with business and technical teams on pipelines, ingestion, integration, migration, and initial and incremental refreshes across cloud and on-premises environments.
• Validating source and target data, reconciling counts and measures, investigating load failures and defects, and defining test scenarios, expected results and traceability with testers.

The successful Data Analyst will bring:

• Extensive discovery, profiling and analysis of complex datasets in ICT, digital transformation or data delivery.
• Strong SQL and analytics skills, including coding, scripting, data quality analysis and technical investigation.
• Experience producing implementation-ready mappings, data contracts, definitions, transformation and business rules, join and matching logic, and exception handling specifications.
• End-to-end data lifecycle experience: discovery, lineage, ingestion, integration, migration, initial and incremental loads, validation, reconciliation, defect investigation and implementation support.
• Desirable: SAS Viya/Studio, Snowflake, Python, Power BI, Talend, Azure or comparable tools; large-scale migration, ingestion, cloud or integration projects; data modelling, entity relationships, reference data, matching and lineage; and Australian Government data governance and information management knowledge.

This is an excellent opportunity to join a multidisciplinary team delivering complex data and digital outcomes. Successful candidates will be offered an initial 12-month contract with one 12-month extension option. Applicants must be Australian citizens and be able to obtain Negative Vetting Level 1 security clearance.