Payroll Data Analyst

Medivet Group Limited; United States; Remote; USD 60,000 - 87,000; Full time

Job summary

Medivet is seeking a Payroll Data Analyst to transform payroll data into meaningful insights, ensure accuracy and support strategic decisions across Payroll, People, Finance and Operations.

You will analyze trends, create dashboards and reports, and help drive improvements in payroll processes while maintaining compliance with UK payroll regulations and data protection standards.

Qualifications

• Experience in payroll reporting, finance analysis or data analytics in a complex organisation.
• Confidence working with large datasets and investigating discrepancies.
• Advanced Excel skills: Pivot Tables, XLOOKUP/VLOOKUP, Power Query, data validation.
• Experience with payroll systems and HR databases.
• Strong analytical and problem-solving abilities with clear recommendations.
• High accuracy and attention to detail with sensitive payroll data.
• Excellent communication and stakeholder management.
• Ability to manage competing priorities and meet deadlines.
• Knowledge of National Minimum Wage legislation and compliance.

Responsibilities

• Turn data into insights by analysing payroll information to support business decisions.
• Perform payroll reconciliations, validate data and investigate discrepancies.
• Create and maintain payroll reports, dashboards and KPIs, including costs, overtime, absence, pensions.
• Support payroll audits, data quality checks and internal controls for compliance.
• Identify opportunities to simplify processes and automate reporting.
• Contribute to payroll system enhancements, testing and data migration activities.
• Collaborate with Payroll, People, Reward, People Systems and Finance to translate data into actionable info.

Skills

Advanced Excel

Payroll reporting

Data analytics

Attention to detail

Communication

Tools

Workday

OpenPeople

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.