Job Summary
The post holder will focus on data engineering-led transformation and development work required to support delivery of the Trust’s Healthier Futures programme for the new digital hospital. This includes developing and maintaining high quality, reliable and scalable data solutions to support population health management, service transformation and improved patient outcomes. The role will ensure data from multiple clinical and operational systems is effectively integrated, modelled and made available to support insight-driven decision making.
Working within the Data Warehouse team, the post holder will design, build and optimise robust data pipelines, data models and reporting foundations, initially within the Trust’s current SQL-based data warehouse environment, while supporting the transition towards a more modern, scalable data platform, including use of SQL and established data warehousing tools, and evolving cloud-based data engineering approaches over time.
They will take lead responsibility for one or more key data domains aligned to Healthier Futures priorities, acting as a subject matter expert in data engineering, performance optimisation and data quality. The post holder will work closely with analysts, clinicians and operational leads to deliver well-governed, trusted data products aligned to agreed data architecture standards, while supporting best practice and continuous improvement across the team.
Main duties of the job
Design, build and optimise data models and ETL/data pipelines using expert T-SQL skills, ensuring pipelines are performant, scalable and resilient.
Optimise queries and ETL performance through indexing, partitioning and other SQL Server tuning techniques, and use a metadata-driven ETL framework to automate and standardise data flows.
Validate ETL processes after system upgrades to ensure data continuity and integrity, maintaining test suites and validation scripts.
Design and maintain dimensional models (star/snowflake schemas) to support efficient and reusable analytics, and perform data profiling to identify data quality issues, anomalies and lineage.
Liaise with service users and BI teams to understand reporting requirements and translate them into data models and data solutions.
Support advanced analytics by preparing high-quality datasets and enabling analytical workflows where appropriate.
Promote and support automation (e.g. CI/CD pipelines), APIs and modern data platform techniques, and contribute to DevOps practices including version control and release management.
Assist with DBA-related activities such as backup and recovery, index and statistics maintenance, capacity planning, and participate in patching and upgrades of SQL Server instances.
Person Specification
Education/Qualifications
Essential
- Masters degree in relevant subject (Data science, computing, Mathematics, Health Informatics) or equivalent experience
- Evidence of continuing development in data and analytics
Desirable
- Relevant Microsoft accreditation (Data Engineering, SQL Server, Azure Cloud Certification)
- Formal qualification in Health Informatics / Business Intelligence.
Previous Experience
Essential
- Significant hands-on experience in data engineering / data warehouse development, ideally in a healthcare or complex environment.
- Experience working with a metadata-driven ETL framework.
- Experience designing and maintaining dimensional data models (star/snowflake schemas).
- Experience validating ETL processes, particularly during source system upgrades or changes.
- Experience scheduling and managing SQL Server Agent jobs.
- Basic-to-moderate DBA experience (backup/restore, indexing, statistics, capacity planning).
- Experience mentoring or supporting more junior data engineers or developers.
Desirable
- Experience in high-availability or large-scale SQL Server environments.
- Experience of Python
- Experience with large, complex healthcare datasets.
- Experience of mentoring or coaching junior staff.
- Experience in responding to production issues and out-of-hours incidents.
Skills/Knowledge
Essential
- Expert T-SQL and SQL Server skills, including query optimisation and performance tuning.
- Strong data profiling, analysis, and data quality skills.
- Strong knowledge of dimensional modelling, and reporting layer design.
- Awareness of Agile methods (Scrum, DevOps).
- Understanding of SDLC, version control, peer review, documentation, and change management.
- Ability to design and run tests to ensure data quality and accuracy
- Strong problem-solving skills; able to triage and resolve complex data issues.
Desirable
- Familiarity with NHS data systems and governance (e.g. NHS data standards, data security, NHS IG).
- Awareness of MS Azure Cloud tools, such as Azure DevOps, Data Factory, Fabric and Azure Databricks
- Knowledge of clinical systems relevant to work area (Meditech, EMIS)
- Knowledge of APIs and integrating data via API-based ingestion.
- Knowledge of HL7 standards.
- Awareness of modern data architecture approaches such Data Lakehouse, streaming data, unstructured data management.
Additional Information
Essential
- Willingness to work occasional out-of-hours as part of rota for monitoring data warehouse processes.
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: 19 May 2026
