Remote Data Migration Consultant - SQL/ETL Expert

Consult; Reading; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

Consult is seeking an experienced Implementation Consultant – Data Migration to support delivery of complex technology implementations and data transformations in the UK. This full-time, work-from-home role is based in UK and initially offered for 12 months with potential extension.

You will design and optimise SQL-based migration solutions, profile data, define mappings, run ETL processes, and ensure data quality and governance while communicating clearly with clients and internal teams.

Qualifications

• Enterprise-scale data migration delivery
• ETL design and execution
• Data mapping, profiling, cleansing, transformation, reconciliation and validation
• Data quality management
• Advanced SQL and T-SQL (CTEs, window functions, stored procedures)
• Indexing, partitioning and query optimisation
• Microsoft SQL Server and SSMS
• Database design, data modelling and normalisation
• Performance tuning and troubleshooting
• Migration planning, cutover and rollback approaches
• Requirements gathering and specification writing
• Strong analytical and numerical skills
• Client-facing communication and documentation

Responsibilities

• Design, build and optimise SQL-based migration and reporting solutions
• Develop migration strategies, plans, cutover approaches and rollback controls
• Profile source data and define mapping, transformation, cleansing, reconciliation and validation rules
• Run ETL operations ensuring accuracy, completeness and minimal service disruption
• Automate migrations using T-SQL and related tooling
• Tune performance through indexing, partitioning and query optimisation
• Identify migration risks and drive mitigation and remediation
• Support configuration of workflows, interfaces, payroll data and reports
• Ensure compliance with data protection, privacy, version control and change management
• Document, train and hand over knowledge to clients and internal teams

Skills

Data migration

ETL design

SQL proficiency

SQL Server

Data profiling

Data cleansing

Data validation

Performance tuning

Migration planning

Client communication

Requirements writing

Analytical skills

Tools

SQL Server

SSMS

T-SQL

Azure SQL

Job description

Consult is seeking an experienced Implementation Consultant – Data Migration to support delivery of complex technology implementations and data transformations in the UK. This full-time, work-from-home role is based in UK and initially offered for 12 months with potential extension.

You will design and optimise SQL-based migration solutions, profile data, define mappings, run ETL processes, and ensure data quality and governance while communicating clearly with clients and internal teams.