Detailed job description and main responsibilities

Technical Development & Data Engineering

Design, create and maintain SQL database objects including tables, views, stored procedures and functions, ensuring optimal design principles, data integrity and performance. Write complex, efficient SQL queries to support reporting, analysis and data extraction, proactively reviewing and optimising existing objects to improve performance, maintainability and reliability.

Develop and maintain ETL processes to load data from multiple sources into SQL Server databases, producing structured datasets in Excel and CSV formats for internal use and external submissions including national and regional data returns.

Build, develop and maintain Power BI reports, dashboards and semantic models using best practice in data modelling, DAX, Power Query and visual design to deliver intuitive, self-service reporting solutions. Develop and manage Microsoft Fabric pipelines for data ingestion, transformation and orchestration.

Design and maintain SSRS reports and subscriptions for operational and statutory reporting needs. Develop PowerApps business applications to digitise processes and enhance workflow efficiency across clinical and corporate teams.

Desirable: Utilise Python and other tools for data manipulation, automation and advanced analytics, contributing to the evolution of the Trust's analytical capabilities. Utilise PowerShell scripting to automate administrative tasks and data processes. Support NHS Federated Data Platform pipeline integration where applicable.

Reporting, Analysis & Information Delivery

Lead on the development and delivery of dashboards and reporting solutions from the Trust's data warehouse, taking ownership of work that evolves the warehouse into one optimised for business intelligence. Work with the data management team to ensure the reporting layer meets internal and external requirements, implementing well-defined business logic and enabling automated, self-service access to intelligence.

Apply sophisticated analysis techniques and performance management to monitor progress against targets, identifying service improvement opportunities. Use statistical methods, trend analysis and benchmarking against national comparators to provide meaningful, contextualised intelligence supporting evidence-based decision making.

Develop and deliver performance monitoring dashboards against national and local standards using Power BI, SSRS, Microsoft Fabric and other reporting tools, ensuring outputs are accurate, accessible and actionable.

Strategic & Operational Support

Develop solutions supporting the strategic and operational BI function across clinical and corporate divisions, ensuring all Business Intelligence Partners contribute to a value-added, forward-looking service designed with longevity, scalability and usability in mind.

Support the Head of Business Intelligence Development in delivering the BI strategic vision — streamlining activities, implementing a real-time corporate approach to intelligence, establishing a single version of the truth and promoting self-service access to data through world-class technologies.

Take ownership of a defined area of the BI improvement plan, working with colleagues across the team and department to maintain and implement agreed developments. Collaborate to reduce manual or disjointed processes, ensuring the service remains value-added. Support the Trust's transformation into an exemplar organisation underpinned by sound business intelligence and a rigorous Performance Framework.

Maintain and develop dynamic activity, demand and capacity models to support short- and long-term identification of service needs, working with divisional management teams and corporate business partners to triangulate with finance and workforce implications.

Support the Project Management Office by performance tracking for specific programmes, developing automated reporting solutions to reduce manual overhead.

Leadership & Stakeholder Engagement

Represent the Business Intelligence department at internal and external meetings, supporting the Trust's corporate and clinical strategy. Attend Monthly Performance Reviews, Divisional Quality Committees and Service Delivery Reviews to drive quality improvements in patient care and operational delivery, proactively highlighting data quality issues and emerging trends.

Establish strong working relationships with clinical staff, leaders, divisional management teams and external stakeholders, promoting joint working with health economy partners. Act as a trusted advisor on data, reporting and business intelligence matters. Deputise for the Head of Business Intelligence Development as required.

Communication

Work with senior staff across clinical and corporate divisions to ensure portfolio areas are communicated effectively, advising on risk, dependencies and areas requiring consideration. Ensure divisions have the intelligence, advice and guidance needed to monitor and act upon performance proactively.

Present reporting solutions and analytical outputs to a wide range of stakeholders, clearly articulating data, methodology and actionable insights. Translate complex technical concepts into accessible language, ensuring understanding and confidence in the intelligence provided at all levels of the organisation.

Service Delivery and Improvement

Provide an expert BI development and reporting service to support a performance-focused culture in line with the Trust's Patient First approach, ensuring safety, quality and excellent patient care are consistently supported through robust reporting solutions and high-quality analytical interpretation.

Lead on the timely and accurate delivery of BI developments supporting the Trust's True North objectives, monitoring progress against targets and ensuring developments are delivered to agreed timescales and quality standards, escalating risks promptly.

Exercise sound judgement in analysing complex issues, providing realistic improvement options linked to actual operational challenges — for example, analysing speciality-level performance against 18-week pathways and building reporting tools to enable ongoing monitoring.

Provide specialist training and knowledge transfer on SQL, Power BI, SSRS, SSIS, Microsoft Fabric and PowerApps, ensuring knowledge is shared effectively and colleagues are supported in developing their technical capabilities.

People Management and Development

Support the development of BI Development Managers and junior staff, providing technical guidance, mentorship and constructive feedback. Support other BI teams in learning best practices in data management and reporting, fostering a collaborative and knowledge-sharing culture across the wider BI function.

This job description is an outline of the role and responsibilities. From time to time, due to the needs of the service, the post-holder may be asked to flexibly undertake other duties consistent with their role and banding, including project work, internal job rotation and absence cover. The job description and person specification may be reviewed on an ongoing basis in accordance with the changing needs of the department and the organisation.