Senior Business Intelligence Developer
Job summary
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 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.
Job description
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.
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 of the full software development lifecycle or related methodologies
- Experience working with large, complex datasets
- Knowledge of NHS datasets
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 below which NHS organisation in Herefordshire and Worcestershire you currently work for.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Employer details
Employer name
Worcestershire Acute Hospitals NHS Trust
Address
Charles Hastings Way
Worcester
Worcestershire
WR5 1DD
United Kingdom
Employer's website
https://www.worcsacute.nhs.uk/