BI Database Administrator
The closing date is 23 October 2025
Job summary
We are seeking a highly motivated and skilled Database Analyst to join our Business Intelligence Service. The Service are responsible for delivering Business Intelligence capabilities to drive improvements in performance across the Trust, supporting the wider system and partners, enabling Northamptonshire Health Foundation Trust (NHFT) to be a leading provider of Outstanding compassionate care.
In this role, you will play a vital part in supporting the Trust's data-driven decision-making by designing, developing, and maintaining efficient and reliable database solutions. You will leverage your expertise to improving, maintaining, and administrating both the Trusts BI Data Warehouse, and the associated Power BI reporting systems, where the position holder will be expected to utilise their advanced level SQL & Data Architecture skills to manage processes and developments within the current framework.
Main duties of the job
Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
Transform data using SQL Server and other tools to ensure data quality, consistency, and compliance with business rules and NHS data standards.
Monitor database performance and identify/resolve any issues.
Work with Analysts and Developers to enable the production of Power BI reporting.
Collaborate with clinicians, technical and non-technical stakeholders to meet their requirements
Ensure data is maintained to meet the needs of all reporting platforms supporting internal and national submissions.
Implement and maintain data quality checks and controls to ensure data accuracy and integrity.
Contribute to the development and implementation of data governance policies and procedures within the Trust
Identify, and analyse risks to the organisation to ensure business continuity, patient safety and disaster recovery requirements are met.
Act as a subject matter expert for data architecture and data domains, supporting for data-related projects across the organisation
Collaborate with cross-functional teams to deliver data solutions that meet business requirements and improve patient care.
Support third party suppliers with queries integration and interfaces
Support NHFTs Business Intelligence Service Transformation Programme in the development of data management, data integration and applications management
About us
NHFT is an integrated primary care and mental health Trust, providing physical, mental health and specialty services in both hospital settings and out in the community. Because we put the person at the centre of all we do, we focus on delivering care that is as easy to access as possible. This means many of our services can be provided at home, work or in schools.We also provide health services to various prisons and detention centres in Bedfordshire and Cambridgeshire.
NHFT promotes a culture of learning to improve the care and safety of our patients and staff, which focuses on people who enable our Trust to be 'outstanding' by supporting opportunity, innovation, development and growth.
Details
Date posted
09 October 2025
Pay scheme
Agenda for change
Band
Band 6
Salary
£38,682 to £46,580 a year per annum
Contract
Permanent
Working pattern
Full-time
Reference number
270-TG422-CORP
Job locations
St Marys Hospital
London Road
Kettering
NN15 7PW
Employer details
Employer name
Northamptonshire Healthcare Foundation Trust
Address
St Marys Hospital
London Road
Kettering
NN15 7PW
Employer's website
https://www.nhft.nhs.uk/ (Opens in a new tab)
Employer contact details
For questions about the job, contact:
Supporting documents
Privacy notice
Northamptonshire Healthcare Foundation Trust's privacy notice (opens in a new tab)