El1 Lead Data Analyst

Softtest Pays Pty Ltd; Adelaide; On-site; AUD 90,000 - 120,000; Full time

Job summary

Softtest Pays Pty Ltd in Adelaide seeks an EL1 Data Analyst (Labour Hire) to lead data discovery, profiling and translation of business needs into data requirements across complex ICT programs. You will work with business owners, data engineers and developers to define data contracts and ensure data quality end-to-end.

The role involves developing mappings, data dictionaries, dashboards and analytical outputs, collaborating across teams, and delivering reliable data solutions for production

Qualifications

• Lead data discovery and profiling across complex data sets to understand structure, quality, lineage, relationships, and fitness for purpose.
• Identify required data, clarify its business meaning, define intended use and translate into detailed data requirements and data contracts.
• Develop and maintain source-to-target mappings, data dictionaries, field definitions, data contracts, transformation rules, join logic, filtering rules, matching logic.
• Analyse data using SQL and relevant analytics tools to identify duplicates, outliers, nulls, invalid values, inconsistent formats, referential issues and data quality concerns.
• Define practical options for cleansing, standardising, transforming, matching, de-duplicating and reconciling data, including exception handling and loads.
• Collaborate with data engineers and developers to translate approved mappings, data contracts and business rules into implementable ingestion and transformation logic.
• Support the design and delivery of data pipelines, bulk ingestion processes, system integrations, migrations and data refreshes across cloud and on-premises environments.
• Develop or prepare reusable datasets, SQL queries, analytical code, scripts, notebooks and supporting artefacts for profiling, transformation, reconciliation, testing and controlled implementation.
• Validate source and target data against mappings and contracts, reconcile counts, investigate failed loads and support defect resolution.
• Work with testers and business representatives to develop test scenarios and traceability from approved data requirements and mapping rules.
• Produce clear analysis, dashboards, reports, visualisations and written advice for both technical and non-technical audiences.
• Identify and communicate data risks, assumptions, dependencies, limitations and gaps early, and provide evidence-based options and recommendations.
• Apply relevant data governance, privacy, security, records management and information handling requirements throughout analytical activities.
• Contribute to continuous improvement of data standards, documentation and quality controls across delivery teams.

Responsibilities

• 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.
• Work with business and technical stakeholders to identify required data, clarify its business meaning, define the intended use and translate business outcomes into detailed data requirements and agreed data contracts.
• 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.
• Collaborate with data engineers and developers to translate approved mappings, data contracts and business rules into implementable ingestion, integration, migration and transformation logic, while maintaining clear end-to-end traceability.
• 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 that enable profiling, transformation, reconciliation, testing and controlled implementation.
• 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.
• Work with testers and business representatives to develop test scenarios, expected results and traceability from approved data requirements and mapping rules.
• Produce clear analysis, dashboards, reports, visualisations and written advice for both technical and non-technical audiences where required by the program or project.
• Identify and communicate data risks, assumptions, dependencies, limitations and gaps early, and provide evidence-based options and recommendations to delivery teams and senior stakeholders.
• Apply relevant data governance, privacy, security, records management and information handling requirements throughout analytical and delivery activities.
• Contribute to continuous improvement of data standards, documentation, reusable methods, quality controls and ways of working across data and digital delivery teams.

Skills

Data analysis

SQL

Data profiling

Data governance

Stakeholder collaboration

Job description

Australian Citizens residing in Australia only respond.

Job details

Role/s: 1 x EL1 Data Analyst

The EL1 Data Analyst (Labour Hire) provides specialist data analysis, data discovery and data delivery support for complex ICT programs, projects and digital services.

Working in multidisciplinary delivery teams, the role examines complex data from internal and external sources, defines how data should be interpreted and used, and translates business needs into clear data requirements, mappings, rules and analytical outputs.

The role works closely with business owners, data engineers, business analysts, architects, developers, testers and technical specialists across the end-to-end data lifecycle, from source discovery and profiling through to ingestion, validation, reconciliation, reporting and production support.

Key duties and responsibilities

• 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.
• Work with business and technical stakeholders to identify required data, clarify its business meaning, define the intended use and translate business outcomes into detailed data requirements and agreed data contracts.
• 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.
• Collaborate with data engineers and developers to translate approved mappings, data contracts and business rules into implementable ingestion, integration, migration and transformation logic, while maintaining clear end-to-end traceability.
• 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 that enable profiling, transformation, reconciliation, testing and controlled implementation.
• 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.
• Work with testers and business representatives to develop test scenarios, expected results and traceability from approved data requirements and mapping rules.
• Produce clear analysis, dashboards, reports, visualisations and written advice for both technical and non-technical audiences where required by the program or project.
• Identify and communicate data risks, assumptions, dependencies, limitations and gaps early, and provide evidence-based options and recommendations to delivery teams and senior stakeholders.
• Apply relevant data governance, privacy, security, records management and information handling requirements throughout analytical and delivery activities.
• Contribute to continuous improvement of data standards, documentation, reusable methods, quality controls and ways of working across data and digital delivery teams.

(NOTE: the key responsibilities of the role are based on current priorities and may change over time)