21 Oct
|
SKL Technology
|
Sydney
21 Oct
SKL Technology
Sydney
Location: QLD, ACT, VIC, NSW, NT, SA, TAS
12 months contract with 1 extension
Australian citizenship mandatory
Lead Data Analyst
About the Role
We are seeking an experienced Lead Data Analyst to support complex ICT programs, digital transformation initiatives and enterprise data delivery projects within a large Australian Government environment.
This is a senior, hands-on role requiring strong technical data analysis capabilities, advanced SQL skills and extensive experience in data discovery, profiling, mapping, transformation and reconciliation.
You will work closely with business stakeholders, data engineers, solution architects, developers and testers to translate complex business requirements into clear, implementation-ready data specifications.
Key Responsibilities
- Lead data discovery, profiling and analysis across complex internal and external datasets, identifying data quality issues, relationships, dependencies and constraints.
- Develop detailed source-to-target mappings, data dictionaries, data contracts, transformation rules, business rules and technical data specifications.
- Use advanced SQL and analytical tools to investigate data quality issues, including duplicates, null values, inconsistencies, outliers and referential integrity.
- Define data cleansing, standardization, matching, de-duplication and reconciliation approaches.
- Work with data engineers and developers to translate data requirements into ingestion, integration, migration and transformation processes.
- Support end-to-end data delivery, including initial and incremental loads, bulk ingestion, data migration, validation and production support.
- Develop SQL queries, analytical scripts, reusable datasets and supporting technical documentation.
- Validate source and target datasets, reconcile record counts, investigate data discrepancies and resolve defects.
- Collaborate with testers to define data validation scenarios, expected outcomes and testing requirements.
- Produce reports, dashboards,
analytical insights and recommendations for technical and business stakeholders.
- Identify data risks, dependencies and gaps, recommending practical solutions to improve data quality and delivery outcomes.
- Ensure compliance with relevant data governance, privacy, security and information management standards.
Must Have Skills
- 7+years' experience as a Senior Data Analyst, Lead Data Analyst or Technical Data Analyst within complex ICT, enterprise data or digital transformation environments.
- Advanced SQL skills, including complex queries, joins, data profiling, reconciliation and technical investigation.
- Proven experience developing source-to-target mappings, data contracts, data definitions, transformation rules, matching logic and detailed data specifications.
- Strong understanding of the end-to-end data lifecycle, including discovery, ingestion, integration, migration, validation, reconciliation and production support.
- Experience identifying and resolving data quality issues across large and complex datasets.
- Ability to translate business requirements into detailed technical data specifications for engineering and development teams.
- Robust stakeholder engagement, analytical thinking, problem-solving and documentation skills.
- Demonstrated ability to lead technical analysis independently and collaborate effectively with multidisciplinary teams.
Nice to have skills
- Experience with SAS Viya, SAS Studio, Snowflake, Python, Power BI, Talend or Azure Data Services.
- Experience supporting enterprise data migration, bulk ingestion, cloud data platforms and system integration projects.
- Knowledge of data modelling, entity relationships, reference data, matching, de-duplication and data lineage.
- Experience with ETL/ELT pipelines, data transformation and reconciliation processes.
- Previous experience delivering data solutions within Australian Government or similarly complex regulated environments.
- Understanding of Australian Government data governance, privacy, security and information management requirements.
📌 Lead Data Analyst (Sydney)
🏢 SKL Technology
📍 Sydney