Senior Business Intelligence and Data Warehousing DBA

Job summaryAs 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 TeamThe 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. There is a small amount of routine work, normally no more than 30 minutes every weekend day and public holiday. Such support is undertaken remotely on a rostered basis typically 1 in 5.Main duties of the jobo Manage the BI Team's dedicated SQL Server Data warehouse, hosted on a pair of clustered physical servers, on a day to day basiso Monitor timed SSIS and TSQL Server agent tasks and act as needed in the event of issueso Act as the first point of contact for all stakeholders and either deal with any requests or pass them to other team members as requiredo Develop ad-hoc and regular reports in response to requests for datao Supply the NWLP Finance team and Partners with routine month-end datao Maintain key reference datasets with current datao Work flexibly as part of a teamAbout usBenefits 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-planNWLP InductionThe 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 2026Candidates are advised to consider these start dates before agreeing end of service date with their current employer.

DetailsDate posted20 August 2026Pay schemeAgenda for changeBandBand 7Salary 58,133 to 65,261 a year pa inclusive ContractPermanentWorking pattern Full-time Reference number290-NWLP-451Job locationsSt Mary's HospitalPraed StreetLondonW2 1NYUnited KingdomJob descriptionJob responsibilitiesThe 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. Job description Job responsibilitiesThe 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 EssentialFirst Degree. Microsoft managing an SQL Server Database CourseEvidence of ongoing personal and professional developmentT-SQL TrainingDesirableMicrosoft SQL Server Integration Services CourseMicrosoft SQL Server Reporting Services CourseScientific qualification or experience working in pathology or healthcare Skills/ abilities EssentialMicrosoft Excel and Microsoft Access (Intermediate)T-SQL (Structured Query Language) at a level to extract data from large complex databasesManaging an SQL Server 2019 instance and associated ServerGood analytical skills for spotting or anticipating weaknesses in processes (manual or system), along with the ability to organise and implement correction.

DesirableKnowledge of data warehouse design principlesExcellent understanding of NHS operational and Strategic issues, mandatory reporting requirements, NHS data standards and definitionsDeveloping SSRS Reports Experience EssentialGood understanding of technology and systems applicationsMetadata managementETL (Extract, Transform, and Load) knowledgeOLAP PrinciplesDesirableDemonstrable experience at a senior level in healthcare informatics management role.

Person Specification Education/ qualifications EssentialFirst Degree. Microsoft managing an SQL Server Database CourseEvidence of ongoing personal and professional developmentT-SQL TrainingDesirableMicrosoft SQL Server Integration Services CourseMicrosoft SQL Server Reporting Services CourseScientific qualification or experience working in pathology or healthcare Skills/ abilities EssentialMicrosoft Excel and Microsoft Access (Intermediate)T-SQL (Structured Query Language) at a level to extract data from large complex databasesManaging an SQL Server 2019 instance and associated ServerGood analytical skills for spotting or anticipating weaknesses in processes (manual or system), along with the ability to organise and implement correction.

DesirableKnowledge of data warehouse design principlesExcellent understanding of NHS operational and Strategic issues, mandatory reporting requirements, NHS data standards and definitionsDeveloping SSRS Reports Experience EssentialGood understanding of technology and systems applicationsMetadata managementETL (Extract, Transform, and Load) knowledgeOLAP PrinciplesDesirableDemonstrable experience at a senior level in healthcare informatics management role.

Disclosure and Barring Service CheckThis 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 SponsorshipApplications 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 (Opens in a new tab).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 (Opens in a new tab). Additional information Disclosure and Barring Service CheckThis 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 SponsorshipApplications 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 (Opens in a new tab).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 (Opens in a new tab).Employer detailsEmployer nameNorth West London PathologyAddressSt Mary's HospitalPraed StreetLondonW2 1NYUnited KingdomEmployer's websiteEmployer detailsEmployer nameNorth West London PathologyAddressSt Mary's HospitalPraed StreetLondonW2 1NYUnited KingdomEmployer's website

Report this job