Senior Business Intelligence and Data Warehousing DBA

Job summary

As a Senior Business Intelligence and Data Warehousing DBA you will be part of a close-knit team of people providing essential management, financial and clinical reports alongside near real time operational data to over 1,000 NWLP colleagues, NWLP 's partners and other NWLP clients.

You will be the first point of contact for the Business Intelligence Team on a weekly rotational basis as a part of this role and will thus be in frequent contact with NWLP service users and colleagues at all levels in addition to the back office nature of the Team

The role will primarily be based at St Mary's Hospital, Paddington, with the potential to travel to the partner sites as required. We value relationships and feel that face to face communication is important. However, we care about how you work rather than where you work, so the role is open to remote working meaning you aren't required to be in the office 5 days a week. We'd welcome a conversation with the successful candidate about what remote working looks like for you.

Main duties of the job

• Manage the BI Team's dedicated SQL Server Data warehouse, hosted on a pair of clustered physical servers, on a day to day basis
• Monitor timed SSIS and TSQL Server agent tasks and act as needed in the event of issues
• Act as the first point of contact for all stakeholders and either deal with any requests or pass them to other team members as required
• Develop ad-hoc and regular reports in response to requests for data
• Supply the NWLP Finance team and Partners with routine month-end data
• Maintain key reference datasets with current data
• Work flexibly as part of a team

About us

Benefits include career development, flexible working, staff wellbeing programmes, staff awards and recognition scheme. We also have available benefits including Cycle to Work, car lease schemes, season ticket loan or membership options for onsite leisure facilities.

Environmental sustainabilityClimate change and poor air quality is a health emergency that harms people's health and wellbeing and widens health inequalities. The Trust is also committed to reducing its impact on the environment by reducing our greenhouse gas emissions to Net Zero by 2045. All our employees have a role to play, and we have an active green network that supports staff to act in ways that ensures that our services are efficient, sustainable and reduce our impact on the environment www.imperial.nhs.uk/about-us/our-strategy/green-plan

NWLP Induction

The NWLP induction will run on the first Monday of each month (provided it does not fall on a bank holiday) and includes laboratory training (for relevant laboratory roles). All new staff must attend the NWLP induction during their first week with NWLP.

For 2026, see below the start dates which you will be able to book once you have completed all your pre-employment checks.

Monday 7 September 2026Monday 5 October 2026Monday 2 November 2026Monday 7 December 2026

Candidates are advised to consider these start dates before agreeing end of service date with their current employer.

Job responsibilities

The full job description provides an overview of the key tasks and responsibilities of the role and the person specification outlines the qualifications, skills, experience and knowledge required.

For both overviews please view the Job Description attachment with the job advert.

Person specification

Education/ qualifications

Essential

• First Degree.
• Microsoft managing an SQL Server Database Course
• Evidence of ongoing personal and professional development
• T-SQL Training

Desirable

• Microsoft SQL Server Integration Services Course
• Microsoft SQL Server Reporting Services Course
• Scientific qualification or experience working in pathology or healthcare

Skills/ abilities

Essential

• Microsoft Excel and Microsoft Access (Intermediate)
• T-SQL (Structured Query Language) at a level to extract data from large complex databases
• Managing an SQL Server 2019 instance and associated Server
• Good analytical skills for spotting or anticipating weaknesses in processes (manual or system), along with the ability to organise and implement correction.

Desirable

• Knowledge of data warehouse design principles
• Excellent understanding of NHS operational and Strategic issues, mandatory reporting requirements, NHS data standards and definitions
• Developing SSRS Reports

Experience

Essential

• Good understanding of technology and systems applications
• Metadata management
• ETL (Extract, Transform, and Load) knowledge
• OLAP Principles

Desirable

• Demonstrable experience at a senior level in healthcare informatics management role.