Business Intelligence; BI Developer-Analyst

Business Intelligence (BI) Developer-Analyst

The closing date is 09 June 2026

Northamptonshire Healthcare Foundation Trust (NHFT) is looking to recruit a BI Developer-Analyst to work within the Business Intelligence Service, responsible for performance improvement and contract management of existing services and provision of reporting functionality to support operational management of clinical services.

The Trust aims to use Power BI to provide interactive visualisations with self-service business intelligence capabilities, enabling end users to create reports and dashboards independently. The role involves improving, maintaining and administering the Trust’s Data Warehouse and associated Power BI reporting systems, using advanced SQL, SSRS, and Power BI skills to manage routine and ad-hoc processes and developments. The position holder will work closely with the Data Warehouse Data Architect to facilitate continued systems development.

Develop new database and reporting systems to support the delivery of the Trust’s BI Systems Power BI Project.

Manage and understand the full life‑cycle of system and report development within a SQL/SSRS/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug‑fixes.

Manage development activity and administration of the team’s SQL data warehouse, a central point of collation for the Trust's various system data‑streams. Provide direct support to members of the BI Service, supplying information to support reporting to Operational Managers & Leads.

Become proficient in understanding how the Trust's Data Warehouse works, and the implications of changes from an operational and business intelligence perspective.

Maintain an expert knowledge of the Trust's PAS system Systm One, other corporate information systems (such as ESR, Datix, IWGC), and an in‑depth understanding of how its data is interpreted within the Trust’s Data‑Warehouse in relation to reporting and data extraction.

NHFT is an integrated community care and mental health Trust, providing physical, mental health and specialty services in hospital settings and in the community. We focus on delivering care that is easy to access, offering many services at home, work, or in schools, and providing health services to various prisons and detention centres in Bedfordshire and Cambridgeshire.

• Post‑graduate diploma or specialist qualification/training to Masters level (or equivalent experience)
• Evidence of continued professional development

• Enthusiastic, motivated, autonomous, and a good team leader
• Able to engage with a variety of people, including those within the identified team and those in external agencies
• Able to use own initiative and make decisions independently
• Committed to continual quality and service improvement
• Self‑aware and committed to professional and personal development
• Flexible and proactive attitude

• Experience of using Power BI/Power Query/DAX
• Extensive experience of SQL BI Stack (SSIS, SSAS, SSRS)
• Proven experience of working with multiple senior stakeholders to build relationships and communication channels
• Experience of managing and understanding the full life‑cycle of system and report development within a SQL/Power BI environment, including all aspects of access control, maintaining data integrity, investigating errors and implementing bug‑fixes
• Experience of developing new database and reporting systems
• Ability to capture and translate business requirements effectively to create meaningful dashboards and reports that support decision‑making across the Trust
• Experience of delivering effective training and providing user support to non‑technical staff and colleagues
• Knowledge of the Trust's PAS system Systm One, other corporate information systems (such as ESR, Datix, IQVIA)
• Experience of working in a health or social care environment

• Understanding of the local NHS structure, strategy, vision and policy
• Highly developed, in‑depth specialist knowledge, underpinned by theory and professional experience of disciplines including technical development over an extended period

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and will require a submission for Disclosure to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Northamptonshire Healthcare Foundation Trust