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. If you are passionate about healthcare data and want to contribute to a major transformation project, we encourage you to apply Main duties of the job o Collaborate with Information Team Leads to understand service needs and translate them into data solutionso Develop and execute a comprehensive data infrastructure migration strategy for migration and decommissioning of legacy infrastructureo Develop a detailed data migration and infrastructure set-up roadmap and workplans with milestones, timelines, and resource allocationo Allocate resources effectively to meet project milestones and resolve project-related challengeso Identify and test methods for robust, scalable, and efficient cross organisation data transfero Provide hands-on technical guidance to EPR reporting workstream leadso Develop and test disaster recovery plans in the new environmento Lead the adoption of new tools and frameworks to improve team efficiency and system performanceo Implement processes to monitor, troubleshoot, and improve data workflows in the new infrastructureo Catalogue non epic existing data sources currently warehousedo Set-up and configure the TSD new data warehouse environment including networking, security, and access controlso Establish policies for data security, compliance, and governanceo Define roles and responsibilities for data access and usageo Map and migrate database schemas (tables, views, indexes) to the target environmento Adjust for platform-specific differences (e.g., SQL syntax, data types)o Validate and transform data during migration to match new system requirements About us Why Work With Us The data and information service plays a vital role in creating business intelligence products that support the needs of clinicians and patients. This involves collaborating with stakeholders to capture requirements, drafting detailed work specifications, and developing efficient data extraction processes. The service ensures the accuracy and reliability of insights by rigorously testing and refining outputs to enable the release of high-quality reports and dashboards. The service developed reporting tools and data services should empower healthcare professionals with actionable insights, enabling informed decision-making and improved patient care Joining the Information Team offers an exciting opportunity to make a meaningful impact on healthcare delivery and patient outcomes. Date posted 28 March 2025 Pay scheme Agenda for change Band Band 8a Salary £53,755 to £60,504 a year per annum Contract Fixed term Duration 15 months Working pattern Full-time, Flexible working, Home or remote working Reference number 388-7075526-EPR Job locations Regent House Regent Close Torquay TQ2 7AN Job description Job responsibilities Effectively translate highly technical aspects of the of the EPR Clarity and Caboodle architecture design into understandable concepts and language for other members of the Data Engineering, Information Teams and programme teams Invest time in understanding stakeholders data needs, ensuring the service balances appropriate levels of processed and conformed data for reporting and insights. Actively participate in relevant internal and external working groups, projects, services, and initiatives to provide expert technical data infrastructure and processing advice Maintain regular communication with Epic implementation staff to align on migration and testing plans, ensuring clarity and mutual understanding. Develop expert-level knowledge of the new BI environment to support analyst teams in troubleshooting issues. Address and resolve queries from analysts regarding BI services and functionality. Ensure that the new BI service offerings adhere to best practices and align with relevant legal and regulatory frameworks. Evaluate and design solutions that optimise operational efficiency and data usability. Take accountability for developing and owning the implementation strategy, ensuring alignment with organisational goals. Collaborate with the Information team to incorporate the implementation strategy into service planning and delivery. Develop and manage detailed plans for service delivery, identifying interdependencies, managing risks, allocating resources, and building contingencies as required. Ensure plans are robust, actionable, and adaptable to changing needs. Job description Job responsibilities Effectively translate highly technical aspects of the of the EPR Clarity and Caboodle architecture design into understandable concepts and language for other members of the Data Engineering, Information Teams and programme teams Invest time in understanding stakeholders data needs, ensuring the service balances appropriate levels of processed and conformed data for reporting and insights. Actively participate in relevant internal and external working groups, projects, services, and initiatives to provide expert technical data infrastructure and processing advice Maintain regular communication with Epic implementation staff to align on migration and testing plans, ensuring clarity and mutual understanding. Develop expert-level knowledge of the new BI environment to support analyst teams in troubleshooting issues. Address and resolve queries from analysts regarding BI services and functionality. Ensure that the new BI service offerings adhere to best practices and align with relevant legal and regulatory frameworks. Evaluate and design solutions that optimise operational efficiency and data usability. Take accountability for developing and owning the implementation strategy, ensuring alignment with organisational goals. Collaborate with the Information team to incorporate the implementation strategy into service planning and delivery. Develop and manage detailed plans for service delivery, identifying interdependencies, managing risks, allocating resources, and building contingencies as required. Ensure plans are robust, actionable, and adaptable to changing needs. 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 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. Certificate of Sponsorship 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). Additional information 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. Certificate of Sponsorship 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). Employer details Employer name Torbay and South Devon NHS Foundation Trust Address Regent House Regent Close Torquay TQ2 7AN Employer's website https://www.torbayandsouthdevon.nhs.uk (Opens in a new tab)