EPR Data Engineer
The closing date is 13 April 2026
SLaM is migrating from our current Electronic Patient Record (EPR) to a new system throughout 2026 and 2027. The EPR implementation forms an integral part of an innovative Clinical Transformation programme, enabling a comprehensive digital experience and a wide range of EPR functionality required to deliver excellent patient care.
Career Progression pathways and development opportunities: We are committed to getting the very best out of our staff and supporting career aspirations. Career pathways are available, allowing you to develop skills and build on experience to progress into other roles across specialties. Ongoing training and development are offered in conjunction with BCS membership.
Main duties of the job
* Support the EPR Programme to deliver a reliable dataset for migration to the new system.
* Use excellent SQL skills to build and test datasets, and apply knowledge of ETL and warehouse design within a Microsoft Azure environment to contribute to a new data warehouse for Trust reporting.
* Work with technical colleagues within the EPR team, as well as colleagues in Transformation and Training, to ensure data integrity and continuity for frontline clinical staff.
* Commit to data quality, principles of information governance, and deliver accurate, valid and timely work.
* Build and test clinical datasets using SQL queries, views and stored procedures, according to stakeholder requirements and detailed specifications.
* Develop and amend data models within the data warehouse to mirror the business requirements of the organisation, and develop auditable data flows to populate them.
* Provide high‑level documentation that tracks build and test activities throughout the data migration and warehouse build.
* Ensure accurate reporting flows from the Trust's data warehouse in line with stakeholder requirements and business needs.
* Work with clinical and operational stakeholders to understand data usage, purpose and constraints, and the impact of poor data quality.
* Monitor typical errors or issues with clinical data capture during migration and lead the development of data quality monitoring tools and techniques to support the uptake of the new EPR.
* Collaborate with business analysts, EPR configuration colleagues and clinical testers to develop functional test scenarios for data validation and user acceptance testing; lead during the testing period to document, investigate and resolve issues.
* Present highly complex information to a wide range of stakeholders, including complex ad‑hoc queries and prototyping dataset solutions.
* Support research and development by working with research colleagues on the build and test of specialist datasets.
* Participate in meetings with the EPR supplier technical team and present results of build and test activities.
Flexible working
As one of the few Trusts in London, we offer flexible working as part of our new ways of working. We discuss flexible arrangements during the interview stage. The role runs Monday to Friday, 8am‑6pm, providing an excellent work‑life balance.
About us
This role sits within the Digital Services Directorate, which utilises technology and digital solutions to empower staff and improve care for service users. The postholder reports to the Chief Clinical Information Officer and works closely with multidisciplinary project workstreams, digital and external departments/teams across the Trust.
Location
The EPR team are located at IOPPN, 16 De Crespigny Park, London SE5 8AB – less than 5 minutes from the train station (zone 2) and within walking distance of Ruskin Park and a vibrant high‑street with many shopping and dining options.
Job responsibilities
* Build and test clinical datasets using SQL queries, views and stored procedures, to stakeholder requirements and detailed specifications.
* Develop and amend data models within the data warehouse that mirror the business requirements of the organisation and develop auditable data flows to populate them.
* Provide a high level of documentation which tracks build and test activities throughout the data migration and warehouse build.
* Ensure accurate reporting flows from the Trust's data warehouse, in line with stakeholder requirements and Trust business needs.
* Work with clinical and operational stakeholders to understand clinical data usage, purpose and constraints, and the impact of poor data quality.
* Monitor typical errors or issues with clinical data capture throughout the migration period and lead on the development of data quality monitoring tools and techniques to support uptake of the new EPR.
* Work alongside business analysts, EPR configuration colleagues and clinical testers to develop functional test scenarios for data validation and user acceptance testing. Lead during testing period to document, investigate and resolve issues arising from testing.
* Present highly complex information to a wide range of stakeholders, dealing with complex ad hoc queries and prototyping dataset solutions.
* Support research and development by working with research colleagues on build and test of specialist datasets.
* Take part in meetings with the EPR supplier technical team and present results of build and test activities.
Qualifications, Skills, Knowledge
Essential
* Educated to Degree level or equivalent experience.
* Evidence of professional/managerial development.
* Extensive experience in developing queries, views and stored procedures in Microsoft SQL Server (SSIS/SSRS/SSAS/T‑SQL).
* Experience of formal data validation, working to testing plans and documenting results.
* Experience with ETL and an understanding of warehouse design.
* Highly methodical and attention to detail.
* The facilitation of a stakeholder‑focused culture within a team.
* Excellent written, verbal and other media communications / presentation skills.
* A logical and sensible approach to problem solving.
* Ability to organise and prioritise workload and work under pressure.
* Ability to analyse and apply user information to problem solving.
* Ability to express complex issues both orally and in writing in an easily understood manner for a range of audiences.
* Negotiation, influencing and persuading skills.
* Pro‑active and self‑motivated in completing work to a high standard in conjunction with other staff.
* Excellent team skills and ability to work with members of own and other teams and departments at all levels of the organisation.
Desirable
* Higher post‑graduate education in a relevant subject.
* Relevant Professional qualifications.
* Experience of developing data pipelines using Microsoft Azure Data Factory.
* Understanding of data quality concepts, and principles of Information Governance and best practice in healthcare data.
* Prince 2, Agile or other Project Management methodologies.
* Use of ITIL in a work environment.
* Knowledge of mental health services.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and requires a submission to the Disclosure and Barring Service to check for any previous criminal convictions.
Certificate of Sponsorship
Applications from job seekers who require Skilled Worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, Skilled Worker applicants, applying for entry clearance to the UK, are required to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here: Criminal records checks for overseas applicants (Opens in a new tab).
Employer details
Employer name
South London and Maudsley NHS Foundation Trust
Address
IOPPN
London
SE5 8AB
Employer's website
https://www.slam.nhs.uk/ (Opens in a new tab)
£56,276 to £63,176 a year – per annum inclusive of HCAS
#J-18808-Ljbffr