Job summary
- Main area
- Digital
- Grade
- NHS AfC: Band 7
- Contract
- Fixed term: 12 months (FTC 12 Months)
- Hours
- Full time - 37.5 hours per week
- Job ref
- 334-NCL-7866644-MU
- Employer
- South London and Maudsley NHS Foundation Trust
- Employer type
- NHS
- Site
- IOPPN
- Town
- London
- Salary
- £56,276 - £63,176 Per Annum inclusive of HCAS
- Salary period
- Yearly
- Closing
- 13/04/2026 23:59
Employer heading
EPR Data Engineer
NHS AfC: Band 7
South London and Maudsley NHS Foundation Trust has a rich history, well-established community links and an international reputation. We deliver specialist services in the London boroughs of Croydon, Lambeth, Lewisham and Southwark, Bexley, Bromley, Greenwich, Wandsworth and Richmond.
We are committed to provide a high quality and specialist care to our service users and we are recognised for our care and treatment we provide. The Care Quality Commission already rates our services as ‘good’.
We launched our five-year strategy, Aiming High; Changing Lives in 2021 together with Our Care Improvement System as our quality management system methodology to make a positive impact on patient care, outcomes and staff experience. By joining SLaM, all staff will get the opportunity to be part of this exciting improvement journey supported with learning and development to harness everyone’s potential as change makers.
The trust recognises the unique and valuable contribution that people with lived experience of mental illness can bring to a role. We therefore welcome applications from people with lived experience and consider them as an asset to the Trust.
Our Values
We take pride in providing specialist care to our service users where our Trust values and our promise to be caring, kind, polite, prompt, honest, listen and do what I say I’m going to do is at the heart of everything we do. When you join us, you’ll be part of something special.
As a Trust we are happy to talk flexible working.
Job overview
SLaM is migrating from our current EPR to a new system throughout 2026 and 2027. The EPR implementation forms an integral part of an innovative and exciting Clinical Transformation programme that will be enabled by a comprehensive digital experience, incorporating a wide range of EPR functionality required to deliver excellent patient care.
Career Progression pathways and development opportunities:
We are committed to get the very best out of our staff and support staff in their career aspirations. We have career pathways available, where you will be able to develop your skills and build on your experience to progress into other roles across different specialties. In addition, we offer ongoing training and development in conjunction with the BCS membership.
Main duties of the job
The post holder will support the new EPR Programme to deliver a reliable dataset for migration to our new system. They will use excellent SQL skills to build and test datasets, and knowledge of ETL and warehouse design (Microsoft Azure environment), to contribute to a new data warehouse to hold Trust reporting. They will 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. They will be committed to data quality, principles of information governance and will be highly motivated to deliver accurate, valid and timely work.
Flexible working:
As one of the few Trusts in London we are proud to offer flexible working as part of our new ways of working, and we are happy to talk flexible working at the interview stage. In this role you will be able to work Monday to Friday in the time frames from 8am to 6pm, giving you the very best of good work life balance.
Working for our organisation
This role is in the EPR which sits under the Digital Services Directorate. The Directorate utilises technology and digital solutions to empower our staff to work effectively and to improve the care our service users receive. The postholder will report to the Chief Clinical Information Officer and work closely with multidisciplinary project workstreams, Digital and external departments / teams across the Trust as directed.
About our 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 is within walking distance from the beautiful green spaces of Ruskin park and the vibrant high-street that offers great shopping opportunities and with a wide range restaurants.
Detailed job description and main responsibilities
Key Responsibilities:
- Build and test clinical datasets using SQL queries, views and stored procedures, to stakeholder requirements and detailed specifications.
- Developing and amending data models within the data warehouse which the mirror the business requirements of the organisation and then developing auditable data flows which 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.
- Presenting of highly complex information to a wide range of stakeholders. This includes dealing with complex ad hoc queries and prototyping dataset solutions..
- Supporting research and development by working with research colleagues on build and test of specialist datasets.
- The post holder will take part in meetings with the EPR supplier technical team, and present results of build and test activities
Person specification
Qualifications, Skills, Knowledge
Essential criteria
- 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 documentation of results.
- Evidence of experience with ETL and understanding of warehouse design
- Highly methodical approach, and attention to detail.
- The facilitation of a stakeholder focussed 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 their workload, and be able to work under pressure
- 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 criteria
- Higher post-graduate education in a relevant subject
- Relevant Professional qualifications
- Experience of developing data pipelines using Microsoft Azure Data Factory
- Understand 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
Employer certification / accreditation badges
Documents to download
Further details / informal visits contact
- Name
- Mike Carey
- Job title
- Programme Manager
- Email address
- [email protected]
- Additional information
Please note this position may close before the listed deadline if more than 50 applications are received. Interested candidates are encouraged to apply as soon as possible.
List jobs with South London and Maudsley NHS Foundation Trust in Administrative Services or all sectors