Payroll Data Analyst

Medivet; United States; Remote; USD 65,000 - 90,000; Full time

Job summary

Medivet is seeking a payroll data analytics specialist to identify trends, ensure accurate payroll processing and provide clear reporting across Finance, Payroll and HR teams. You will translate complex data into actionable insights and support system enhancements.

The role requires experience with payroll reporting, strong Excel and data visualization skills, and the ability to work with stakeholders to drive improvements while maintaining strict data accuracy and compliance.

Qualifications

• Experience in payroll reporting or finance analytics in a complex organisation.
• Ability to build detailed reports and investigate discrepancies.
• Strong Excel skills including Pivot Tables, XLOOKUP, and data validation.

Responsibilities

• Turn data into insights by analysing payroll information and identifying trends.
• 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 compliance.
• Identify process improvements and automate reporting where possible.
• Assist with payroll system enhancements, testing and data migration.

Skills

Advanced Excel

Data analysis

Payroll reporting

Stakeholder communication

Problem solving

Education

Bachelor's degree in Finance/Accounting/Analytics

Tools

Power BI

Tableau

SQL

Workday

OpenPeople

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.