Data Engineer

Talantir; Bath; On-site; GBP 42,000 - 64,000; Full time

Job summary

Royal United Hospitals Bath NHS Foundation Trust is seeking a Data Engineer for the Business Intelligence & Data Services team to shape data-driven decision-making across the Trust. You will develop the data warehouse, ETL processes, and reporting strategies across clinical and operational data.

You will collaborate with clinicians, divisional managers and IT colleagues to ensure high-quality datasets, deliver dashboards, and support statutory reporting.

Qualifications

• Relevant qualification (HND or higher) in Computing or Information Technology.
• Experience with SQL Server, Visual Basic, DTS, VB.NET and .NET framework.
• Able to develop reports to support performance data.

Responsibilities

• Develop and maintain the local data warehouse and reporting systems.
• Keep warehouse documentation up to date.
• Provide training and support to users of the reporting application.
• Ensure timely, relevant information for decision-making across the Trust.

Skills

Problem solving

Training users

Data extraction

Reporting

Communication

Education

HND or higher in Computing/IT

Tools

SQL Server

Visual Basic

DTS

VB.NET

NET framework

Job description

Job Overview

Data Engineer – Business Intelligence & Data Services

Are you passionate about turning data into meaningful insights that improve patient care? We’re looking for a talented and motivated Data Engineer to join our Business Intelligence & Information Services team, helping shape the future of data‑driven decision‑making across the Trust.

What You’ll Be Doing

Developing and improving the Trust’s data warehouse, reporting environment, and ETL processesManaging routine and bespoke data extractions from clinical and operational IT systemsLeading on the Trust’s reporting strategy, including exploring modern web‑based reporting tools and data collection solutionsEnsuring high‑quality, reliable datasets that support operational performance, clinical services and statutory reportingWorking closely with colleagues in the BI & Information Services Development Team, as well as Divisional Managers, senior leaders and cliniciansCollaborating with partners across the wider health system, including local ICBs/CCGs

This role offers significant scope for autonomy and innovation—you’ll be the specialist driving improvements in how the Trust uses data, with opportunities to shape new approaches and introduce new technologies.

If you’re curious, solutions‑focused and keen to use your technical skills to make a real impact in the NHS, we’d love to hear from you.

Main duties of the job

• Develop and maintain the Trust’s local data warehouse and reporting systems, working collaboratively with the Information Services Development team. This includes designing and maintaining data structures, managing data from PAS and other sources, and ensuring robust extraction, storage, and backup processes.
• Keep documentation accurate and up to date, including warehouse design specifications and reporting requirements, in line with Information Services quality standards.
• Provide specialist training and support to users of the performance reporting application, offering guidance on best practice, policies, and procedures.
• Ensure timely, relevant and accurate information is available to support effective decision‑making across the Trust and with external partners.
• Create and monitor data quality reports to highlight process issues, escalating concerns to operational managers so that corrective actions can be taken.
• Monitor Dataset Change Notices (DSCNs), advising on their impact and implementing required changes to maintain compliance within the warehouse and reporting outputs.
• Work proactively with teams across the Trust to identify reporting requirements and system enhancements, supporting the successful implementation of changes in reporting definitions or processes.
• Collaborate with IT Development and Information colleagues to improve data quality, raising awareness and embedding best practices across the organisation.

Working for our organisation

At the RUH we put people at the heart of what we do, working together as one team to make a difference for our patients, each other, and our community. No matter what your role is, we value everyone’s contribution in supporting the exceptional, person-centred care we pride ourselves on.

We are proud to be in the top 20 best hospitals to work for in the country.

We are committed to creating a compassionate and inclusive environment. This can be seen in our growing community of staff networks – celebrating successes and creating opportunities to listen and learn. We value our differences, champion kindness and civility, and truly believe that diversity makes us stronger.

A culture of learning, developing and innovating is the thread that runs throughout our whole organisation. We want to support you to thrive, taking your career to its full potential.

We value staff wellbeing, with a well‑established programme of support. We believe in a holistic approach spanning all aspects of living a healthy life, including physical, emotional, spiritual and financial wellbeing. We’ve even got a pool!

We are committed to supporting you and hope you want to join our team. In the meantime, find out more about living and working the beautiful historic city of Bath, learn about our extensive package of staff benefits, and read about how we’re providing healthcare fit for the future with the landmark Dyson Cancer Centre and our passion for research.

Person specification

Technical

Essential criteria

• Relevant qualification (HND or higher) in Computing or Information Technology
• Relevant experience and training in SQL Server, Visual Basic, DTS (Broadly equivalent to a Masters)
• At least four years experience developing and implementing client / server applications
• Good problem solving skills including resolution of issues and program faults
• Ability to develop reports to support performance data and provide meaningful and credible information
• Experience of training users in the use of applications.
• Experience of health and/or social services information systems
• At least four years knowledge of SQL Server up to version 2000 including Stored Procedures, Data Transformation Services and Query Analyser
• At least four years knowledge of Visual Basic, including some experience of VB.NET and understanding of the .NET framework

Desirable criteria

• Good knowledge of the following: systems analysis, design and testing
• Knowledge of RUH information and reporting systems (TDS/CFIS, Cerner Millennium, Business Objects).
• Previous experience of production of DoH Reporting Requirements
• Knowledge of ASP and / or ASP.NET.
• Experience of developing browser-based applications using tolls such as PHP, C#.
• Knowledge of business intelligence reporting tools such as Power BI, SQL Server 2005

Other

Essential criteria

• Experience of working to tight deadlines
• Effective and flexible team member
• Good problem solving skills including resolution of issues and program faults
• Effective communication with users. The ability to interpret non-technical language and convert requirements into technical specifications
• Ability to work on own initiative within guidelines
• Ability to work calmly under pressure and check own work in an objective manner
• Effective prioritisation and time management skills
• Attention to detail, prepared to work methodically through mundane tasks

Desirable criteria

• Operational health service experience
• Understanding of patient pathways and how clinical services are organised
• Excellent formal and informal presentation skills

Please note - Due to recent changes in UK immigration and visa rules applicants who do not currently have the right to work in the UK may not be considered unless an alternative right to work solution can be provided. Candidates requiring sponsorship (or will need sponsorship at the end of a current visa e.g. those with graduate visa's) should review the eligibility criteria on the gov.uk website before applying: Prove your right to work to an employer: Overview - GOV.UK

Documents to download

• Job Description and Person Specification Data Science (PDF, 200.4KB)
• Join the RUH (PDF, 1.1MB)

Further details / informal visits contact

Name Charlie Gale Job title Interim Associate Director of Data and Insight Email address [e-mail]