vAbout the Opportunity

Join a significant data modernisation initiative focused on migrating legacy data assets onto Microsoft Fabric and establishing a modern, governed and maintainable data platform. This is a hands-on engineering role where you will move data into OneLake, reverse engineer complex legacy SQL and ETL, rebuild transformation logic in dbt and establish the automation, testing and documentation needed for the platform to operate successfully beyond go-live.

About the Role

You will take ownership of core migration and transformation activities, working across legacy platforms and the new Microsoft Fabric environment.

• Profile legacy databases, stored procedures, jobs and downstream dependencies.
• Migrate data into OneLake using Fabric Data Factory, mirroring and appropriate ingestion patterns.
• Reverse engineer complex SQL and rebuild legacy ETL/stored procedures as modular dbt models.
• Build dbt sources, staging models, business logic and reporting marts across Fabric.
• Reconcile legacy and migrated datasets and implement automated data quality testing.
• Establish Git-based CI/CD, deployment pipelines, monitoring and environment management.

About You

You will be an experienced Data Engineer who combines strong SQL and migration capability with genuine hands-on experience across Microsoft Fabric and dbt.

• Proven delivery of legacy database migrations to modern cloud data platforms.
• Strong hands-on dbt experience across models, tests, macros, snapshots and documentation.
• Advanced SQL skills, particularly reverse engineering and modularising stored procedures.
• Microsoft Fabric experience across OneLake, Warehouse/Lakehouse and Data Factory pipelines.
• Strong dimensional modelling, reconciliation, data quality and layered warehouse experience.
• Git and CI/CD experience using Azure DevOps or GitHub for automated data deployments.