Employer Northamptonshire Healthcare NHS Foundation Trust Employer type NHS Site St Marys Town Kettering Salary £38,682 - £46,580 per annum Salary period Yearly Closing 12/08/2025 08:00
BI Database Analyst
Band 6
Job overview
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.
· W ork 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
Working for our organisation
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.
Detailed job description and main responsibilities
For further information on the advertised role, please refer to the job description located under the Supporting Documents heading. The full person specification can be accessed under the ‘About You’ Section of the document.
Person specification
Qualifications
* Evidence of Continued Professional Development
* Product Lifecycle Management & Improvement Tools (e.g. PRINCE2/Agile/QSIR)
Personal attributes and abilities
* Enthusiastic, motivated, autonomous as well as being a good team leader
* Able to engage with a variety of people, including those within 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
* Ability to capture and translate business requirements
* Ability to create effective and meaningful dashboards and reports that support decision making across the Trust
* Experience of using Power BI/Power Query/DAX
* Proven experience of working with multiple senior stakeholders to build relationships and communication channels
* Experience of delivering effective training and providing user support to non-technical staff and colleagues
* Application of analytical techniques and tools to solve business problems
* Experience of working in a health or social care environment
Knowledge
* 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
By completing an application you are giving authorisation for the transfer of your data. In submitting an application form, you authorise us to confirm any previous NHS service details via the Electronic Staff Record (ESR) Inter Authority Transfer (IAT) process. Including factual reference, occupational health clearance and statutory and mandatory training records and full service history.
You must ensure that your application, including supporting statements and behaviour examples, are truthful and factually accurate. Please note plagiarism can include presenting the ideas and experience of others, or generated by artificial intelligence, as your own.
Correspondence regarding your application will be sent to you via a TRAC system account.
Please submit your application as soon as possible; due to the high volumes of applications we receive we reserve the right to close any adverts before the closing date once we have received sufficient applications.
We are an equal opportunities employer, which aims to employ a workforce that reflects the diverse communities we serve. We welcome applications from all suitably qualified persons from all backgrounds.
All roles are subject to the home office immigration rules and therefore eligibility must meet certain requirements for any sponsorship to be considered. Please visit the government website for more information regarding eligibility,
At NHFT we support many of our colleagues to work flexibly and we will consider requests for flexible working from day one. For this role, we are open to discussing a range of options including flexible hours, agile/home working, compressed hours and part time hours. Please have a conversation with the recruiting manager about the flexibility you need and we will promise to explore what is possible with you.
Applicants who have a disability and meet the essential criteria for the job will be considered under the Guaranteed Interview Scheme. If you require a reasonable adjustment at any stage of the recruitment process please make the recruitment services team aware as soon as possible.
All posts that are engaged in a regulated activity will be subject to a Disclosure and Barring Service (DBS) check and a DBS re-check on a three yearly basis whilst employed in such a role. Staff employed in these posts will therefore be asked to register with the DBS Automatic Update Service upon receipt of their DBS certificate and must update yearly, the annual fee will be reimbursed subject to Trust policy. For further information please visit: DBS Update Service: applicant guide - GOV.UK (www.gov.uk)
Please note if a DBS is applicable for the position then a charge will be deducted from your first salary or upfront cost if a staff bank position.
Please note that all new starters to the trustare subject to a probationary period.
Employer certification / accreditation badges
#J-18808-Ljbffr