Job Introduction

Role Title                         Data Engineer

Location:                         Leeds (Hybrid)

Contract:                         Permanent

Working Pattern:            Full Time

Salary:                             £45,000 - £50,000

As part of our digital transformation, Medical Protection Society is seeking a talented Data Engineer to join the Data and Analytics Team to develop data products and services and integrate them into our systems and business processes. You will be responsible for analysing raw data to build and manage the datasets on our data platform, enabling wider consumption of data by the end users and will play a key role in the transformation of data into models that can be used for analytics and reporting

Role Responsibility

• Embrace change management processes (projects or small change) and partner with the appropriate teams and business analysts to make business recommendations to assist in delivering reporting, insight, process improvements, or strategies that support MPS in delivering its vision, values, and purpose.
• Implement data flows to connect operational systems, data for analytics and business intelligence
• Document source-to-target mappings
• Re-engineer manual data flows to enable scaling and repeatable use
• Develop data services that are fit for purpose, resilient, scalable, and future proof, to meet user needs. 
• Write ETL scripts and code to ensure optimal performance in the ETL process 
• Produce relevant data models 
• Plan, design, manage, execute and report tests, using appropriate tools and techniques. 
• Understand and document risks associated with deployment

The Ideal Candidate

• Previous experience in a data engineer role as part of data platform 
• Experience with modelling, structured, semi-structured and non-structured data
• Experience in development and maintenance of data dictionaries and catalogues
• Demonstrate an understanding of how to expose data from systems (for example, through APIs), link data from multiple systems and deliver streaming services.
• Understanding of different tools and comparing different data models. 
• Experience of reverse engineering data models from live systems. 
• Experience in using Azure Dev Ops with Git Repository
• Strong knowledge of MS SQL Server (writing queries, stored procedures, performance tuning, etc.), ETL design, processes, strategy and architecture

Diversity & Inclusion

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.

If you have any questions about any advertised role and how we can support you, please contact our Recruitment Team.

About the Company

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.

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 Talent Acquisition 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 our Talent Acquisition team by emailing careers@medicalprotection.org.

Medical Protection Society