Senior Business Intelligence Developer

Job summary

Join Worcestershire Acute Hospitals NHS Trust as a Senior Business Intelligence Developer and play a key role in shaping the future of healthcare analytics and data-driven decision making across the Trust. This is an exciting opportunity for an experienced SQL and BI professional to work within a highly skilled Information and BI Development team, delivering innovative solutions that directly support patient care, operational performance and strategic planning.

You will lead on the development and optimisation of SQL Server data warehouse solutions, advanced ETL processes, semantic/tabular data models and modern reporting platforms including Power BI. Working with large and complex healthcare datasets, you will collaborate closely with informatic and operational stakeholders to turn data into meaningful insight that improves services across the organisation.

We are looking for someone with strong technical expertise in SQL Server, T-SQL and BI technologies, alongside good mentoring skills to influence best practice and contribute to the Trusts long-term BI strategy. In return, you will have the opportunity to work on impactful projects, develop your technical skills and help drive innovation within a forward-thinking NHS organisation committed to continuous improvement and digital transformation.

Main duties of the job

As a Senior Business Intelligence Developer, you will support the delivery of high-quality business intelligence solutions that enable informed decision making across the Trust. You will work closely with technical and non-technical stakeholders to understand complex reporting and analytical requirements, translating these into reliable and scalable data solutions.

The role involves developing and enhancing data warehouse processes, improving data quality and system performance, and designing the underlying data structures that support reporting and analytics across the organisation. This includes developing and maintaining robust fact and dimension models, semantic layers and ETL processes to ensure data is accurate, accessible and fit for analytical use.

You will contribute to the ongoing development of the Trusts BI and analytics capabilities by identifying opportunities to improve existing processes, supporting the adoption of best practice development standards, and helping to ensure the reliability and integrity of complex healthcare data. The post offers the opportunity to work on a wide range of projects using modern Microsoft BI technologies within a collaborative and forward-thinking NHS environment.

About us

Worcestershire Acute Hospitals NHS Trust is a large acute and specialised hospital trust that provides a range of local acute services to the residents of Worcestershire and more specialised services to a larger population in Herefordshire and beyond.

The Trust operates hospital-based services from three sites in Kidderminster, Redditch and Worcester

Our workforce is more than 7,000 strong, and our caring staff are recognised as providing good and outstanding patient-centred care. You could be one of them.

We are committed to recruiting the best people to work with us. Our values, which we ask all staff to demonstrate, underpin our everyday work and remain firmly at the heart of all we do.

Being open and honest

Ensuring people feel cared for

Showing respect to everyone

We are committed to developing a culture of continuous improvement by embedding the principles of our Improvement System.

We are proud to have achieved Timewise accreditation - this means we are committed to embedding flexible working within our organisation as a flex positive employer.

DBS Checks and Costs

Any applicants who are offered posts requiring a DBS check as part of their employment check will have the cost of this check (at the current rate) deducted from their salary. Please see link in Supporting Information section for more details on DBS checks and costs.

Details

• Date posted: 20 July 2026
• Pay scheme: Agenda for change
• Band: Band 7
• Salary: £49,387 to £56,515 a year
• Contract: Permanent
• Working pattern: Full-time, Flexible working
• Reference number: C9365-26-0393-S3
• Job locations: Charles Hastings Way, Worcester, Worcestershire, WR5 1DD, United Kingdom

Job responsibilities

Key Duties

• Provide ongoing support to the information team for all aspects relating to SQL Server data management, ETL and BI processes.
• Develop, maintain, document and enhance all ETL processes relating to patient data and associated systems, with a focus on efficient T-SQL development and optimisation.
• Contribute to, and assist in, the development and subsequent implementation of the departmental strategy for business intelligence, data modelling (including tabular/semantic models) and reporting.
• To line manage junior members of the team and to be responsible for their training and progression within their roles.
• To act as a mentor for junior team members as required, particularly in SQL development and data modelling best practice.
• Develop, map and document critical business and technical processes, including data models and data flows.
• Contribute to the development of internal best practice development methodologies, SQL coding standards, solution documentation and standards.
• Develop applications and solutions using rapid agile methods with focus to deliver agreed shippable components to the end user and subsequent iteration to acceptance, including data-driven and semantic layer solutions.
• Conduct full technical testing of developed solutions at a unit and system level, including validation of data models and query performance, with appropriate scaling, platform, capacity and load testing.
• Ensure that adequate security and data protection protocols are incorporated into solution designs as per Trust IG principles.
• Provide technical expert capability to pro-actively resolve issues and assist with support and development issues as required, using high levels of SQL Server and data modelling expertise.
• Develop pro-active monitoring and event management procedures to ensure continuous and reliable information systems availability, including database and data pipeline monitoring.
• To keep up to date, and have an awareness of, new developments within the NHS, with a particular focus on data, BI, and analytics technologies (e.g. semantic models and visualisation tools such as Power BI).
• Assist in other software and data development projects as carried out by the team.