Job Summary
We are seeking an experienced Data Engineer to lead the migration of our Trust’s data management services in preparation for the implementation of a new Electronic Patient Records (EPR) system in April 2026. This role will ensure a seamless transition to a new data warehouse environment, and customer-focused business intelligence service delivery model. The ideal candidate will bring expertise in SQL Server databases, ETL processes and data model design, along with a proven track record of data engineering within a healthcare or NHS environment. A strong focus on delivering high-quality, secure, and accessible data services is essential to support informed decision-making and operational excellence across the organisation.
This role offers flexibility, with UK based remote working options available and the possibility of part-time hours.
Main duties of the job
- Collaborate with Information Team Leads to understand service needs and translate them into data solutions
- Develop and execute a comprehensive data infrastructure migration strategy for migration and decommissioning of legacy infrastructure
- Develop a detailed data migration and infrastructure set-up roadmap and workplans with milestones, timelines, and resource allocation
- Allocate resources effectively to meet project milestones and resolve project-related challengeso Identify and test methods for robust, scalable, and efficient cross organisation data transfer
- Provide hands-on technical guidance to EPR reporting workstream leads
- Develop and test disaster recovery plans in the new environment
- Lead the adoption of new tools and frameworks to improve team efficiency and system performance Implement processes to monitor, troubleshoot, and improve data workflows in the new infrastructure
- Catalogue non epic existing data sources currently warehoused
- Set-up and configure the TSD new data warehouse environment including networking, security, and access controls
- Establish policies for data security, compliance, and governance
- Define roles and responsibilities for data access and usage
- Map and migrate database schemas (tables, views, indexes) to the target environment
- Adjust for platform-specific differences (e.g., SQL syntax, data types)
- Validate and transform data during migration to match new system requirements
Person Specification
Qualifications and Training
Essential
- Educated to master’s level, or equivalent knowledge, experience & expertise in Health Informatics
- Evidence of continuous professional development within health informatics and business intelligence technologies
- Management qualification or evidence of professional development in managing, coaching and developing staff
- SQL professional certification
Desirable
- Prince 2 or Agile Project Management Certification
- Microsoft SQL Server certification
Knowledge and Experience
Essential
- Substantial experience within health care data management
- Knowledge of healthcare service delivery models and information standards for Adult Social Care, Community and Acute services
- Experience in developing data solutions to support healthcare capacity and demand planning
- Demonstrable SQL proficiency with experience writing, troubleshooting and performance tuning complex SQL scripts and procedures, and in mentoring others in this area
- Experience in designing and developing data models from complex healthcare data sources and in applying industry standard and best practice methods to conform data for reporting services
- Experience in implementing and upgrading database systems including initiatives resulting from the redesign of patient care systems and procedures
Specific Skills
Essential
- Must be able to provide and receive highly complex, sensitive or contentious information, negotiate with senior stakeholders/customers on difficult and controversial issues, and present complex and sensitive information to large and influential groups/customers
- Problem solving skills and ability to respond to sudden unexpected demands
- Ability to communicate with clinical, academic and all levels of staff effectively
- Ability to make decisions autonomously, when required, on difficult issues, working to tight and often changing timescales
- Ability to identify risks, anticipate issues, create solutions and resolve problems in relation service delivery
- Ability to take a forward-looking and commercial view
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: 13 April 2025
