EPR Data Engineer
Job summary
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.
About us
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.Job description
Job 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
- 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.
- 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
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Certificate of Sponsorship
Applications from job seekers who require current 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.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had 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.
Employer details
Employer name
South London and Maudsley NHS Foundation Trust
Address
IOPPN
London
SE5 8AB
Employer's website
https://www.slam.nhs.uk/