Data Engineer | Financial Services | MSBI to Azure & ADF

Tallentire O'Flynn Movsowitz; Sydney; Sur place; AUD 150 000 - 210 000; Plein temps

Résumé du poste

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.

Responsabilités

• 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.

Connaissances

Advanced SQL Server skills

ETL/ELT pipelines

Data modeling (dimensional)

Strong stakeholder communication

5+ years data engineering/BI/analytics

Outils

Azure Data Factory

SSIS Integration Runtime

Azure SQL Managed Instance

CI/CD

Python

PySpark

Power BI

Description du poste

Data Engineer | Financial Services | MSBI to Azure & ADF

The role
Join a financial services organisation modernising its enterprise data platform. You’ll help migrate a legacy SQL Server data warehouse to Azure SQL Managed Instance, building secure, tested and well-monitored data solutions that the business can rely on.

What you’ll do

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

What you’ll bring

5+ years in data engineering, BI, data warehousing or analytics delivery

Advanced SQL Server skills: stored procedures, performance tuning and data modelling

Azure SQL Managed Instance, Azure Data Factory or SSIS Integration Runtime

Proven experience building, scheduling, reconciling and supporting ETL/ELT pipelines for material data flows

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

Nice to have

Banking or financial services background

Data warehouse or cloud migration experience

Power BI, Fabric, Databricks, Purview, CI/CD, Python or PySpark

Why apply

Hands-on work on a major warehouse migration, exposure to governance, architecture, risk and reporting teams, and real scope to lift engineering and automation practices.