Lead Data Analyst – Discovery, Quality & Dashboards

Softtest pays pty ltd; Brisbane; On-site; AUD 90,000 - 130,000; Full time

Job summary

Softtest pays pty ltd in Brisbane is seeking an EL1 Data Analyst to provide specialist data analysis, discovery and delivery support for complex ICT programs. You will examine data from multiple sources, define interpretation rules and translate business needs into data requirements, mappings and outputs.

You will work with data engineers, analysts, architects and developers across the data lifecycle, from source discovery to ingestion, validation and production support.

Qualifications

• Experience with data discovery, profiling and data requirements gathering.
• Ability to translate business needs into data contracts and mappings.
• Strong SQL and data analytics skills with experience in data governance.

Responsibilities

• Lead data discovery and profiling across complex internal and external datasets to understand structure, quality, lineage and fitness for purpose.
• Identify required data, clarify business meaning, define data requirements and data contracts.
• Develop and maintain mappings, data dictionaries, field definitions and transformation rules.
• Analyse data using SQL and analytics tools to identify data quality issues and anomalies.
• Define options for cleansing, standardising and reconciling data including load processes.
• Collaborate with data engineers to implement ingestion, integration and transformation logic with end-to-end traceability.
• Support data pipelines design, bulk ingestion, migrations and data refreshes across cloud and on-prem environments.
• Create reusable datasets, SQL queries, scripts and notebooks for profiling, reconciliation and testing.
• Validate data against mappings and contracts, investigate failed loads and production data issues.
• Work with testers to develop test scenarios and traceability from requirements and mappings.
• Produce dashboards, reports and visualisations for technical and non-technical audiences.
• Communicate data risks and recommendations to delivery teams and stakeholders.
• Apply data governance, privacy, security and records management requirements.

Skills

SQL

Data Analysis

Data Profiling

Data Governance

Data Contracts

ETL

Data Pipelines

Cloud

On-Premises

Education

Bachelor’s degree in IT/Data Science

Tools

SQL

Python

Power BI

Azure Data Factory

Job description

Softtest pays pty ltd in Brisbane is seeking an EL1 Data Analyst to provide specialist data analysis, discovery and delivery support for complex ICT programs. You will examine data from multiple sources, define interpretation rules and translate business needs into data requirements, mappings and outputs.

You will work with data engineers, analysts, architects and developers across the data lifecycle, from source discovery to ingestion, validation and production support.