Data Migration Specialist - Chorley

ESG Global Ltd; Chorley; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading software and services company in Chorley is seeking a Data Migration Specialist to drive data migration projects in a hybrid model. This full-time role demands strong SQL skills and analytical abilities, with responsibilities including full lifecycle data migrations and validation processes. The ideal candidate will lead client engagement, ensure data accuracy, and work closely with internal teams. Flexible working patterns are welcome. Competitive salary and benefits offered.

Benefits

Flexible working policies

Training and development opportunities

Collaborative team environment

Qualifications

• Proven experience in data migration projects, preferably in enterprise environments.
• Strong understanding of data structures, relational databases, and ETL concepts.
• Ability to translate business requirements into technical specifications.

Responsibilities

• Lead full lifecycle data migrations, including discovery, profiling, mapping, and validation.
• Work closely with stakeholders to clarify requirements and resolve data issues.
• Design data quality checks and validation frameworks.

Skills

Strong SQL skills (MySQL, MS SQL or equivalent)

Excellent analytical and problem-solving skills

Strong communication and stakeholder management skills

Proven experience in data migration projects

Strong understanding of data structures and relational databases

Tools

Data migration tools

Cloud platforms (AWS)

Job description

Data Migration Specialist

Job Description

Department: Delivery Services

Reports To: Migration Lead/Programme Manager

Work Location: Chorley - Hybrid

Hours of Work: 37.5

Position Type: Full-Time

Rate Type: Salary

Grade: 5

SUMMARY

We are an innovative and market‑leading software & services company based in Chorley serving clients in the utility sector ranging from new entrants to large existing suppliers. We deliver sophisticated software solutions and managed services in a Hybrid Cloud infrastructure, servicing both traditional and modern real‑time, smart energy clients.

We operate a Hybrid working policy so you will be able to flex between working in the office and your home location to carry out this role, however during your initial training period the need to be in the office with other team members will be essential. Our UK office is based in Chorley, which is where you will be based.

While this position is full‑time, we are open to discussing flexible working patterns that accommodate individual needs. If you require flexibility in your work schedule, please let us know during the application process, and we will do our best to accommodate your needs.

The Data Migration Specialist will be responsible for planning, executing, and validating data migration activities as part of system implementation or transformation projects. This role requires strong analytical skills and the ability to work closely with clients to understand their business context, translate requirements into migration templates, and support validation, assessment, and testing processes. As this is a new role to ESG, you will be expected to lead the charge with helping to shape and define the role and key responsibilities in conjunction with key internal stakeholders to ensure it delivers value to our internal teams and our customers.

While the role operates within core working hours, as this is client‑facing, there may be occasional requirements to provide support during evenings or weekends for specific delivery projects or events.

POSITION RESPONSIBILITIES

The main duties (but not limited to) are the following:

• Client Engagement & Requirements Gathering
  • Lead full lifecycle data migrations, including discovery, profiling, mapping, transformation, validation, and cutover.
  • Work closely with product, engineering, and business stakeholders to clarify requirements, resolve data issues, and manage dependencies.
  • Translate business context into detailed migration templates and mapping documents.
  • Support go‑live activities including data load execution, troubleshooting, and post‑migration verification.
• Data Analysis & Migration Design
  • Analyse and understand legacy data structures, source systems, and business rules to design accurate, maintainable mapping specifications.
  • Develop migration strategies, including extraction, transformation, and loading (ETL) processes.
• Validation & Testing Support
  • Design robust data quality checks, reconciliation routines, and validation frameworks to ensure accuracy and completeness.
  • Support data validation and reconciliation activities to ensure accuracy and completeness of migrated data.
  • Assist in designing and executing test plans for migration‑related scenarios, including mock runs and cutover.
• Quality Assurance & Documentation
  • Maintain detailed documentation of migration processes, templates, and validation results.
  • Ensure compliance with data governance, security, and regulatory requirements.
• Issue Resolution & Continuous Improvement
  • Identify and resolve data migration issues promptly.
  • Recommend improvements to migration methodologies and tools

About You

We welcome diverse people from all abilities, gender identities, ethnicities, ages, sexual orientations, life experiences and backgrounds to join us.

You must have

• Strong SQL skills (MySQL, MS SQL or equivalent)
• Proven experience in data migration projects, preferably in enterprise environments.
• Strong understanding of data structures, relational databases, and ETL concepts.
• Excellent analytical and problem‑solving skills.
• Ability to translate business requirements into technical specifications and templates.
• Strong communication and stakeholder management skills.

Desirable

• Experience with data migration tools
• Familiarity with data quality and governance principles.
• Familiarity with JSON, XML, SFTP‑based data ingestion, and API‑based data sources.
• Experience with cloud platforms (AWS)
• Experience with parallel runs, audit frameworks, and regulatory data reporting.
• Knowledge and experience of the UK Retail Energy sector

You will be

• Be able to communicate clearly with Clients, Internal teams and Industry representatives
• Detail‑oriented with a focus on data accuracy and integrity.
• Comfortable working in client‑facing roles and managing expectations.
• Ability to work under pressure and meet project deadlines.
• Have a keen interest in continuous improvement
• Be able to drive efficiencies within migration delivery processes
• Be able to work effectively under pressure, working on multiple activities and engagement simultaneously
• Be able to focus on both detail and accuracy with a good level of technical understanding
• Adaptable to the changing needs of customer and business requirements when required

Essential ESG Values

• Excellence: be accountable to deliver our best
• Passion: show how much we care each day
• Integrity: do the right thing when no one is looking
• Collaboration: work together to succeed together

ISO AWARENESS

• Follow IMS Policies
• Reporting of Incidents
• ISO Responsibilities
• ISO Staff Awareness

*For more information on how we process your information please see our privacy notice which can be found on our website https://esgglobal.com/privacy-policy/*

Benefits: Grade 5