Projects / PRJ-05
Workforce data automation in Python
Automated recurring HealthRoster workforce data workflows and management information reporting for an NHS trust, cutting 25 to 30 percent of the time spent on routine reporting.
- Ref
- PRJ-05
- Status
- Shipped
- Data
- Built inside the Trust. Shown as method and outcome only.
- Stack
- Python · HealthRoster · Excel
- Last updated
- 02 Nov 2026
What changed
Workforce information work runs on cycles. The same extracts come out of HealthRoster, get reshaped by hand, get checked, and get turned into the same reports for service leads and senior managers. Every manual step is time, and every rekeyed number is a chance for an error that someone downstream will make a decision on.
I replaced the manual extract and reshape steps with Python scripts across HealthRoster data operations covering 200 to 250 staff. The result was a 25 to 30 percent workflow efficiency gain on routine reporting, more consistent data, and an end to the manual processing errors that came with rekeying.
Around the automation
- KPI dashboards and management information reports for service leads and senior management.
- Trend analysis on rostering, capacity and leave patterns to inform workforce planning.
- Root cause analysis on data anomalies, working across teams to fix integrity problems at source.
- Workforce data analysis for the Trust’s Cost Improvement Programme, delivering £280k of validated savings. The full story is in CS-03.