Azure Data Engineer: Master ETL with ADF & SQL

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

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.