Care Coordination Solution Data Support Engineer

We have vacancies in the following sectors

If you want to be part delivering world class eye health services and you share our values: excellence, equity, and kindness, then we would love to hear from you!

Care Coordination Solution Data Support Engineer

Band 7

Main area Senior Data Engineer Grade Band 7 Contract 6 months (Fixed Term) Hours Full time - 37.5 hours per week Job ref 273-DC-7082470-A

Site Moorfields Eye Hospital NHS Foundation Trust Town London Salary £54,320 - £60,981 Per Annum, Inclusive of HCAS Salary period Yearly Closing 09/04/2025 23:59

Moorfields - A global leader in Ophthalmology

We are Moorfields Eye Hospital NHS Foundation Trust. Founded in 1804, Moorfields Eye Hospital is a world-class centre of excellence for eye health services, ophthalmic research, and education.

With more than 2,300 staff we are proud to be supported by one of the most diverse workforces in the NHS. Every year we treat more than 700,000 patients at City Road in central London and at our 22 satellites sites, and, in partnership with the UCL Institute of Ophthalmology and Moorfields Biomedical Research Centre we lead one of the most impactful ophthalmic research programmes in the world.

This is an exciting time to join Moorfields. The pandemic fast-tracked a huge amount of innovation which is changing the way we work and deliver care. Construction is under way on Oriel, our new eye care, research, and education centre being built in Camden. The new centre will be flexible and modern, enabling us to bring together healthcare, eye research and education under one roof for the first time.

Job overview

The Care Coordination Solution (CCS) is a module designed as part of the development of the Federated Data Platform. The Inpatient and Referral To Treatment (RTT) elements of that module are being implemented into the trust as part of a workstream designed to improve patient flow and patient experience.

This is part of our vision is to create a digitally enabled organisation that supports the delivery of efficient and effective patient care. We aim to achieve this through easy-to-use systems that provide staff and patients with access to the right information, in the right place, at the right time. To help us to achieve this vision, we are looking for passionate individuals to join our team.

Patients are at the centre of everything we do. Our integrated CCS will help us to ensure that we continue to improve our delivery of services and treatment plans around patient needs. The EPR is designed to wrap around our specialist ophthalmology clinical noting system, OpenEyes, to provide a seamlessly integrated patient record system.

Main duties of the job

This particular post will sit across the Data Warehouse and Information teams of the Performance & Information department and will work closely with the System Supplier (Palantir), CCS Implementation Team, IT Systems owners, developers and users to ensure appropriate development of the data warehousing element of the CCS implementation project.

1. Build the appropriate data tables, in an SQL environment, to capture the data required for the successful operation of the Care Coordination System. All scripting should be structured and clearly commented, to ensure scalability and transferability for potential future development.
2. Ensure regular refreshes of the data tables as a minimum daily working towards an hourly data refresh using near live data.
3. Be instrumental in the development of the methodology for data transfer to the new system i.e. which data can be automated, and which must be manually entered.
4. Ensure a full specification for the data warehouse element of the CCS project is developed and approved by the project team and Palantir.
5. Ensure full documentation of the table development and ensure that this is regularly updated to capture any version changes or new requirements.
6. Ensure that all stakeholders are aware of the data curation and the supply methodologies.
7. Ensure that data quality metrics are available and liaise with the trusts data quality team regarding required improvements.

Working for our organisation

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.

Detailed job description and main responsibilities

1. Liaise with a range of stakeholders to ensure that the data laid out in the requirements are fit for purpose.
2. Ensure liaison with the trusts Information team to ensure that data flows and data usage are documented and understood.
3. Report regularly to the CCS Project Board to update on progress of development.
4. Ensure that the table completion and data-flow are sustainable without recourse to additional staffing resources.
5. Ensure that all work is compatible with a potential relocation of the current data warehouse into a Cloud environment.
6. To ensure liaison with other trust project with a view to identifying synergies or duplications of effort.
7. Represent the trust with external partners and suppliers to ensure that all issues are dealt with professionally.

Person specification

Education / Qualifications

• A Masters’ degree in a data technology related discipline or equivalent relevant experience.
• Expert status in the use MS-SQL, SSRS and Data Warehouse functions.
• Registered with a relevant informatics professional body

Experience

• Significant experience in similar environment or system
• Extensive familiarity with complex computerised data warehouse structures.
• Experience of designing, coding, testing and implementation of efficient and robust database schemas.
• Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.
• Experience of supporting the transition of products from Delivery into Live Service

Knowledge

• Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
• Expert knowledge of the NHS Data requirements, Information Standards and data flows gained through at least 2 years in an NHS data warehousing role.
• Proven ability to lead, influence and motivate with project / resource planning experience.

Skills & ability

• A logical and analytical approach to problem solving demonstrated in an Information Systems environment.
• Independent self-starter, able to work with a high level of autonomy.
• Strong drive for accuracy, performance, and improvement. With the ability to remain flexible and have a resilient approach, able to work under pressure.
• Ability to make decisions autonomously, when required, on difficult issues.
• Excellent Business Analysis skills: able to produce metrics, analyse and interpret information and produce regular reports.
• Ability to make and communicate decisions on difficult issues where there may be several courses of action responding openly to questions to ensure full understanding and engagement.
• Excellent written and verbal communication skills suitable for a range of audiences.
• Proven track record of identifying and solving data quality issues arising from aligning data sources and data targets.

Due to the nature of this position, employment is subject to proof of eligibility to work in the UK, completion of a satisfactory DBS disclosure and two references. We do not offer visa sponsorship for roles unless clearly stated in our adverts, so please consider this before applying.

Our commitment to equality, diversity and inclusion is at the heart of our organisational culture. As part of our pledge to take positive action in recruitment we encourage applications from under-represented candidates including BAME (Black, Asian, and Minority Ethnic) and Disabled candidates as we work towards a representative workforce that is able to provide the quality, the dignity and respect and to deliver above and beyond.

Moorfields is a flexible working friendly organisation, and we are committed to helping our employees achieve a work-life balance that is beneficial for health and wellbeing, motivation levels and job satisfaction. Every employee of the Trust has the right to request to work flexibly. Please speak to us about how we might be able to accommodate a flexible working arrangement. If it works for the service, we will do our best to make it work for you.

If we receive sufficient applications, we will close this ad prior to the closing date. You are advised not to delay submitting your completed application.

If you would like to discuss any reasonable adjustments before applying or would like an accessible version of any recruitment documents, please contact the recruitment team at moorfields.recruitment@nhs.net.

https://www.moorfields.nhs.uk/work-for-us

Employer certification / accreditation badges

The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.

Name Tina Haigh Job title Digital and Transformation Programme Manager Email address tina.haigh@nhs.net