Senior Business Intelligence Developer

As a Senior BI Developer, you will lead the design, build and governance of the Trust's BI landscape to ensure secure, accurate, and timely data for reporting and decision-making. You will shape data architecture and analytics work across clinical, workforce, and corporate sources, enabling insights that support better care. The role involves delivering scalable BI solutions and mentoring others within the BI team. You will operate in a hybrid environment and contribute to a culture of care and inclusion.

• hybrid working pattern
• Agenda for change pay band 8a
• Permanent contract
• salary range £57,528–£64,750 per year
• diversity and inclusion emphasis
• close collaboration with multidisciplinary teams

• Lead BI projects from development through implementation, ensuring standards, timelines and quality.
• Provide technical guidance and knowledge transfer to developers and analysts.
• Maintain documentation and governance; collaborate with clinical, operational, corporate teams, system suppliers and partners.
• Design and maintain the data warehouse and BI infrastructure, including trusted data sources, Power BI models, data gateways and ETL processes.
• Integrate data from diverse systems (clinical, workforce, etc.) using SQL Server, T-SQL, Python, SSIS, SSRS and APIs; improve data quality and reporting resilience.

• Degree level education or equivalent experience
• Advanced knowledge of T-SQL
• Significant experience developing Microsoft BI solutions (SQL Server 2016+), including SSIS, SSRS, SSAS
• Experience writing Python scripts
• Experience querying data and developing reports or dashboards in Power BI or similar BI tools
• Experience developing ETL routines and data warehousing
• Experience working with APIs for secure data exchange

• Attention to detail
• Quality assurance
• Collaborative communication
• SQL Server (2016+), T-SQL
• Python
• SSIS, SSRS, SSAS