Data Engineer - Financial Services (MSBI to Azure & ADF)

About the role

A financial services organisation in Sydney is modernising its enterprise data platform and is looking for a Data Engineer to help migrate a legacy SQL Server data warehouse to Azure SQL Managed Instance. The role involves building secure, tested and well-monitored data solutions, and is advertised as a full-time position.

Key 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.
• 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, with runbooks and documentation.

Required profile

• 5+ years in data engineering, BI, data warehousing or analytics delivery.
• Proven experience building, scheduling, reconciling and supporting ETL/ELT pipelines.
• Strong grounding in dimensional modelling, data quality controls and reconciliation.
• Working knowledge of incident, problem and change management.
• Clear communicator across technical, business and risk stakeholders.

Required skills

• Advanced SQL Server skills: stored procedures, performance tuning and data modelling.
• Azure SQL Managed Instance, Azure Data Factory or SSIS Integration Runtime.
• Nice to have: banking or financial services background, data warehouse or cloud migration experience, Power BI, Fabric, Databricks, Purview, CI/CD, Python or PySpark.