BI Database Administrator

Northamptonshire Healthcare NHS Foundation Trust; Kettering; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading healthcare trust in Kettering is seeking a motivated Database Analyst to enhance their Business Intelligence capabilities. The role focuses on database design and development to support data-driven decisions, utilizing expertise in SQL and data architecture. Candidates should have robust experience in ensuring data quality and compliance with NHS standards, and work collaboratively to improve patient care through efficient data solutions.

Qualifications

• Experience in developing and maintaining database solutions.
• Strong understanding of NHS data standards.
• Ability to monitor database performance and resolve issues.

Responsibilities

• Design and develop ETL processes using SSIS.
• Transform data to ensure quality and compliance.
• Collaborate with stakeholders for reporting needs.

Skills

Advanced SQL

Data Architecture

ETL Development

Data Quality Assurance

Tools

SQL Server Integration Services (SSIS)

Power BI

Job description

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.

Responsibilities

• 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 NHFT

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.

Contact

For further details / informal visits contact: Name: Edward Buxton
Job title: Business Intelligence Manager
Email: [e-mail]
Telephone: [phone]