Senior Business Intelligence Developer

Senior Business Intelligence Developer

Closing date: 29 June 2026.

This vacancy is currently only open to Herefordshire and Worcestershire NHS staff (including PCN/GP Practices).

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 informatics 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 Trust's 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 Trust's 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.

Job responsibilities

• Provide ongoing support to the information team for all aspects related to SQL Server data management, ETL and BI processes.
• Develop, maintain, document and enhance all ETL processes related to patient data and associated systems, with a focus on efficient T SQL development and optimisation.
• Contribute to, and assist in, the development and implementation of the departmental strategy for business intelligence, data modelling and reporting.
• Line manage junior team members and be responsible for their training and progression.
• Act as a mentor for junior team members 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 and solution documentation.
• Develop applications and solutions using rapid agile methods with a focus on delivering agreed shippable components to the end user and subsequent iterations to acceptance, including data driven and semantic layer solutions.
• Conduct full technical testing of developed solutions at 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.
• Develop pro active monitoring and event management procedures to ensure continuous and reliable information systems availability, including database and data pipeline monitoring.
• Keep up to date with 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.

Person Specification - Experience

• Demonstrable substantial experience of writing and optimising complex T SQL in SQL Server environments.
• Strong experience working with SQL Server databases, including performance tuning and query optimisation.
• Proven experience designing and developing data models, particularly Tabular Models / Semantic Models.
• Experience working with data warehousing concepts and techniques.
• Experience with the full software development lifecycle or related methodologies.
• Experience working with large, complex datasets.
• Knowledge of NHS datasets.

Person Specification - Qualifications

• Degree level qualification in IT/Informatics or related discipline, or equivalent experience (minimum 4 years in a similar role).

Internal NHS Job Vacancy

This vacancy is currently only open to Herefordshire and Worcestershire NHS staff (including PCN/GP Practices). Please confirm the NHS organisation you currently work for.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and a submission for Disclosure will be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer name

Worcestershire Acute Hospitals NHS Trust