Azure Data Engineer: MSBI to ADF Migration & DataOps

T+O+M Executive; Sydney; On-site; AUD 140,000 - 200,000; Full time

Job summary

T+O+M Executive is seeking a Data Engineer to help modernise a financial services data platform in Sydney. You will migrate a legacy SQL Server data warehouse to Azure SQL Managed Instance and build secure, tested data solutions for governance and analytics.

You will design and implement ETL/ELT pipelines, models and datasets for regulatory and management reporting, with a focus on DataOps, runbooks and strong validation. Collaboration with risk and business stakeholders is essential.

Qualifications

• 5+ years in data engineering, BI, data warehousing or analytics delivery.
• Advanced SQL Server skills: stored procedures, performance tuning and data modelling.
• Experience with Azure SQL Managed Instance, Azure Data Factory or SSIS Integration Runtime.
• Proven ETL/ELT pipelines for material data flows and data quality controls.
• Strong grounding in dimensional modelling, data quality controls and reconciliation.
• Clear communicator across technical, business and risk stakeholders.

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
• Apply DataOps discipline: source control, peer review, testing, deployment controls and rollback planning
• Embed data quality, lineage and control evidence into delivery, with clear runbooks and documentation

Skills

Data engineering

SQL Server

Dimensional modeling

Stakeholder comms

DataOps

ETL pipelines

Tools

Azure Data Factory

SSIS Integration Runtime

Azure SQL Managed Instance

Python / PySpark

Databricks

Purview

CI/CD

Job description

T+O+M Executive is seeking a Data Engineer to help modernise a financial services data platform in Sydney. You will migrate a legacy SQL Server data warehouse to Azure SQL Managed Instance and build secure, tested data solutions for governance and analytics.

You will design and implement ETL/ELT pipelines, models and datasets for regulatory and management reporting, with a focus on DataOps, runbooks and strong validation. Collaboration with risk and business stakeholders is essential.