HR & Payroll Senior Data Migration Analyst

EQUANS SERVICES LIMITED; Newcastle upon Tyne; On-site; GBP 50,000 - 60,000; Full time

Benefits offered by this job

Car allowance

Bonus

Free parking

Life Cover

Gym membership discounts

Job summary

Equans is seeking a HR & Payroll Senior Data Migration Analyst to lead end-to-end migration of HR and payroll data into SAP ECC6. The role is based at Quorum Business Park, Newcastle or Wath-upon-Dearne, Rotherham, on a 12-month basis, with a 37.5-hour week and a salary of £50,000–£60,000 plus car allowance, bonus and benefits.

You will manage data extraction, cleansing, mapping, loading and post-load validation, coordinating with HR, Payroll, IT and Capgemini to ensure data quality and timely

Qualifications

• Proven experience delivering data migration projects, Ideally HR and payroll.
• Strong knowledge of HR/payroll data structures.
• Advanced Excel skills for large dataset analysis.
• Experience with SAP HR systems (HCM/ECC6).
• Understanding of data governance and GDPR requirements.

Responsibilities

• Extract HR and payroll data from legacy systems accurately.
• Cleanse and validate data before migration.
• Map data to SAP structures and load into SAP.
• Validate post-load results and support UAT/dress rehearsals.
• Maintain audit trails and migration documentation.

Skills

Data migration

HR data

Payroll data

SAP ECC6

SAP HCM

Excel

Data validation

Stakeholder mgmt

GDPR

Data cleansing

Education

Degree in Data Analytics or related

Tools

SAP ECC6

SAP HCM

Job description

Equans is looking for a HR & Payroll Senior Data Migration Analyst to join our team based at Quorum Business Park, Newcastle or Wath-upon-Dearne, Rotherham on a temporary basis (12 month). This is a full time role working 37.5 hours per week. On offer is a salary of £50,000 - £60,000 per annum, dependant upon skills and experience as well as car allowance, bonus and benefits package

Equans UK is undertaking a major workforce systems transformation, migrating HR and payroll data for approximately 2,300 employees from HR.net and MiraclePay into SAP ECC6. We are recruiting a senior Data Analyst to lead and own the end-to-end data migration lifecycle for this project: receiving data extracts from source systems, cleansing and validating them, mapping them to SAP field structures, loading into SAP, and validating the results post-load. This is a hands-on, delivery-focused role suited to someone who has a proven track record working directly with large, sensitive HR and payroll datasets, has a meticulous eye for data quality, and can work confidently with both business stakeholders and technical delivery teams (including our implementation partner, Capgemini) to get data migration right first time leading the migration.

You’ll be based at our brand new, super modern Shared Services office in Newcastle, which is a dynamic multifunctional operation, where our people are committed to delivering great services that enable our business to meet its goals.

We invest in our people through a broad range of learning opportunities such as professional qualifications, collective/individual training, and personalised support programmes.

We care about the health and wellbeing of our people and we’re proud of our Better Health at work Gold certification, achieved through various campaigns and activities supporting our employees.

We champion diversity and inclusion in the workplace and have various forums across Shared Services where we encourage our people to take part, get involved and continue to shape and build on the culture we are proud of here at Equans Shared Services.

What will you deliver?

• Ensure accurate and complete extraction of HR and payroll data from legacy systems, reducing migration risks and preventing critical data gaps during transition.
• Improve data quality by identifying, cleansing, and resolving data issues before migration, resulting in more reliable employee and payroll records within SAP.
• Deliver accurate mapping of business-critical HR and payroll data to SAP structures, ensuring consistency of employee, organisational, and payroll information across the organisation.
• Support successful SAP data loads by preparing, validating, and troubleshooting migration files, minimising delays and reducing rework during dress rehearsals and go-live activities.
• Provide robust post-migration validation and reconciliation, ensuring data completeness, integrity, and stakeholder confidence in the new system.
• Enable successful User Acceptance Testing (UAT) and Parallel Runs by providing high-quality data and resolving migration-related defects efficiently.
• Maintain comprehensive audit trails, reconciliation evidence, and migration documentation, supporting governance, compliance, and project sign-off requirements.
• Work collaboratively with HR, Payroll, IT teams, and implementation partners to resolve issues, manage risks, and ensure alignment throughout the migration lifecycle.
• Contribute to project planning, cutover readiness, RAID management, and status reporting, helping to ensure delivery of a successful HR and Payroll transformation programme.
• Facilitate knowledge transfer and documentation, enabling smooth transition to business-as-usual operations and long-term maintenance of HR and payroll data within SAP.
• Ensure the successful migration of approximately 2,300 employee records from HR.net and MiraclePay into SAP ECC6, safeguarding payroll continuity and business operations.
• Reduce operational, compliance, and payroll risks by delivering trusted, high-quality employee and payroll data within the target SAP environment.
• Support the wider Equans workforce systems transformation by enabling the decommissioning of legacy systems and adoption of standardised HR and payroll processes.

What can we offer you?

On offer is a competitive salary, car allowance, bonus and benefits package, which includes;

• 25 days annual leave (+ public holidays).
• Free parking.
• Life Cover equivalent to 2 times annual salary.
• Employee discount shopping schemes on major brands and retailers.
• Gym membership discounts.
• Cycle to work scheme.
• Holiday purchase scheme.
• 2 corporate social responsibility days per year.
• Broad range of learning opportunities, such as professional qualifications, collective/individual training, and personalized support programmes.
• Attractive Employee Referral Rewards Scheme.
• Access to our growing employee networks including WiE (Women in Equans), RISE (BAME), LGBTQI+, Working Parents, YPN (Young Persons Network) and our Disability Network.
• 24/7 Employee Assistance Program and access to mental wellbeing app.

Who are we looking for?

• Degree in Data Analytics, Information Systems, Computer Science, Human Resources, Payroll, or a related discipline, or equivalent industry experience is desirable but NOT essential.
• Proven experience delivering data migration projects, ideally involving HR and payroll systems.
• Strong knowledge of HR and payroll data structures, including employee master data, organisational assignment, pay elements, and payroll processes.
• Working knowledge of SAP HCM, SAP ECC6, SAP Payroll, or similar enterprise HR systems.
• Advanced Microsoft Excel skills, including formulas, lookups, pivot tables, and large dataset analysis.
• Experience in data validation, cleansing, mapping, reconciliation, and migration testing.
• Strong understanding of data governance, GDPR, confidentiality, and the handling of sensitive employee and payroll information.
• Excellent stakeholder management and communication skills, with the ability to work effectively across HR, Payroll, IT, and external delivery partners
• Proven experience as a Data Analyst on a data migration project, ideally within HR and/or payroll systems.
• High attention to detail and a rigorous, methodical approach to data quality and validation.
• Hands‑on experience validating, cleansing, mapping, and loading data between systems.
• Strong Excel skills (e.g. formulas, lookups, pivot tables, data cleansing techniques) for large, complex datasets.
• Working knowledge of SAP (SAP HCM/ECC6 or similar SAP modules), including familiarity with infotypes and organisational/payroll data structures.
• Understanding of HR and/or Payroll data structures and terminology (e.g. employee master data, organisational assignment, pay elements).
• Strong communication skills, able to work effectively with both technical teams and non-technical HR/payroll stakeholders.
• Ability to manage sensitive personal and payroll data in line with data protection and confidentiality requirements.
• Experience with SAP data load tools.

This role includes a Basic DBS check therefore ability to pass is essential.

Who are we?

In the UK & Ireland, Equans is a provider of sustainable facilities management and regeneration, and cutting-edge energy and digital services. Our 15,000 employees combine these activities to deliver decarbonisation across the built environment and help businesses, communities, public sector organisations and government to accelerate the transition to a low carbon, resilient world.

Globally, Equans is a world leader in the energy and services sector with operations in 20 countries, 90,000 employees working on 5 continents and a turnover of 19.2 billion euros in 2024. Equans is a subsidiary of the Bouygues group.

Our ambition

At Equans, we are driven by our ambition to be recognised for our operational excellence and as the best place to work for our employees. This commitment extends to achieving global and sustainable performance through Impact, ensuring that everything we do aligns with our core values-Accountability, Respect, Team Spirit, and Service Focus.

We take ownership, act with integrity, and set high standards. We listen, support, and care for one another. We collaborate and build trust to achieve shared goals, always striving to meet our customers' needs in a proactive and pragmatic way. These values shape our culture, strengthen our community, and inspire us to deliver excellence every day.

At Equans we're committed to delivering a culture where everyone's voice is heard and supported. We know the value a diverse workforce creates, delivering better results for our people, customers and stakeholders. Diversity and inclusion is at the core of what we do, should you join Equans you'll find a welcoming and open workplace where you're supported and encouraged to be your true self at work. You'll also have access to our growing employee networks including WiE (Women in Equans), RISE (BAME), LGBTQI+, Working Parents, YPN (Young Professionals Network) and our Disability Network.

For this role, you must have evidence of the right to work in the UK. Unfortunately we are not able to offer a re-location package with this job role. Certain roles may require applicants to undergo a Disclosure check, as noted in the role requirements.

The Equans Resourcing Team supports this job advert. Agency involvement is not required. All related enquiries must come to the resourcing team not direct to Equans Managers.