Data Engineer: Azure SQL & ADF Migration Expert

Tallentire O'Flynn Movsowitz; Sydney; On-site; AUD 150,000 - 210,000; Full time

Job summary

Tallentire O'Flynn Movsowitz is seeking a Data Engineer to help modernise an enterprise data platform for a financial services client in Sydney. You will migrate a legacy SQL Server data warehouse to Azure SQL Managed Instance, building secure, tested data solutions with robust monitoring and governance.

You will design, build and support ETL/ELT pipelines, implement DataOps practices, and deliver end-to-end migration work with strong collaboration across technical and risk stakeholders.

Qualifications

• 5+ years in data engineering, BI, data warehousing or analytics delivery.
• Advanced SQL Server skills including stored procedures and data modelling.
• Experience migrating to Azure SQL Managed Instance and using ADF/SSIS.
• Proven ability to design, build, test and support ETL/ELT pipelines.

Responsibilities

• Design, build, test and support SQL, ETL/ELT and orchestration pipelines.
• Deliver migration work end to end: source-to-target mapping, scripting, reconciliation, cutover and handover to support.
• Build relational and dimensional models and curated datasets for regulatory, management and analytical reporting.
• Create reusable patterns for ingestion, validation, logging, alerting and reconciliation.
• Embed data quality, lineage and control evidence into delivery, with clear runbooks and documentation.

Skills

Advanced SQL Server skills

ETL/ELT pipelines

Data modeling (dimensional)

Strong stakeholder communication

5+ years data engineering/BI/analytics

Tools

Azure Data Factory

SSIS Integration Runtime

Azure SQL Managed Instance

CI/CD

Python

PySpark

Power BI

Job description

Tallentire O'Flynn Movsowitz is seeking a Data Engineer to help modernise an enterprise data platform for a financial services client in Sydney. You will migrate a legacy SQL Server data warehouse to Azure SQL Managed Instance, building secure, tested data solutions with robust monitoring and governance.

You will design, build and support ETL/ELT pipelines, implement DataOps practices, and deliver end-to-end migration work with strong collaboration across technical and risk stakeholders.