Job Introduction

We have an exciting opportunity for a highly experienced, seasoned Data Engineer to join our Data and Analytics team based in Leeds!

As we develop as an organisation, our need for understanding our data becomes ever more important. Data drives business decisions and our global strategy and this is a brilliant opportunity to join a forward-thinking and supportive team.

Working alongside our Head of Data, you will help develop and construct our data products, analyse raw data and play a key role in transforming our data to drive MPS forward, as we continue to develop our cloud (Azure) infrastructure.

As our Data Engineer, you will utilise your self-starter, analytical and problem-solving skills to manage a diverse backlog, develop new initiatives and ultimately influence member growth.

You will be the link between data preparation and data analysis, liaising closely with key stakeholders to understand business needs and contributing to the delivery of our Data and Analytics strategy.

Role Responsibility

As our new Data Engineer, you will also:

• Building accessible data and patterns to support the wider organisations and promote self-serve
• Playing a pivotal role in the delivery and governance of reporting, analytics and the quality of data
• Driving business decisions and performance by allowing MPS to better understand its data
• Developing data services that are fit for purpose, resilient and future proof

The Ideal Candidate

We are looking for:

• A keen, analytical and problem-solving mindset
• Experience in dimensional modelling (Kimball methodology)
• Experience with PowerBi Services – Semantic models
• Strong data management experience and the ability to construct complex queries using T-SQL
• Hands on experience of Microsoft Azure including (but not limited to) Azure Data Factory (ADF) and/or Synapse, Azure SQL DB, Azure Data Lake etc
• Experience of using Azure Dev Ops: Boards, Repos & Pipelines (classic and/or YAML)

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.

Package Description

Alongside a competitive salary as stated above, you will also receive:

• Up to 15% discretionary annual bonus
• Annual performance-related pay review
• 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 plus flexible bank holidays (option to buy/sell additional 5 days)
• Private Medical Cover
• Career development and progression opportunities – 22% of our vacancies in 2023 were filled internally
• A truly flexible hybrid-working arrangement (take a look at below to find out more about how we work)
• A culture that promotes inclusivity, wellbeing, and rewards hard work
• Car Salary Sacrifice scheme
• Healthcare cash plan
• 6x salary death in service

About the Company

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, in countries as diverse as the United Kingdom, South Africa and Hong Kong.

We are a not-for-profit organisation, meaning our Members’ premiums are either invested into bettering the organisation, its employees and our products, or kept safe should our Members require support for complaints or claims arising from professional practice.

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.

Next Steps

If you are interested in finding out more, looking for a new role and want to join an organisation that truly values its employees, take a look at the role profile to find out more about the role to apply.

Our Recruitment team are always on hand should you have any questions, are having any technical issues or wish to understand how MPS can support you with your application and interview. You can contact Recruitment by email careers@medicalprotection.org

Medical Protection Society