Data Engineer
Job summary
The Data Engineer will play a key role in the development and operation of the organisation's modern data architecture, supporting the implementation of the Electronic Patient Record (EPR) and the wider digital data ecosystem. The postholder will design and maintain robust data pipelines, integrations and engineering solutions that enable secure, reliable and high-quality data flows across clinical systems, analytics platforms and national services.
Although hybrid working is in place and available across the team, as this role will be key to the EPR programme there will be a requirement to be on site at Sherwood Forest Hospitals a minimum of 3 days per week.
Main duties of the job
The postholder will ensure that data is accurately extracted, transformed and loaded (ETL) into the new EPR platform, maintaining integrity, security and compliance with NHS standards. They will work closely with technical teams, suppliers and clinical stakeholders to deliver reliable data solutions that support safe and efficient patient care.
The role aligns with the NHS National Competency Framework for Data Professionals and represents a Senior Practitioner-level data engineering position. The postholder will support the wider organisational data agenda by ensuring alignment between the EPR, the data platform and other core systems, contributing to major transformation programmes and the ongoing development of the Trust's data infrastructure.
They will help shape the Trust's future data architecture by ensuring that EPR and related system data can be securely integrated with organisational and national platforms, including the NHS Federated Data Platform (FDP), in line with interoperability and governance requirements.
As priorities evolve, the postholder will work across areas such as system integration, platform development, pipeline optimisation and the enhancement of organisational data assets. This flexible approach ensures specialist engineering capability is deployed where it delivers the greatest benefit, supporting programme delivery and the long-term sustainability of the Trust's data and digital services.
About us
Derbyshire Support and Facilities Services Ltd. (DSFS) is a subsidiary company that's 100% owned by Chesterfield Royal Hospital NHS Foundation Trust.
DSFS has just over 900 staff across Soft and Hard Facilities Services, and our corporate services including, ICT, Patient Records, Switchboard, Procurement, Finance and Clinical Engineering. Very much part of the 'Chesterfield Royal family', DSFS builds on solid NHS foundations to offer a more commercial approach that's dynamic, flexible, and proactive.
DSFS are proud to be striving to achieve a truly diverse and inclusive flexible workforce by valuing and welcoming everyone's abilities, uniqueness, and individuality. All our colleagues have the right to and should be able to feel 100% themselves at work; we believe that all our people add to and should improve our culture and not just fit in with it. By embracing our diverse backgrounds and differences our culture becomes richer and makes us stronger together.
Derbyshire Support and Facilities Services Limited currently do not offer a Certificate of Sponsorship, any applications which require sponsorship will not be considered
Please see below link for the DSFS website.
DSFS - Derbyshire Support & Facilities Services Limited | DSFS
When applying for roles please complete all sections of the application form.
Job description
Job responsibilities
Data Migration and Transformation The postholder will lead the design and execution of data migration strategies, ensuring that legacy data is cleansed, validated, and accurately transferred to the new EPR system. They will develop ETL processes, manage trial loads, and oversee reconciliation activities to guarantee data completeness and accuracy. This includes working with clinical teams to validate migrated data and resolve discrepancies.
Integration and Interoperability The EPR Data Engineer will support the development and maintenance of system integrations using standards such as HL7 and FHIR. They will collaborate with integration partners and internal teams to ensure seamless data exchange between the EPR and other clinical systems, including pathology, radiology, pharmacy, and device interfaces.
Data Quality and Assurance The postholder will implement data quality checks and validation routines to maintain high standards of accuracy and reliability. They will produce audit trails, reconciliation reports, and compliance documentation to meet governance and assurance requirements. This includes supporting go-live readiness assessments and post-implementation reviews.
Technical Development and Support The role involves developing scripts, queries, and automation tools to streamline data processes. The EPR Data Engineer will provide technical support during testing phases, troubleshoot data-related issues, and contribute to performance optimisation of the EPR system.
Compliance and Security The postholder will ensure that all data handling activities comply with NHS information governance standards, UK GDPR, and DSPT requirements. They will work closely with the Information Governance and Cyber Security teams to maintain secure data environments and implement appropriate access controls.
Collaboration and Communication The EPR Data Engineer will engage with clinical, operational, and technical stakeholders to understand data requirements and provide expert advice. They will contribute to project documentation, training materials, and knowledge transfer sessions to build organisational capability in data management.
Person Specification
Qualifications and Training
- Degree in Computer Science, Data Engineering, or a related discipline, or equivalent experience.
- Formal certification in data management, ETL processes, or database administration.
- Training in healthcare informatics or NHS data standards.
Experience
- Proven experience in data migration and ETL processes within large-scale system implementations.
- Strong background in SQL and relational database management systems.
- Experience in developing scripts and automation for data handling.
- Previous experience with EPR systems or healthcare data environments.
- Familiarity with SNOMED CT, dm+d, and clinical coding standards.
- Exposure to cloud-based data platforms and APIs.
Knowledge and Skills
- Understanding of integration standards (HL7, FHIR) and interoperability frameworks.
- Knowledge of NHS information governance, data protection, and DSPT compliance.
- Excellent problem-solving skills and attention to detail.
- Knowledge of scripting languages (Python, PowerShell) for automation.
- Understanding of data migration strategies and reconciliation processes.
- Familiarity with performance optimisation and data quality assurance techniques.
Behaviours
- Ability to work collaboratively in a multi-disciplinary team environment.
- Strong communication skills to explain technical concepts to non-technical stakeholders
- Commitment to NHS values and patient safety
- Proactive approach to continuous improvement and innovation.
- Ability to work under pressure and adapt to changing priorities.
Other Requirements
- Ability to travel and work onsite as required
- Willingness to work flexibly to meet programme demands
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.
UK Registration
Applicants must have current UK professional registration. For further information please see NHS Careers website.
Employer details
Employer name
Chesterfield Royal Hospital NHS Foundation Trust
Address
Sherwood Forest Hospitals
Mansfield Rd
Sutton In Ashfield
NG17 4JL
Employer's website
https://www.chesterfieldroyal.nhs.uk/