Job Overview

The Data Warehouse Developer is a key member of the Digital Data & Technology (DDaT) Development team, adding value for our patients through improving and developing information services across the Trust and the wider health and care system. You will ensure the data is an effective component of the Trust’s Digital Data & Technology target operating model, working alongside others to deliver continuous overall improvement. This role is part of supporting the ‘engine room’ of DDaT operations, transitioning from outsourced arrangements to an in-house delivery model. The post holder will be responsible for the maintenance and development of the Data Warehouse and BI architecture, including performance, maintainability and scalability, in a secure, governed and well‑architected data infrastructure.

Key Responsibilities

• Microsoft SQL Server (T‑SQL, SSIS, SSRS, SSAS)
• Data Warehousing Architectures
• Microsoft Power BI
• Tableau
• Exasol
• Bedrock Platform
• Microsoft Azure – deputise for the Data Warehouse Lead, supporting and maintaining the data warehouse and related systems.
• Provide specialist technical support for a range of database applications, ensuring stability, performance and timely resolution of user queries.
• Contribute to the design and development of the data warehouse architecture, including new data marts, ETL processes and database structures; lead implementation with a focus on scalability, performance and security.
• Manage complex ETL (Extract, Transform, Load) processes, ensuring accurate integration of multiple datasets from various sources and automating them where possible using SSIS.

Person Specification

Qualifications

• Essential: Educated to degree level or equivalent.
• Desirable: Degree in a relevant field – computer science, coding.

Experience

• Essential: Demonstrable experience of the maintenance and development of the data warehouse and BI architecture, including performance, maintainability and scalability.
• Desirable: Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.

Benefits

• Flexible working opportunities and strong emphasis on work‑life balance
• Annual leave – 27 days for new starters, increasing to 29 days after 5 years and 33 days after 10 years NHS service (pro‑rated for part‑time staff)
• NHS pension scheme
• Employee Assistance Programme
• Money Advice Service
• Generous maternity, paternity and adoption leave for eligible staff
• On‑site nursery (based at RBH)
• Full educational library services
• Cycle to work scheme, lockable storage for cycles
• Bus to work scheme
• Excellent rail and bus links
• A wide range of health‑service discounts at numerous brands.

How to Apply

Applications will be considered from all candidates, including those requiring sponsorship. Reviewed for sponsorship eligibility on the government website. Please note the posting will close on 02/12/2025 23:59.

For assistance with your application, contact the recruitment team on 0118 322 6997 or 0118 322 5342.

Diversity and Equality

We are committed to equal opportunities and welcome applications from all sections of the community, regardless of any protected characteristics. Reasonable adjustments will be made for disabled applicants where possible. All applicants who have a disability and meet the minimum criteria can opt for a guaranteed interview.

Salary

£47,810 – £54,710 per annum (Yearly)