About the role
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.
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 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.