Data Migration Specialist in Chorley

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. 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. Although 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.

Responsibilities

• 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:

• 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
• Able to drive efficiencies within migration delivery processes
• Able to work effectively under pressure, working on multiple activities and engagement simultaneously
• 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

Able to demonstrate ESG's key values of 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.