Payroll Data Analyst

DataAnalystJobs; Watford; On-site; GBP 32,000 - 52,000; Full time

Job summary

Medivet is seeking a data-savvy Payroll Analyst to join our team in the UK. You will analyse payroll data, produce reports and dashboards, and help ensure HMRC compliance and accurate payroll processing.

You will work closely with Payroll, People, Finance and Operations to translate complex data into clear recommendations and drive process improvements across the organisation.

Qualifications

• Experience in payroll reporting, finance analysis or data analytics.
• Ability to handle large datasets and investigate discrepancies.
• Strong Excel skills with advanced formulas and data validation.

Responsibilities

• Turn data into insights by analysing payroll information to identify trends and opportunities.
• Perform payroll reconciliations and validate data to ensure accuracy.
• Create and maintain payroll reports, dashboards and KPIs.
• Support audits, data quality checks and internal controls for HMRC compliance.
• Identify opportunities to automate reporting and simplify processes.
• Assist with payroll system enhancements, testing and data migration.
• Collaborate with Payroll, People, Finance and Operations to translate data into actionable findings.

Skills

Advanced Excel

Pivot Tables

XLOOKUP/VLOOKUP

Power Query

Payroll Systems

HR Databases

Analytical Thinking

Tools

Power BI

Tableau

SQL

Job description

This is an exciting opportunity for someone who enjoys working with data, solving problems and finding smarter ways of working. You'll use your analytical expertise to identify trends, improve processes and provide valuable insights that support payroll accuracy, compliance and improvements by working collaboratively with colleagues across Payroll, People, Finance and Operations.

What You'll Be Doing

• Turning data into insights: Analysing payroll information to identify trends, anomalies and opportunities for improvement, providing meaningful insights to support business decisions.
• Ensuring accuracy: Performing payroll reconciliations, validating data and investigating discrepancies to maintain accurate and reliable payroll information.
• Delivering effective reporting: Creating and maintaining payroll reports, dashboards and key performance indicators, including analysis of payroll costs, overtime, absence, pensions and statutory payments.
• Strengthening compliance: Supporting payroll audits, data quality checks and internal controls, ensuring compliance with HMRC requirements, National Minimum Wage legislation and data protection regulations.
• Driving improvements: Identifying opportunities to simplify processes, automate reporting and improve how we manage payroll data.
• Supporting systems and projects: Contributing to payroll system enhancements, testing, implementations and data migration activities.
• Working collaboratively: Partnering with Payroll, People, Reward, People Systems and Finance colleagues, translating complex data into clear, actionable information.

What you'll bring:

• Experience in payroll reporting, finance analysis or data analytics, ideally within a complex organisation.
• Confidence working with large datasets, producing detailed reports and investigating discrepancies.
• Advanced Excel skills, including Pivot Tables, XLOOKUP/VLOOKUP, Power Query, complex formulas and data validation.
• Experience working with payroll systems and HR databases.
• Strong analytical and problem-solving skills, with the ability to turn complex information into clear, practical recommendations.
• A high level of accuracy and attention to detail, particularly when working with sensitive payroll information.
• Excellent communication skills and the ability to build effective relationships with stakeholders across the business.
• The ability to manage competing priorities and deliver accurate work to deadlines.
• Strong knowledge of National Minimum Wage legislation and compliance, including salary sacrifice, deductions, working time calculations and payroll checks.

It would also be great if you have:

• Experience using Workday or OpenPeople payroll systems.
• Knowledge of Power BI, Tableau, SQL or other data reporting and extraction tools.
• An understanding of UK payroll legislation, including PAYE, National Insurance, pensions and statutory payments.
• Experience supporting payroll system implementations, upgrades or testing projects.

Why Join Medivet?

At Medivet, we're passionate about creating an environment where our people can thrive and make a meaningful contribution.

Joining our team means becoming part of a collaborative business where your expertise and ideas are valued. You'll have the opportunity to work with colleagues across different functions, contribute to meaningful improvements and help shape how we use data to support our people and our practices.

If you're analytical, curious and motivated by making things work better, we'd love to hear from you.