Payroll Data Analyst

Medivet & Partners; Watford; Vor Ort; GBP 38.000 - 52.000; Vollzeit

Zusammenfassung

Medivet & Partners is seeking a Payroll Data Analyst to turn payroll data into actionable insights and support accurate payroll processing. You will identify trends, validate data, and create dashboards to inform decisions across Payroll, People, Finance and Operations.

The role requires advanced Excel skills, experience with payroll systems, and a strong eye for detail. You will collaborate with stakeholders to drive improvements and ensure compliance with HMRC and NMW regulations.

Qualifikationen

• Experience in payroll reporting, finance analysis or data analytics.
• 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 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.

Aufgaben

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

Kenntnisse

Payroll reporting

Finance analysis

Data analytics

Advanced Excel

Pivot Tables

Power Query

XLOOKUP/VLOOKUP

HR databases

Tools

Power BI

Tableau

SQL

Workday

OpenPeople

Jobbeschreibung

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.