Data Migration Specialist

Overview

Data Migration Specialist £450-£470/day (Outside IR35) 6-month Contract London – Hybrid – Two days per week in the office We are representing a globally renowned brand, operating in the Media industry, who are looking for a Data Migration Specialist to join their team on a contract basis. This is a highly technical role that blends hands-on development with strategic data management, offering the chance to lead critical data migration activities within this well-respected organisation. As the Data Migration Specialist, you will take ownership of designing and executing data migrations from legacy systems, developing standardised ETL packages using Azure Data Factory. You'll be responsible for ensuring data quality, accuracy, and integrity throughout the migration process, while establishing robust processes and documentation that ensure consistency across technology. You'll work closely with functional and business leads, testing teams, and the Integration Team to align data migration activities with overall integration strategies and business objectives. We are looking for: Extensive experience in ETL development using SQL, Azure Data Factory, Synapse Pipelines, and Stored Procedures Proven experience in legacy data migration and ERP implementations, including at least two full life cycle implementations in a Data Analyst role Strong SQL and SSIS experience It would be a bonus if you had: Experience with reporting tools such as Power BI and business intelligence dashboards Familiarity with integration tools like AIS and SAP BTP Knowledge of Azure Synapse, Data Lakes, Data Warehouse, SQL Server, and Databricks If this sounds of interest, please apply.

Responsibilities

• Design and execute data migrations from legacy systems.
• Develop standardised ETL packages using Azure Data Factory.
• Ensure data quality, accuracy, and integrity throughout the migration process.
• Establish and document robust processes for consistency across technology.
• Collaborate with functional leads and testing teams on migration activities.
• Align data migration strategies with overall integration objectives.

Requirements

• Extensive experience in ETL development using SQL, Azure Data Factory, and Stored Procedures.
• Proven history of legacy data migration and ERP implementations with at least two full life cycle projects.
• Strong SQL and SSIS experience.
• Familiarity with reporting tools such as Power BI and business intelligence dashboards is a plus.
• Experience with integration tools like AIS and SAP BTP is advantageous.
• Knowledge of Azure Synapse, Data Lakes, Data Warehouse, SQL Server, and Databricks is beneficial.