Job summary We are at a pivotal stage of our digital journey and have an ambitious portfolio of digital technology initiatives ahead of us, all grounded around - empowering patients and service users, improving the experience navigating the healthcare system and joining up systems and data across to better meet the needs of citizens. The data engineering service provides a central platform to support the Trust's data analytics, reporting and day-to-day operational service delivery and responsible for the end-to-end data engineering lifecycle. There are a number of different teams within IT Operations, aligned to specific user needs / services. Each team will have a number of different services that form the service offering to end users. Main duties of the job A senior data engineer designs and leads the implementation of data flows to connect operational systems, data for analytics and business intelligence (BI) systems. At this role level, you will: Write complex ETL (extract, transform, load) scripts and code and optimise to ensure processes perform optimally Recognise opportunities to reuse existing data flows Lead work on data engineering Lead the build of data flows / data streaming systems You will support all parts of our organisation, and be focused on one or more areas: Clinic and ward builds Master patient data Active referrals and referral to treatment (RTT) pathways Active outpatient appointments Active inpatient TCIs You will put people at the heart of everything you do - with a relentless focus on user experience and ensuring all our user needs are met across sites at Moorfields Eye Hospital NHS Foundation Trust. With the ever-increasing need and interest in the use of digital technology in healthcare, you will be part of a team of Digital, Data and Technology experts that delivers service improvements and keeps at the forefront of new technology. About us At Moorfields, we provide more than just an excellent career and great colleagues to work with. We also offer: Salary including High-Cost Area Supplement Opportunity to join the NHS Pension Scheme Free 24/7 independent counselling service Learning and development opportunities Easy and quick transport links A range of attractive benefits and discounts Access to Blue Light Card and other NHS Discount Schemes Free Pilates classes Full support and training to develop your skills Flexible working friendly organisation And so much more To see the full range of benefits we offer please see our Moorfields benefits document. Date posted 02 March 2025 Pay scheme Agenda for change Band Band 7 Salary £54,320 to £60,981 a year per annum Contract Permanent Working pattern Full-time Reference number 273-EPR-6991871 Job locations Moorfields Eye Hospital NHS Foundation Trust 162 City Road London EC1V 2PD Job description Job responsibilities Leadership Mentor and coach other members of the Data Engineering team, including supporting building long-term capability in the team. Champion quality across the Digital, Data and Technology teams. Communicating between the technical and non-technical Communicate effectively with technical and non-technical stakeholders. Support and host discussions within a multidisciplinary team, with potentially difficult dynamics. Be an advocate for the team externally and can manage differing perspectives. Continual service improvement You know how to analyse current processes, identify and implement opportunities to optimise processes, and lead and develop a team of experts to deliver service improvements. You help to evaluate and establish requirements for the implementation of changes through policy and standards. Data analysis and synthesis Undertake data profiling and source system analysis, including documenting complex source-to-target mappings. Present clear insights to colleagues to support the end use of the data. Facilitate and lead discussions on data accuracy with teams. Data development process Design, build and test data products that are complex or large scale. Build and contribute to teams to complete data integration services. Data innovation Understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage. Data integration design Produce relevant data models across multiple subject areas. Explain which models to use for which purpose and compare / align different models. Understand industry-recognised data modelling patterns and standards, and when to apply them. Select and implement the appropriate technologies to deliver resilient, scalable and future-proofed data solutions. Data modelling Produce relevant data models across multiple subject areas. Explain which models to use for which purpose and compare / align different models. Understand industry-recognised data modelling patterns and standards, and when to apply them. Data operations Ensure the data operational environment is maintained, and with appropriate monitoring and coverage, automating remediation action(s) where possible. Lead on regular preventative maintenance activities that are complex. Develop and maintain accurate data knowledge documentation. Partner with other enabling technology teams to ensure we provide a fit-for-purpose, performant data service to users. Financial management Understand how to balance cost versus value Consider the impact of user needs Ordering IT equipment / services for your team Governance Ensure our data engineering and operational practices consider secure by design principles, and clinical safety principles throughout the lifecycle partnering with supporting teams (information governance, information security, and clinical safety) to ensure successful outcomes. Metadata management Contribute to and update the metadata repository. Suggest changes to improve current metadata repositories. Understand a range of tools for storing and working with metadata. Advise less experienced members of the team about metadata management. Ownership and initiative You can take accountability of issues that occur and be proactive in searching for potential problems. You know how to achieve excellent user outcomes. Problem resolution (data) Respond to incidents and problems in databases, data processes, data products and services as they occur. Initiate actions, monitor services and identify trends to resolve problems. Determine the appropriate remedy and assist with its implementation, and with preventative measures. Programming and build (data engineering) Use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations. Collaborate with others to review specifications where appropriate. Ensure engineering is in-line with agreed standards, including strict version control. Lead the build of data flows / data streaming systems. Service focus You know how to see the bigger picture and can investigate how to get the best of underlying services. You will represent data engineering in service design and transition activities, to ensure a smooth transition of products from delivery into live service. Service reporting Responsible for ensuring that the service management platform and associated tooling is kept up to date with across your portfolio of services. Produce relevant reports in a standard format and agreed timeframe. Add a commentary that provides an interpretation of the data set. Technical understanding Understand the core technical concepts related to the role and apply them with guidance. Demonstrate knowledge of emerging tools and techniques. Technical breadth Have experience in more than one data engineering technology (SQL, Oracle, etc) Testing Review requirements and specifications and define test conditions. Identify issues and risks associated with work. Analyse and report test activities and results. Community of practice Develop and maintain a network of professionals to enable continuous learning and a community which can share, learn, and keep up to date on the broader technology and data landscape Other Duties: Occasional work may be required outside of core business hours to support major projects / programmes All other reasonable requests Job description Job responsibilities Leadership Mentor and coach other members of the Data Engineering team, including supporting building long-term capability in the team. Champion quality across the Digital, Data and Technology teams. Communicating between the technical and non-technical Communicate effectively with technical and non-technical stakeholders. Support and host discussions within a multidisciplinary team, with potentially difficult dynamics. Be an advocate for the team externally and can manage differing perspectives. Continual service improvement You know how to analyse current processes, identify and implement opportunities to optimise processes, and lead and develop a team of experts to deliver service improvements. You help to evaluate and establish requirements for the implementation of changes through policy and standards. Data analysis and synthesis Undertake data profiling and source system analysis, including documenting complex source-to-target mappings. Present clear insights to colleagues to support the end use of the data. Facilitate and lead discussions on data accuracy with teams. Data development process Design, build and test data products that are complex or large scale. Build and contribute to teams to complete data integration services. Data innovation Understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage. Data integration design Produce relevant data models across multiple subject areas. Explain which models to use for which purpose and compare / align different models. Understand industry-recognised data modelling patterns and standards, and when to apply them. Select and implement the appropriate technologies to deliver resilient, scalable and future-proofed data solutions. Data modelling Produce relevant data models across multiple subject areas. Explain which models to use for which purpose and compare / align different models. Understand industry-recognised data modelling patterns and standards, and when to apply them. Data operations Ensure the data operational environment is maintained, and with appropriate monitoring and coverage, automating remediation action(s) where possible. Lead on regular preventative maintenance activities that are complex. Develop and maintain accurate data knowledge documentation. Partner with other enabling technology teams to ensure we provide a fit-for-purpose, performant data service to users. Financial management Understand how to balance cost versus value Consider the impact of user needs Ordering IT equipment / services for your team Governance Ensure our data engineering and operational practices consider secure by design principles, and clinical safety principles throughout the lifecycle partnering with supporting teams (information governance, information security, and clinical safety) to ensure successful outcomes. Metadata management Contribute to and update the metadata repository. Suggest changes to improve current metadata repositories. Understand a range of tools for storing and working with metadata. Advise less experienced members of the team about metadata management. Ownership and initiative You can take accountability of issues that occur and be proactive in searching for potential problems. You know how to achieve excellent user outcomes. Problem resolution (data) Respond to incidents and problems in databases, data processes, data products and services as they occur. Initiate actions, monitor services and identify trends to resolve problems. Determine the appropriate remedy and assist with its implementation, and with preventative measures. Programming and build (data engineering) Use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations. Collaborate with others to review specifications where appropriate. Ensure engineering is in-line with agreed standards, including strict version control. Lead the build of data flows / data streaming systems. Service focus You know how to see the bigger picture and can investigate how to get the best of underlying services. You will represent data engineering in service design and transition activities, to ensure a smooth transition of products from delivery into live service. Service reporting Responsible for ensuring that the service management platform and associated tooling is kept up to date with across your portfolio of services. Produce relevant reports in a standard format and agreed timeframe. Add a commentary that provides an interpretation of the data set. Technical understanding Understand the core technical concepts related to the role and apply them with guidance. Demonstrate knowledge of emerging tools and techniques. Technical breadth Have experience in more than one data engineering technology (SQL, Oracle, etc) Testing Review requirements and specifications and define test conditions. Identify issues and risks associated with work. Analyse and report test activities and results. Community of practice Develop and maintain a network of professionals to enable continuous learning and a community which can share, learn, and keep up to date on the broader technology and data landscape Other Duties: Occasional work may be required outside of core business hours to support major projects / programmes All other reasonable requests Person Specification Education and qualifications Essential Degree, or equivalent relevant level of experience with additional specialist knowledge Relevant technical / data qualification, or equivalent experience Desirable Relevant management / leadership qualification, or equivalent experience to degree level Service management qualification or equivalent experience (example: ITIL) Delivery management qualification or equivalent experience (Agile, PRINCE2, etc) Experience Essential Experience in the role of a data engineer / data warehouse engineer, or equivalent role Experience championing data to drive successful and improved outcomes Experience designing, developing and operating multiple data / data warehouse technologies (SQL, Oracle, etc), or similar datasets and supporting technologies (SSRS, SSIS, etc) Experience of supporting the transition of data products from Delivery into Live Service - including service transition and assurance activities Desirable Mentoring and coaching others Management of financial budgets for a team (pay, on-call, consumables) Experience of management data products / services in healthcare (NHS) Skills and knowledge Essential Systematic and methodical approach to problem solving Prioritisation of work - within the team Meet set targets or metrics Autonomous working and can delegate appropriately Good communication skills - tailoring your message for audience, providing and receiving highly complex, sensitive and/or contentious information, able to communicate technical information in a simple way to stakeholders Proficient technical skills on more than one data / data warehouse technology Strong domain knowledge and ability to keep ahead of technology and data initiatives. Personal qualities Essential Relentless focus on user needs and experience Problem-solving mindset - focusing on improving outcomes Seeing the bigger picture - understand how your work and the work of your team supports wider objectives and meets the diverse needs of stakeholders Able to work well within a busy environment Person Specification Education and qualifications Essential Degree, or equivalent relevant level of experience with additional specialist knowledge Relevant technical / data qualification, or equivalent experience Desirable Relevant management / leadership qualification, or equivalent experience to degree level Service management qualification or equivalent experience (example: ITIL) Delivery management qualification or equivalent experience (Agile, PRINCE2, etc) Experience Essential Experience in the role of a data engineer / data warehouse engineer, or equivalent role Experience championing data to drive successful and improved outcomes Experience designing, developing and operating multiple data / data warehouse technologies (SQL, Oracle, etc), or similar datasets and supporting technologies (SSRS, SSIS, etc) Experience of supporting the transition of data products from Delivery into Live Service - including service transition and assurance activities Desirable Mentoring and coaching others Management of financial budgets for a team (pay, on-call, consumables) Experience of management data products / services in healthcare (NHS) Skills and knowledge Essential Systematic and methodical approach to problem solving Prioritisation of work - within the team Meet set targets or metrics Autonomous working and can delegate appropriately Good communication skills - tailoring your message for audience, providing and receiving highly complex, sensitive and/or contentious information, able to communicate technical information in a simple way to stakeholders Proficient technical skills on more than one data / data warehouse technology Strong domain knowledge and ability to keep ahead of technology and data initiatives. Personal qualities Essential Relentless focus on user needs and experience Problem-solving mindset - focusing on improving outcomes Seeing the bigger picture - understand how your work and the work of your team supports wider objectives and meets the diverse needs of stakeholders Able to work well within a busy environment 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 Moorfields Eye Hospital NHS Foundation Trust Address Moorfields Eye Hospital NHS Foundation Trust 162 City Road London EC1V 2PD Employer's website https://www.moorfields.nhs.uk/work-for-us (Opens in a new tab)