Data Analyst - Pay

Medical Protection Society; Leeds; Hybrid; GBP 23,000 - 28,000; Part time

Benefits offered by this job

Pension

25 days annual leave

Flexible holidays

Private Medical Cover

Death in service 6x

Wellbeing support

Hybrid-working

Inclusive culture

Job summary

Medical Protection Society (MPS) is seeking a highly analytical Data Analyst to transform pay and payroll data into meaningful insights that guide reward decisions. You will combine advanced Excel skills with storytelling to model pay reviews, identify trends and present recommendations to the Reward team within a flexible, hybrid setup.

The role focuses on turning data into actionable insights, developing dashboards, and communicating findings to stakeholders to shape pay decisions for

Qualifications

• Advanced Microsoft Excel skills including complex formulas, lookups and PivotTables.

Responsibilities

• Produce insightful analysis and reporting on pay, payroll and colleague data.
• Build models to support pay reviews and reward-related projects.
• Conduct trend analysis, scenario modelling and financial impact assessments.
• Turn complex data into clear recommendations and business insights.
• Create engaging reports that help stakeholders understand the story behind the data.

Skills

Advanced Excel

Job description

Location: Leeds City Centre (Hybrid) - 1 day per week in the office

Contract: 6 Month Fixed Term Contract

Working Pattern: 0.6FTE (22.5 Hours) - Flexible working pattern to suit you.

Salary: Full Time Equivalent of £43,000 upwards (Dependent on Experience). Pro Rata - £25,800 upwards

Help shape pay decisions through data, insight and storytellingAt Medical Protection Society (MPS), we protect the careers, reputations and livelihoods of hundreds of thousands of healthcare professionals around the world. Every day, our work helps doctors, dentists and healthcare professionals navigate some of the most challenging moments of their careers.Behind that mission is a commitment to attracting, retaining and rewarding exceptional talent. That's where this role comes in.We're looking for a highly analytical Data Analyst who can transform complex people, pay and payroll data into meaningful insight that influences business decisions. This is an opportunity to become the go-to expert for reward analytics, helping MPS understand not just what the data says, but what it means and what actions should follow.You'll combine exceptional Excel expertise with commercial curiosity, bringing data to life through clear analysis, compelling visualisation and engaging storytelling. Whether you're modelling the impact of a pay review, identifying emerging trends, supporting strategic workforce decisions or presenting insights to the Reward team, you'll play a vital role in shaping how we reward and support our colleagues.If you're someone who loves digging into complex data, spotting patterns others miss and creating clear narratives that drive action, we'd love to hear from you.

What you’ll be doing

You’ll play a key role in supporting our reward and pay activities by:

• Producing insightful analysis and reporting on pay, payroll and colleague data
• Building models to support pay reviews and reward related projects
• Conducting trend analysis, scenario modelling and financial impact assessments
• Turning complex data into clear recommendations and business insights
• Creating engaging reports that help stakeholders understand the story behind the data

You don't need experience working in a reward team or with pay related data. You'll bring Advanced Microsoft Excel skills, including complex formulas, lookups, PivotTables, data reconciliation and analytical reporting. You'll stand out if you're someone who:

• Doesn't just report the numbers but explains what they mean
• Build a compelling narrative from data
• Is naturally curious and enjoys digging beneath the surface
• Challenges assumptions using evidence and insight
• Enjoys finding better ways of analysing, visualising and communicating data

In return, we can offer you:

• 11% pension contribution (3% from you, 8% from us – optional additional matched 3% contributions, e.g. 6% from you, 11% from us)
• 25 days annual leave.
• Flexible public holidays and option to buy/sell additional leave
• Private Medical Cover
• 6x salary death in service
• Holistic health and wellbeing support package
• A truly flexible hybrid-working arrangement
• A culture that promotes inclusivity, wellbeing and rewards hard work

We welcome applicants from all backgrounds, and we encourage you to apply even if you feel you do not match 100% of the technical requirements.We celebrate diversity, promote inclusivity and strive to create a work environment which ensures everyone can be heard.

Who We Are

Medical Protection Society (MPS) is the world’s leading protection organisation for Doctors, Dentists and healthcare professionals. We protect and support the professional interests of almost 300,000 Members around the world.We are a not-for-profit organisation, meaning our Members’ premiums are kept safe should our Members require support for complaints or claims arising from professional practice, or invested into bettering the organisation, our colleagues and our products.Our philosophy is to support safe practice in medicine and dentistry by helping to avert problems in the first place. We also actively campaign for regulatory and legal reforms that benefit Members and the wider healthcare professions. To do this, we need colleagues who are trusted and supported to deliver their best work, whether that be through leadership development, fully-funded training courses or peer-to-peer support. We want our colleagues to feel empowered enough to deliver positive change, display ambition to push themselves and are determined when faced with a challenge, whilst ensuring our Member’s best interests are at the core.