Data Analyst, Pay (22.5 hours per week)

The Medical Protection Society Limited; United States; Hybrid; USD 31,000 - 38,000; Part time

Job summary

Medical Protection Society in Leeds is seeking a Reward Analyst on a six-month fixed-term contract to turn people, pay and payroll data into insightful analysis and help colleagues make informed decisions.

You will apply advanced Excel skills to analyse pay data, build models for pay reviews and reward projects, and translate complex information into practical recommendations and engaging reports for stakeholders.

Qualifications

• Advanced Excel skills including complex formulas, lookups, PivotTables, reconciliation and analytical reporting.

Responsibilities

• Analyse and report on pay, payroll and colleague data.
• Build models for pay reviews and reward projects.
• Carry out trend analysis, scenario modelling and financial impact assessments.
• Translate complex data into practical recommendations and engaging reports.

Skills

Advanced Excel

PivotTables

Lookups

Formulas

Reconciliation

Analytical reporting

Tools

Excel

Job description

About Medical Protection Society

Medical Protection Society is a not-for-profit organisation supporting and protecting healthcare professionals.

About the role

Join the Reward team on a six-month fixed-term contract, turning people, pay and payroll data into useful insight and helping colleagues make informed decisions.

Key responsibilities

• Analyse and report on pay, payroll and colleague data.
• Build models for pay reviews and reward projects.
• Carry out trend analysis, scenario modelling and financial impact assessments.
• Translate complex data into practical recommendations and engaging reports.

About you

You will bring advanced Excel skills, including complex formulas, lookups, PivotTables, reconciliation and analytical reporting. You can explain the story behind data, challenge assumptions with evidence and communicate insights clearly. Previous experience in reward or pay data is not essential.

Hours, location and salary

22.5 hours per week, with a flexible working pattern. Hybrid working with one day a week in the Leeds city centre office. Salary is £25,800 upwards per year for the part-time hours, depending on experience (£43,000 upwards full-time equivalent).