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 description
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
- First Degree.
- Microsoft managing an SQL Server Database Course
- Evidence of ongoing personal and professional development
- T-SQL Training
- Microsoft SQL Server Integration Services Course
- Microsoft SQL Server Reporting Services Course
- Scientific qualification or experience working in pathology or healthcare
Skills/ abilities
- 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.
- 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
- Good understanding of technology and systems applications
- Metadata management
- ETL (Extract, Transform, and Load) knowledge
- OLAP Principles
- Demonstrable experience at a senior level in healthcare informatics management role.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
North West London Pathology
Address
St Mary's Hospital
Praed Street
London
W2 1NY
United Kingdom
Employer's website
https://www.nwlpathology.nhs.uk/