Senior BI & Data Warehouse DBA — Remote‑Ready Analytics Lead

Imperial College Healthcare NHS Trust; Greater London; On-site; GBP 70,000 - 95,000; Full time

Job summary

Imperial College Healthcare NHS Trust is seeking a Senior BI and Data Warehousing DBA to join a close-knit team delivering essential reports and real-time operational data to NWLP colleagues and partners.

The role is primarily based at St Mary’s Hospital, Paddington, with scope for remote work and occasional travel to partner sites. You will be the BI Team’s first point of contact on a weekly rotation and support end-of-month data processes.

Qualifications

• Senior BI and Data Warehousing DBA responsible for managing BI team warehouse and delivering management, financial and clinical reports.
• First point of contact for the BI Team on a weekly rota, liaising with stakeholders.
• Role based primarily at St Mary’s Hospital with potential travel to partner sites; open to remote working.

Responsibilities

• Manage the BI Team’s SQL Server Data warehouse and clustered servers.
• Monitor SSIS and TSQL Server Agent tasks and resolve issues.
• Be the first point of contact for stakeholders and triage data requests.
• Develop ad-hoc and regular reports for data requests.
• Supply routine month-end data to NWLP Finance and Partners.
• Maintain reference datasets with current data.
• Collaborate flexibly as part of a team.

Skills

BI / Data warehousing

SQL Server

SSIS

SQL Server Agent

T-SQL

Tools

SQL Server

SSIS

Power BI

Job description

Imperial College Healthcare NHS Trust is seeking a Senior BI and Data Warehousing DBA to join a close-knit team delivering essential reports and real-time operational data to NWLP colleagues and partners.

The role is primarily based at St Mary’s Hospital, Paddington, with scope for remote work and occasional travel to partner sites. You will be the BI Team’s first point of contact on a weekly rotation and support end-of-month data processes.