Turning 10 million records into a data model to support trainee doctors

Combining quantitative research, data management and predictive modelling for Health Education England (HEE).

The challenge

Recruiting the nation’s best healthcare workers is just the beginning for Health Education England. The institution trains employees for seven years, investing as much as £250,000 into the careers of doctors.

Reducing turnover is critical. HEE needed help spotting the career moments where they could provide much-needed support.

The solution

• Predicting dissatisfaction by helping HEE understand the dynamics around employee attrition over time, going way beyond high-level workforce analytics.
• Building a unified data warehouse to process over 10 million records from multiple NHS and HEE systems​, creating a scalable platform that data scientists across departments can use collaboratively.
• Reinforcing confidence in data​ by collating and cleaning data from different sources to develop a machine learning model that predicts attrition throughout the career journey.​

Transform focused on:

• Quantitative research for a more in-depth understanding of attrition factors and potential intervention approaches.
• Data management to create a centralised repository of employee information, making it easier to reuse models to improve performance and reduce time and cost to create insights.
• Predictive modelling identifying churn signals for each trainee from the start of ​each placement and beyond.

Learn more

Our work in the public sector extends beyond this project. If you’re interested in hearing more about our wider experience, please get in touch.