Senior Business Intelligence and Data Warehousing DBA
At a glance
- Band
- Band 7
- Contract
- Fixed-term
- Pattern
- Full-time
- Posted
- 20/08/2026
- Closes
- 03/09/2026
Sponsorship verdict
Candidates needing sponsorship are encouraged to apply.
HiveMind found a sponsorship-friendly statement in the source advert welcoming applicants who require a visa. Always confirm on the source before applying.
“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.”Quoted verbatim from the source advert
Role summary
This role involves managing and maintaining the Business Intelligence Team's SQL Server Data warehouse and associated tasks. You will be the first point of contact for the BI Team on a rotational basis, interacting with various stakeholders. The position requires developing ad-hoc and regular reports and supplying routine month-end data to the Finance team and Partners. While primarily based at St Mary's Hospital, remote working options are available.
Essential criteria
- First Degree.
- Microsoft managing an SQL Server Database Course
- Evidence of ongoing personal and professional development
- T-SQL Training
Desirable criteria
- 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
- 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.
- 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
- 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.
Useful to know
Agenda for Change 2024/25 pays Band 7 at £46,148 – £52,809 a year, across England.
This advert: £49,387 – £56,515 — outside the standard scale; check for HCAS/London weighting.
Posted 10d ago · Closes in 5d
Plenty of time to prepare a strong application.
Full advert · preview
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 o
Join the community to read the full pack, responsibilities and person-specification in one place.
Your seat is reserved — activate it
CareerHive is included with your CareerHive Skool community membership. If you haven't claimed your account yet, join the community (or sign in with the same email you joined with) to unlock the full advert, the apply link, HiveMind AI interview & application suite, your private vault, and daily sponsorship alerts.