Azure Data Enginer - ADF / SQL / ETL

TalentReady; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

TalentReady is seeking an Azure Data Engineer in Sydney to design, build and maintain robust data pipelines and warehousing solutions. The role requires hands-on experience with ETL/ELT development, ADF, and SQL technologies, plus cloud-native and on-prem data integration expertise.

You will implement data quality controls, support migrations and collaborate with stakeholders to deliver scalable data solutions across environments.

Qualifications

• Strong hands-on experience in ETL/ELT development, including data extraction, transformation, validation and loading.

Responsibilities

• Design, develop and maintain ETL/ELT pipelines to extract, transform, validate and load data from multiple sources.
• Build, manage and optimise data integration pipelines using Azure Data Factory (ADF).
• Develop and maintain data solutions using Azure SQL, SQL Server and T-SQL.
• Work with Azure Data Lake Gen2 and Azure Blob Storage to support cloud-based data ingestion and storage.
• Design and implement data warehousing solutions, including staging layers, data marts and dimensional models.
• Support data migration and integration initiatives across cloud and on-premises environments.
• Develop, maintain and troubleshoot SSIS packages where required.
• Implement data quality checks, validation processes and reconciliation procedures to ensure data accuracy and integrity.
• Investigate and resolve pipeline failures, data inconsistencies and performance issues.
• Collaborate with data engineers, analysts and business stakeholders to deliver reliable data solutions.

Skills

ETL/ELT development

ADF

Azure SQL

SQL Server

T-SQL

Azure Data Lake Gen2

Azure Blob Storage

Data warehousing

SSIS

Troubleshooting

Data quality

Data integration

Agile

Tools

Azure Data Factory (ADF)

SSIS

Azure Data Lake Gen2

Azure Blob Storage

SQL Server

Job description

Contract Engagement - with Extensions
Location - Sydney

We are seeking an experienced Azure Data Engineer with strong expertise in ETL/ELT development, Azure Data Factory (ADF), SQL and data warehousing.

You will be responsible for designing, developing and maintaining robust data pipelines, integrating data from multiple sources and ensuring data quality across cloud and on-premises environments.

This is a hands‑on technical role suited to someone who enjoys solving complex data challenges, improving data integration processes and delivering reliable, scalable data solutions.

Key Responsibilities

• Design, develop and maintain ETL/ELT pipelines to extract, transform, validate and load data from multiple sources.
• Build, manage and optimise data integration pipelines using Azure Data Factory (ADF).
• Develop and maintain data solutions using Azure SQL, SQL Server and T-SQL.
• Work with Azure Data Lake Gen2 and Azure Blob Storage to support cloud-based data ingestion and storage.
• Design and implement data warehousing solutions, including staging layers, data marts and dimensional models.
• Support data migration and integration initiatives across cloud and on-premises environments.
• Develop, maintain and troubleshoot SSIS packages where required.
• Implement data quality checks, validation processes and reconciliation procedures to ensure data accuracy and integrity.
• Investigate and resolve pipeline failures, data inconsistencies and performance issues.
• Collaborate with data engineers, analysts and business stakeholders to deliver reliable data solutions.

Skills & Experience

Essential:

• Strong hands‑on experience in ETL/ELT development, including data extraction, transformation, validation and loading.
• Proven experience building and managing data pipelines using Azure Data Factory (ADF).
• Strong technical expertise in Azure SQL, SQL Server and T-SQL, including complex queries, stored procedures and performance optimisation.
• Experience working with Azure Data Lake Gen2 and Azure Blob Storage.
• Solid understanding of data warehousing concepts, including staging, data marts and dimensional modelling.
• Experience integrating and migrating data between cloud and on-premises systems.
• Strong data quality, validation, reconciliation and troubleshooting capabilities.
• Ability to investigate technical issues and deliver practical, scalable solutions.

Highly Desirable:

• Experience developing and maintaining SQL Server Integration Services (SSIS) packages.
• Experience modernising legacy ETL processes and migrating workloads to Azure.
• Exposure to enterprise data integration and cloud migration projects.
• Experience working in Agile delivery environments.

Additional information

• ETL/ELT development, Azure Data Factory (ADF) and SQL
• Long Term Contract
• Sydney