BI Database Analyst

Superchem Industries; England; On-site; GBP 35,000 - 45,000; Full time

Job summary

A leading healthcare Trust in the UK seeks a Database Analyst to support data-driven decision-making. You will design and maintain database solutions, implement ETL processes, and ensure data quality. This role offers an opportunity to impact patient care positively in a supportive environment for innovation and growth.

Qualifications

• Proven experience in database design and administration.
• Strong analytical skills and attention to detail.
• Ability to collaborate with both technical and non-technical stakeholders.

Responsibilities

• Design, develop, and maintain ETL processes.
• Monitor database performance and resolve issues.
• Collaborate with teams to deliver data solutions.

Skills

SQL

Data Architecture

ETL Processes

Data Quality

Power BI

Collaboration

Tools

SQL Server Integration Services (SSIS)

SQL Server

Job description

We are seeking a highly motivated and skilled Database Analyst to join our Business Intelligence Service. The Service is 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 improve, maintain, and administer both the Trust's BI Data Warehouse and the associated Power BI reporting systems, utilizing advanced SQL and Data Architecture skills to manage processes within the current framework.

1. Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
2. Transform data using SQL Server and other tools to ensure data quality, consistency, and compliance with business rules and NHS data standards.
3. Monitor database performance and resolve issues.
4. Work with Analysts and Developers to enable Power BI reporting.
5. Collaborate with clinicians, technical, and non-technical stakeholders to meet their requirements.
6. Ensure data supports internal and national reporting platforms.
7. Implement data quality checks and controls to ensure data accuracy and integrity.
8. Contribute to data governance policies and procedures within the Trust.
9. Identify and analyze risks to ensure business continuity, patient safety, and disaster recovery.
10. Act as a subject matter expert in data architecture and domains for data-related projects.
11. Collaborate with cross-functional teams to deliver data solutions that improve patient care.
12. Support third-party suppliers with queries, integrations, and interfaces.
13. Support NHFT’s Business Intelligence Service Transformation Programme in data management and integration.

NHFT is an integrated primary care and mental health Trust providing services in hospital and community settings, focusing on accessible, patient-centered care. We serve various populations, including prisons and detention centers in Bedfordshire and Cambridgeshire.

NHFT promotes a culture of learning to enhance care and safety, supporting opportunities for innovation, development, and growth. For more details, please refer to the job description under the Supporting Documents section and the full person specification in the About You section.