Senior Business Intelligence Developer

Overview

In this role you lead and shape the Trust’s BI capabilities to deliver secure, accurate, and timely data for reporting, analysis and decision-making. You will guide the BI team, own data warehouse and semantic models, and ensure resilient data integration from clinical and corporate systems. You’ll collaborate with clinical, operational and external partners to enable better services and patient care through data-driven insight. This position offers hybrid working and a strong focus on inclusive, transformational delivery.

Pay / Benefits

• hybrid working pattern
• permanent contract
• Band 8a salary 57,528 to 64,750 per annum

Responsibilities

• Design, develop and maintain the data warehouse and BI infrastructure (including semantic models, data gateways and ETL processes)
• Provide technical guidance and knowledge transfer to developers and analysts
• Ensure governance, documentation and adherence to standards, timescales and quality
• Collaborate with clinical, operational, corporate teams, system suppliers and external partners to deliver reliable BI solutions
• Lead technical BI projects from development to implementation, focusing on data quality, performance and reporting resilience

Key requirements

• Educated to degree level or equivalent experience
• Advanced knowledge of T-SQL
• Significant experience developing Microsoft BI solutions (SQL Server 2016+, SSIS, SSRS, SSAS)
• Experience with Python
• Experience querying data and creating reports/dashboards in Power BI or similar
• Experience ETL development and dimensional data modeling, data warehousing
• Experience working with APIs for secure data exchange

• Attention to detail and quality assurance
• Leadership and knowledge transfer capabilities
• Collaborative cross-functional communication
• SQL Server
• T-SQL
• Python

…