> Markdown version of [/jobs/ext/4490919-business-intelligence-developer](https://www.wearedevelopers.com/jobs/ext/4490919-business-intelligence-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Business Intelligence Developer

- **Company:** Cardiff and Vale University Health Board
- **Location:** Ashford, UK
- **Experience:** Expert
- **Salary:** £57,528.0 - £64,750.0
- **Contract:** Permanent contract
- **Skills:** Microsoft Azure, Health Informatics, Databases, Data Warehousing, Database Queries, Microsoft SQL Server, Visual Basic .NET (Programming Language), Power BI, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Transact-SQL, Scripting, Electronic Medical Records, Vba Programming Language, Tools for Reporting
- **Published:** November 1, 2026
- **Apply:** https://www.jobs.nhs.uk/candidate/jobadvert/C9380-26-0878/ats-direct-apply

## About the Role

* Educated to degree level or able to demonstrate equivalent relevant experience., * Relevant degree, for example Health Informatics, Computer Studies or Mathematics
 * Microsoft SQL Server certification
 * Certification in the use of Business Intelligence tools
 * Evidence of ongoing leadership training and development, * High level of attention to detail, accuracy and quality assurance
 * Advanced knowledge of T-SQL, * Knowledge of mental health trust processes, activities and services
 * Knowledge of project management tools and concepts, * Significant experience developing Microsoft BI solutions, including SQL Server (2016 or later), SSIS, SSRS and SSAS
 * Experience of writing Python scripts
 * Experience querying data and developing reports or dashboards in Power BI or other BI tools
 * Experience developing ETL routines and working with dimensional database design, management and reporting solutions
 * Experience of data warehousing
 * Experience working with APIs for secure and efficient exchange of information, * Experience of NHS datasets, performance requirements and information flows
 * Experience using Azure Portal
 * Significant experience using Power BI
 * Experience of the Rio electronic patient record system
 * Experience of R, and/or VBA
 * Experience developing small applications (web or non-web) using VB.Net or similar to support data capture and presentation
 * Experience of data set triangulation, identifying potential to link different database/data set sources

## Description

You will lead the design, development and maintenance of the Trust's data warehouse and wider BI infrastructure, including trusted data sources, Power BI semantic models, data gateways and automated ETL processes. You must have experience using technologies such as SQL Server, T-SQL, Python, SSIS, SSRS and APIs, as you will be expected to use those to integrate information from clinical, workforce, and other corporate systems, while improving data quality, system performance and reporting resilience., You will manage technical BI projects from development through to implementation, ensuring that agreed standards, timescales and quality requirements are met. You will provide technical guidance and knowledge transfer to developers and analysts, maintain effective documentation and governance, and work closely with clinical, operational and corporate colleagues, system suppliers and external partners to deliver reliable and reusable BI solutions.