Job Summary
Are you passionate about data integration and digital transformation in healthcare? We’re looking for a highly skilled and motivated Data Warehouse Developer – EPR Integration Specialist to join our Digital Directorate. This is a pivotal role supporting the implementation of our new Electronic Patient Record (EPR) system, ensuring seamless data flow into our data warehouse and onward to reporting systems. You’ll lead on developing robust ETL processes, support data migration, and act as a technical expert across integration projects. If you thrive in a collaborative environment, enjoy solving complex data challenges, and want to make a real impact on patient care through digital innovation, we’d love to hear from you.
Main duties of the job
- Lead the design, development, and maintenance of automated ETL processes to integrate EPR data into the Trust’s data warehouse.
- Ensure data accuracy, quality, and governance across reporting and analytics platforms.
- Support the EPR data migration workstream by developing extraction routines and validating migrated data.
- Act as the technical liaison with EPR vendors and third-party system providers to resolve integration issues.
- Provide line management and mentorship to the Data Warehouse Programmer, fostering a culture of learning and collaboration.
- Contribute to Trust-wide digital transformation initiatives, offering expert advice on data architecture and interoperability.
- Develop and maintain technical documentation to support knowledge transfer and audit readiness.
- Uphold NSFT’s TALK values–Team, Accountable, Learn and Improve, and Kind–in all aspects of your work.
Person Specification
Qualifications
Essential
- Masters level qualification or equivalent level of knowledge attained through a recognised training in Health Informatics, Information Technology, Computer Science or a related discipline and equivalent proven relevant experience
Desirable
- Microsoft Azure or equivalent cloud certification
Experience
Essential
- Significant experience in developing and supporting ETL processes and data warehouse systems
- Experience working with large-scale healthcare data, including EPR systems
- Experience using Azure Data Factory, T-SQL, and data modelling tools
- Experience leading technical projects or workstreams
Desirable
- Experience with SystmOne or other NHS clinical systems
- Experience contributing to data migration programmes
Skills
Essential
- Provide and receive highly complex, sensitive or contentious information; agreement or co-operation required; present complex, sensitive or contentious information to large groups. Communicates a range of IM&T issues which can be complex and multi-stranded. Negotiates priorities on e.g. IT training, system design and development, reporting processes with non IM&T managers; Trains or presents on complex IM&T issues.
- Complex facts or situations requiring analysis, interpretation, comparison of a range of options – Analyses, investigates and resolves complex IM&T queries and issues/problems e.g. System errors, breaches of security or confidentiality, user requirements which may require configuration of software and hardware, unusual data trends, training requirements based on needs analysis.
- Plan and organise broad range of complex activities; formulates, adjusts plans or strategies Plans specialist projects which impact across clinical and non clinical areas. E.g. Planning training delivery for a team of trainers or for a new system.
Desirable
- Data Modelling using Unified Modelling Language or similar.
- Developing Data Warehouse documentation.
Knowledge
Essential
- Specialist knowledge and expertise across one or more specialised areas, acquired through degree level or equivalent qualification/experience plus additional specialist knowledge.
- Detailed knowledge of database systems, and data warehouse modelling
Desirable
- Awareness of national digital health strategies and interoperability frameworks
Other
Essential
- Ability to attend on-site at County Hall or Hellesdon Hospital in Norwich on a regular basis
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
Closing Date: 18 September 2025
