Senior Business Intelligence and Data Warehouse Manager

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.

The Team will also be providing night and weekend cover for the BI service issues affecting live data on a Standby and Callout remuneration basis. This role will include being part of this in a 1 in 4 weekly rota. Night calls are extremely rare but 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.

Main duties of the job

As a Senior Business Intelligence and Data Warehousing DBA you will work as part of the BI Team and interact directly with NWLP colleagues partners and clients at all levels to ensure that the Team continually provides timely, meaningful and accurate data which may be operational, managerial, financial or clinical.

We aere looking for candidates who will:

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.

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 2023, see below the start dates which you will be able to book once you have completed all your pre-employment checks.

• Monday 8 April 2024
• Monday 13 May 2024
• Monday 3 June 2024
• Monday 1 July 2024
• Monday 5 August 2024
• Monday 2 Sept 2024
• Monday 7 October 2024
• Monday 4 November 2024
• Monday 2 December 2024

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