Lead Data Migration Engineer

Salary: £55,000 - 95,000 per year

Requirements:

• Proven experience in data engineering and data migration delivery, particularly within cloud environments
• Strong focus on data pipeline testing, validation, and quality assurance
• Ability to work across the full data lifecycle, with emphasis on migration and transformation
• Strong analytical, problem-solving, and communication skills
• Experience working in client-facing and delivery-focused environments
• Ability to mentor junior engineers and contribute to team delivery
• Strong hands-on experience with AWS cloud services, especially AWS Glue
• Strong hands-on experience with Python / PySpark for data transformation
• Strong hands-on experience with SQL for querying, validation, and reconciliation
• Strong hands-on experience with YAML configuration for pipeline orchestration
• Experience testing and validating end-to-end ETL/ELT pipelines and data migration workflows
• Familiarity with Apache Iceberg and Lakehouse architectures
• Familiarity with distributed processing frameworks such as Apache Spark
• Familiarity with data lake environments
• Understanding of ETL vs ELT design patterns and migration performance tuning
• Experience with version control and CI/CD tools is desirable

Responsibilities:

• Work as a senior engineer within data migration programmes, supporting delivery across complex transformation initiatives
• Collaborate with architects and stakeholders to implement migration strategies and technical solutions
• Contribute to project planning, estimation, and execution of migration deliverables
• Design, build, and optimise data migration pipelines from legacy data warehouses to AWS-based Data Lakehouse platforms
• Develop and maintain ETL/ELT pipelines using AWS Glue, Python / PySpark, SQL, and YAML-driven configurations
• Implement bulk data migration processes followed by incremental/delta loads
• Support pipeline repointing and replatforming to target cloud architectures
• Test end-to-end ETL data solutions running on AWS services, including AWS Glue and Apache Iceberg
• Validate data feed pipeline migrations transitioning to new AWS Data Lakehouse architectures
• Test pipelines underpinned by AI ETL accelerators, Python/PySpark transformations, SQL-based logic, and YAML configuration-driven orchestration
• Execute and validate initial bulk data loads and subsequent incremental/delta migrations
• Develop and run SQL-based validation and reconciliation queries to ensure data completeness, accuracy, and transformation correctness
• Support creation of automated testing and validation frameworks
• Work hands-on with AWS cloud services, including AWS Glue and S3-based data lakes
• Support implementation of Data Lakehouse architectures, including Apache Iceberg
• Optimise data pipelines for performance, scalability, and reliability in cloud environments
• Apply data transformation logic aligned to migration mapping rules
• Support data modelling activities required for target-state schemas
• Ensure consistency between source and target systems during migration
• Collaborate with solution architects, data engineers, data migration architects, analysts, and QA teams
• Promote engineering best practices, reusable components, and automation
• Contribute to migration accelerators and reusable frameworks
• Ensure data integrity, quality, and traceability throughout migration processes
• Follow best practices for secure data handling in regulated environments
• Support compliance with GDPR and UK public sector data requirements where applicable
• Contribute to audit and validation processes

Technologies:

• AI
• AWS
• AWS Glue
• CI/CD
• Cloud
• ETL
• Support
• Python
• PySpark
• SQL
• Spark
• Network

More:

We are a global business that empowers local teams and delivers exciting work that is genuinely changing the world. Our portfolio spans consulting, applications, business process, cloud, and infrastructure services, and you will work with brilliant colleagues and clients on exciting projects. We offer an inclusive work environment built on mutual respect, accountability, and continuous learning, with a strong focus on collaboration, well-being, growth, and agility. We also provide tailored benefits supporting physical, emotional, and financial wellbeing, continuous learning and development opportunities, and flexible work options. We are proud to be an equal opportunities employer and a Disability Confident Committed Employer, with active Inclusion Networks supporting women, cultural and ethnicity, LGBTQ+ and allies, neurodiversity, and parents.

last updated 34 week of 2026