Skip to main content

This site is independent of the NHS and the Department of Health.

Please wait, loading

Job summary

Main area
Digital
Grade
Band 7
Contract
Fixed term: 18 months (Temporary contract)
Hours
  • Full time
  • Flexible working
37.5 hours per week (Monday to Friday within office hours, possible Out of Hours working during EPR deployment)
Job ref
246-COR7322840
Employer
Norfolk and Suffolk NHS Foundation Trust
Employer type
NHS
Site
County Hall
Town
Norwich
Salary
£46,148 - £52,809 This role is subject to Job Evaluation
Salary period
Yearly
Closing
18/09/2025 23:59

Employer heading

Norfolk and Suffolk NHS Foundation Trust logo

Data Warehouse Developer EPR Integration Specialist

Band 7

Norfolk and Suffolk NHS Foundation Trust provides child and adult mental health services, learning disability, wellbeing, older people's and eating disorder services across Norfolk and Suffolk.

We are committed to equality, diversity and inclusion and want to reflect the diversity of our local communities within our teams.  We welcome applications from all talented individuals with the relevant qualifications, skills, knowledge and experience

Please note, NSFT uses tools to screen any applications generated by Artificial Intelligence (AI).

Job overview

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.

Working for our organisation

Here at NSFT we pride ourselves on being a welcoming, talented, friendly and supportive team who like nothing better than sharing experiences and learning from each other. In addition to ongoing training and development opportunities, we are committed to providing an environment in which you can thrive.

Why work for us? We have challenges as a Trust, but we have ambitious aspirations, are pushing ahead with exciting transformation work and we need dedicated individuals to support us on our journey. We have strong, established professional networks coupled with an exceptional leadership team who will ensure you are truly cared for and cared about.


Why Norfolk and Suffolk? The people here are warm and welcoming, you’ll never be far from the beautiful coastline or Broads National Park. We’re an hour and a half away from London and have an international airport in Norwich too. Our villages, towns and cities are packed full of history, independent cafes, shops and theatres. We have excellent shopping, eating out, top ranking schooling and affordable house prices too. 

Detailed job description and main responsibilities

Please read the job description / person specification carefully and ensure your application reflects the knowledge, skills and experience needed

Person specification

Qualifications

Essential criteria
  • 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 criteria
  • Microsoft Azure or equivalent cloud certification

Experience

Essential criteria
  • 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 criteria
  • Experience with SystmOne or other NHS clinical systems
  • Experience contributing to data migration programmes

Skills

Essential criteria
  • 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 criteria
  • Data Modelling using Unified Modelling Language or similar.
  • Developing Data Warehouse documentation.

Knowledge

Essential criteria
  • 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 criteria
  • Awareness of national digital health strategies and interoperability frameworks

Employer certification / accreditation badges

Veteran AwareApprenticeships logoNo smoking policyMenopause Friendly EmployerAge positiveInvestors in People: GoldImproving working livesArmed Forces Covenant (Silver Award)Mindful employer.  Being positive about mental health.We offer Wagestream - A financial wellbeing benefit which lets you access your pay as you earn it.Disability confident employerStonewall equality policy. Equality and justice for lesbians, gay men, bisexual and trans people.Step into healthNational Preceptorship for Nursing Quality MarkHappy to Talk Flexible WorkingWomens Staff NetworkCycle to Work

Documents to download

Apply online now

Further details / informal visits contact

Name
Josh Jones
Job title
Solutions Architect
Email address
[email protected]
Apply online nowAlert me to similar vacancies