Business Intelligence Developer

Job overview

We are looking for a skilled and motivated Business Intelligence Developer to join our Performance & Information Team, helping to transform data into meaningful insights that support high-quality patient care and informed decision-making across the Trust.

Working as part of an innovative Business Intelligence function, you will design, develop and maintain modern reporting solutions, data warehouses, ETL processes and interactive dashboards using Microsoft SQL Server, SSIS, Power BI and related technologies. You will work closely with colleagues across Digital, Performance and operational services to deliver reliable, automated and high-quality information that enables self-service reporting and supports the Trust's strategic objectives.

This is an excellent opportunity for an experienced developer who enjoys solving complex data challenges, improving data quality and contributing to the continued evolution of the Trust's Business Intelligence platform.

Main duties of the job

As a Business Intelligence Developer, you will be responsible for designing, developing and supporting robust Business Intelligence solutions that provide accurate, timely and meaningful information to clinical and corporate services across the Trust.

You will develop and maintain data warehouses, ETL processes, databases, reports and interactive Power BI dashboards, ensuring that solutions are reliable, well documented, secure and thoroughly tested before release. Working closely with colleagues across Information, Digital and operational teams, you will integrate data from multiple systems, develop dimensional data models and help deliver automated reporting solutions that promote self-service and reduce manual effort.

The role also includes supporting the ongoing development of the Trust's Business Intelligence environment by maintaining technical documentation, contributing to data quality initiatives, identifying opportunities to improve reporting and analytics, and ensuring all information products comply with information governance and data protection requirements. You will provide technical expertise to projects, work collaboratively with internal and external stakeholders, and contribute to the continuous improvement of the Trust's reporting capabilities.

Detailed job description and main responsibilities

As a Business Intelligence Developer, you will play a key role in the development, enhancement and support of the Trust's Business Intelligence platform, helping to deliver high-quality information that supports operational management, strategic planning and improvements in patient care.

Working within the Performance Team, you will be responsible for designing, developing and maintaining robust Business Intelligence solutions using Microsoft technologies including SQL Server, SQL Server Integration Services (SSIS), Power BI and Microsoft Report Builder. You will develop data warehouses, ETL processes, dimensional data models, databases, reports and interactive dashboards that provide accurate, timely and accessible information to a wide range of users across the Trust.

You will work closely with Digital and Information colleagues to ensure that reporting solutions are built on reliable and up-to-date datasets, supporting the ongoing development of the Trust's data warehouse and Business Intelligence environment. You will identify opportunities to automate reporting processes, improve data quality and enable self-service reporting, ensuring that solutions are scalable, efficient and aligned with business priorities.

The role requires strong technical expertise in database development, SQL programming and Business Intelligence technologies, together with the ability to analyse complex information requirements and translate them into practical reporting solutions. You will contribute to the design, implementation and testing of new systems and enhancements, ensuring all developments are fully documented, appropriately secured and subject to rigorous quality assurance before release.

Working collaboratively with stakeholders across clinical, operational and corporate services, you will provide technical advice and support, helping users to maximise the value of Business Intelligence products. You will contribute to Trust-wide projects involving data integration, information systems and analytics, while maintaining technical documentation to support future development, maintenance and knowledge sharing.

You will ensure that all information products comply with information governance standards, data protection legislation and Trust policies, maintaining the highest standards of data security and confidentiality. You will also contribute to the continuous improvement of Business Intelligence services by keeping up to date with emerging technologies, promoting best practice and sharing knowledge with colleagues through training and support where appropriate.

The successful candidate will be an analytical and proactive problem solver with excellent communication skills, capable of managing a varied workload and working independently while building effective relationships with colleagues, system suppliers and other stakeholders across the organisation.

Applicant requirements

The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.