Payroll Data Analyst

Company Overview

United Infrastructure is a dynamic and rapidly expanding business, focused on delivering critical infrastructure projects across the utility and social infrastructure sectors. Our team of highly skilled and hardworking specialists deliver innovative solutions to the complex challenges our clients face.

Our company is split into two business areas:

• Utility Infrastructure – Our team of Utility Infrastructure specialists design, build and maintain critical water, energy (gas), power and telecoms infrastructure for the UK’s largest network owners and operators.
• Social Infrastructure – Our team of Social Infrastructure specialists revitalise homes and communities by carrying out a wide range of work, from retrofit to refurbishment, and maintenance.

This is a critical short‑term role until the end of May focused on supporting the payroll system implementation project. The Payroll Data Analyst will be responsible for extracting, cleansing, validating, mapping, and reconciling payroll data to ensure a smooth and accurate transition from legacy systems into the new platform.

You will work closely with Payroll, HR, Finance, and the Systems Implementation team to ensure data quality, compliance, and readiness for testing and go‑live.

• Extract payroll and employee data from legacy systems
• Cleanse, standardise, and validate large payroll datasets
• Map legacy payroll data fields to the new system structure
• Support data migration activities and upload templates
• Perform detailed reconciliation of payroll data pre‑ and post‑migration
• Identify and resolve data anomalies, inconsistencies, and gaps
• Support payroll parallel runs and system testing cycles
• Work closely with system vendors and internal stakeholders during testing
• Produce clear documentation of data mapping, assumptions, and processes
• Ensure compliance with payroll legislation and data protection requirements
• Provide support during go‑live and post‑implementation validation

• Strong payroll knowledge and understanding of payroll processes
• Proven experience working with payroll data, data migration, or system implementation
• Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, data validation, reconciliation)
• Experience handling large, complex datasets with high accuracy
• Strong analytical and problem‑solving skills
• Excellent attention to detail
• Ability to work to tight deadlines in a project environment
• Strong stakeholder communication skills

• Experience supporting payroll or HR system implementations (e.g., iTrent, SAP, Oracle, Workday)
• Understanding of data mapping and migration methodologies
• Knowledge of payroll legislation and compliance requirements
• Experience working with transformation or systems projects

This is a fixed‑term position until the end of May, with the potential for extension.