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.
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.
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.
Responsibilities
1. Build and test clinical datasets using SQL queries, views and stored procedures, to stakeholder requirements and detailed specifications.
2. Developing and amending data models within the data warehouse which mirror the business requirements of the organisation and then developing auditable data flows which populate them.
3. Provide a high level of documentation which tracks build and test activities throughout the data migration, and warehouse build.
4. Ensure accurate reporting flows from the Trust's data warehouse, in line with stakeholder requirements and Trust business needs.
5. Work with clinical and operational stakeholders to understand clinical data usage, purpose and constraints, and the impact of poor data quality.
6. 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.
7. 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.
8. Present highly complex information to a wide range of stakeholders. This includes dealing with complex ad‑hoc queries and prototyping dataset solutions.
9. Supporting research and development by working with research colleagues on build and test of specialist datasets.
10. The post holder will take part in meetings with the EPR supplier technical team, and present results of build and test activities.
Equal Opportunity
The Trust is committed to providing services which embrace diversity and that promote equality of opportunity. We are a Disability Confident Employer, we welcome applicants from all sections of the community and people of all protected characteristics. We provide reasonable adjustments for candidates with a disability and are committed to treating people fairly with compassion, respect and dignity and in promoting equality and human rights. We aim to put this commitment into practice by:
* Embedding our commitment to tackling inequality, eliminating discrimination and harassment; promoting equality of opportunity and fostering good relations in our everyday practice
* Ensuring that all our services and all staff understand and support our commitment
* We believe that people who use our services, their carers and our staff, should be treated with compassion, respect and dignity
SLaM is a Stonewall Diversity Champion, Stonewall is the largest Lesbian, Gay, Bi and Trans (LGBT) rights charity in Europe.
Please note:
* That all applications for this post will need to be made online
* That you read and understand the Job Description and Person Specification attached to the role. Your Statement in Support should reflect the requirements specified as your application will be judged against these criteria
* That the closing date listed is a guide only and that the vacancy may close earlier should sufficient number of applicants have been received. We advise that you submit your application as early as possible
* That once you have submitted your application you agree to your application being transferred to a 3rd party e‑recruitment system. All subsequent information regarding your application will be generated from apps.trac.jobs
* That should you not have heard from us within three weeks from the closing date your application has not been successful
* That priority consideration for applications may be given to at‑risk NHS employees
* That should you be successful and appointed, you authorise South London and Maudsley NHS Foundation Trust to confirm your previous NHS service via an Inter Authority Transfer (IAT) process
* That we are a smoke‑free Trust
Helpful Resource: How to Use TRAC for Job Applications. If you're preparing to apply for a role, this guide provides step‑by‑step instructions on how to use TRAC effectively throughout the application process: Using TRAC to apply.
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.
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.
#J-18808-Ljbffr