# Business Intelligence Developer > NHS job listing from Job Clerk for North Staffordshire Combined Healthcare NHS Trust. ## Canonical URLs - **HTML:** https://www.jobclerk.com/job/business-intelligence-developer/224f42ac-9086-43cb-a162-50ab9f36f150 - **Markdown:** https://www.jobclerk.com/job/business-intelligence-developer/224f42ac-9086-43cb-a162-50ab9f36f150.md ## Summary - **Status:** Live - **Employer:** North Staffordshire Combined Healthcare NHS Trust - **Location:** Lawton House, Trust Headquarters - **Workplace type:** onsite - **Profession:** Developer - **Grade:** Band 6 - **Salary:** £39,959 - £48,117 per annum - **Contract type:** Fixed term: 13 months (This post is to backfill a secondment opportunity) - **Employment type:** Full time - 37.5 hours per week - **Closing date:** 2026-09-17T22:59:00.000Z - **Posted:** 2026-09-03T13:32:19.744Z - **Source information URL:** https://www.healthjobsuk.com/job/UK/Staffordshire/StokeonTrent/North_Staffordshire_Combined_Healthcare_NHS_Trust/Business_Intelligence_Developer/Business_Intelligence_Developer-v8174372 - **Application URL:** https://apps.trac.jobs/job-advert/8174372?ShowJobAdvert=&feedid=9002 - **Employer website:** https://www.combined.nhs.uk ## Job Content ### 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. ## Person Specification ### Other **Essential** - Ability to meet the travel requirement for the post. ### Experience **Essential** - Substantial experience, or equivalent, developing ETL processes, Data Warehouses, and SSRS reports with Microsoft BI technologies (SSIS, SSAS, SQL, SSRS, VS2013). - Experience of designing, coding, integrated dashboard scope, design and development. - Experience of analysing and presenting data/findings to varied audiences - Demonstrable experience of data transformation and loading of transformed data. - Knowledge of Data Protection legislation, data protection and protection toolkit **Desirable** - Experience of working in the NHS. - An understanding of Performance Management An understanding of CQC Compliance. - Experience of project work and ownership responsibility. ### Qualifications **Essential** - Degree or equivalent relevant experience to achieve advanced status in the use of MS SQL, SQL Server, SSRS, Power BI, MS Excel. **Desirable** - Post graduate qualification ### Knowledge & Skills **Essential** - A logical and analytical approach to problem solving demonstrated in an information systems environment. - Development skills working with BI analytics tools, such as MS Power BI, SSRS, Qlikview, Tableau. - Sound in depth knowledge of database design principles, Microsoft BI stack technologies is essential. - Experienced in writing SQL. - Management and development of an MS SharePoint environment. - Testing and implementation of efficient and robust reports and database schemas. - Demonstrable experience of data transformation and loading of transformed data. - Knowledge of Data Protection legislation, Data Security and Protection Toolkit **Desirable** - Familiarity with benchmarking & comparative analysis tools. - Familiarity with R and Python ## Documents - [nhs pension (pdf, 97.5kb)](https://www.healthjobsuk.com/documents?edoc=1216) - [employee benefits (pdf, 1.3mb)](https://www.healthjobsuk.com/documents?edoc=2653) - [why work at nscht (pdf, 689.6kb)](https://www.healthjobsuk.com/documents?edoc=1217) - [bi developer - job description (pdf, 480.3kb)](https://www.healthjobsuk.com/documents?vdoc=10477140) - [bi developer - person specification (pdf, 112.7kb)](https://www.healthjobsuk.com/documents?vdoc=10477141) ## Agent Notes - This Markdown page is generated from the same Job Clerk job record as the HTML job detail page. - Use the canonical HTML URL for user-facing references. - Use the application URL when the user wants to apply on the source NHS site.