# Business Intelligence Developer > NHS job listing from Job Clerk for Derbyshire Community Health Services NHS Foundation Trust. ## Canonical URLs - **HTML:** https://www.jobclerk.com/job/business-intelligence-developer/d6debb3a-4d39-4779-b8f8-d4b57d6c16c3 - **Markdown:** https://www.jobclerk.com/job/business-intelligence-developer/d6debb3a-4d39-4779-b8f8-d4b57d6c16c3.md ## Summary - **Status:** Live - **Employer:** Derbyshire Community Health Services NHS Foundation Trust - **Location:** Hybrid Working - **Workplace type:** onsite - **Profession:** Administrative and IT - **Grade:** Band 6 - **Salary:** £39,959 - £48,117 pa, pro rata - **Contract type:** Permanent - **Employment type:** Full time - 37.5 hours per week - **Closing date:** 2026-08-23T22:59:00.000Z - **Posted:** 2026-08-11T07:20:46.924Z - **Source information URL:** https://www.healthjobsuk.com/job/UK/Derbyshire/Derbyshire/Derbyshire_Community_Health_Services_NHS_Foundation_Trust/Digital/Digital-v7987386 - **Application URL:** https://apps.trac.jobs/job-advert/7987386?ShowJobAdvert=&feedid=9002 - **Employer website:** https://www.dchs.nhs.uk ## Job Content ### Job overview We are looking for a skilled Business Intelligence Developer to join our Digital Team and help deliver high‑quality data, reporting and insight to support clinical, operational and corporate decision‑making. You will have strong experience in database development and Microsoft BI tools, including SQL Server, SSIS, SSAS, Microsoft Fabric and Power BI. Working closely with services and senior BI colleagues, you will design, develop and maintain robust dashboards, datasets and reporting solutions within agreed data standards and information governance frameworks. This is an excellent opportunity to develop your technical skills, contribute to meaningful improvement work, and support evidence‑based decision‑making across the organisation. ### Main duties of the job BI Development & Reporting - Develop, maintain and enhance BI reports, dashboards and datasets using Power BI. - Write and optimise SQL queries, views and stored procedures to support reporting and analytics needs. - Build and support ETL and data integration processes using SSIS and Microsoft Fabric Pipelines, following agreed design standards. - Contribute to the development and maintenance of semantic models using SSAS (Tabular) and Fabric semantic models. - Ensure BI outputs are accurate, timely, clearly presented and aligned to user requirements. - Management of national data submissions, i.e. Commissioning Data Sets, Community Services Data Set, and the Emergency Care Data Set. - Development and management of Microsoft Power Platform products Data Management & Quality - Work with multiple data sources, ensuring appropriate joins, transformations and validations are applied. - Database administration, management, and maintenance. Continuous Improvement & Development - Contribute to the improvement of BI standards, reusable datasets and reporting approaches. Support the organisation’s transition to Microsoft Fabric, learning and applying new capabilities as directed. Keep skills up to date with developments in Microsoft BI stack’; Power BI, analytics tools, and Power platform - Contribute to the improvement of BI standards, reusable datasets and reporting approaches. - Support the organisation’s transition to Microsoft Fabric, learning and applying new capabilities as directed. - Keep skills up to date with developments in Microsoft BI stack’; Power BI, analytics tools, and Power platform ### Detailed job description and main responsibilities Information Resources/Information Systems - Maintain up‑to‑date knowledge of SQL Server, SSIS, SSAS, Power BI and Microsoft Fabric, applying best practice in BI development - Actively develop skills in emerging Microsoft analytics capabilities, including Fabric Lakehouse, Warehouse and semantic models. - Contribute to knowledge sharing within the team, including documentation of solutions, processes and standards. - Participate in relevant training, professional development and continuous learning activities. - Apply organisational standards and best practice in data modelling, ETL design, reporting and analytics delivery. - Support adoption of new tools, techniques and working practices across the BI function. - Develop, maintain and enhance BI reports, dashboards and datasets using Power BI. - Write and optimise SQL queries, views and stored procedures to support reporting and analytics needs. - Build and support ETL and data integration processes using SSIS and Microsoft Fabric Pipelines, following agreed design standards. - Contribute to the development and maintenance of semantic models using SSAS (Tabular) and Fabric semantic models. - Ensure BI outputs are accurate, timely, clearly presented and aligned to user requirements. - Work with multiple data sources, ensuring appropriate joins, transformations and validations are applied. - Support data quality improvement by identifying issues, highlighting risks and working with data owners to resolve them. - Follow agreed information governance, security and data protection standards, including NHS IG requirements where applicable. - Work with service teams, analysts and managers to gather reporting requirements and translate them into effective BI solutions. - Provide advice to users on the appropriate interpretation and use of BI products. - Support senior BI colleagues by contributing to documentation, testing and peer review of BI solutions. - Contribute to the improvement of BI standards, reusable datasets and reporting approaches. - Support the organisation’s transition to Microsoft Fabric, learning and applying new capabilities as directed. - Keep skills up to date with developments in SQL, Power BI and Microsoft analytics tools. ### Applicant requirements This post will require a submission for Disclosure to be made to check for any unspent criminal convictions. ## Person Specification ### Knowledge **Essential** - Good working knowledge of SQL Server and SQL query development **Desirable** - Relevant technical / professional qualifications at post graduate level. ### Experience **Essential** - Experience working in a BI, data or analytics development role - Experience developing reporting or analytics solutions for operational or performance management - Experience working with relational databases and structured datasets **Desirable** - Experience with Azure data services alongside Microsoft Fabric ## Documents - [application guidance (pdf, 248.4kb)](https://www.healthjobsuk.com/documents?edoc=2565) - [business intelligence developer (pdf, 456.6kb)](https://www.healthjobsuk.com/documents?vdoc=10473773) ## 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.