Senior Business Intelligence Developer

Job summary

This vacancy is currently only open to internal applicants from Worcestershire Acute Hospitals NHS Trust.

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.

Job responsibilities

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.