Job Title: Senior Business Intelligence and Data Warehousing
Agency: North West London Pathology
Location: London, United Kingdom
Salary/Rate: 58,133 – 65,261 £ / Year
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.
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 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
Person Specification
Education/ qualifications
Essential
- First Degree.
- Microsoft managing an SQL Server Database Course
- Evidence of ongoing personal and professional development
- T-SQL Training
Desirable
- Microsoft SQL Server Integration Services Course
- Microsoft SQL Server Reporting Services Course
- Scientific qualification or experience working in pathology or healthcare
Skills/ abilities
Essential
- 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.
Desirable
- 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
Essential
- Good understanding of technology and systems applications
- Metadata management
- ETL (Extract, Transform, and Load) knowledge
- OLAP Principles
Desirable
- 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.
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 (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).
Closing Date: 03 September 2026
How to Apply;
Interested and qualified candidates should:
Click here to apply online for this job
Scam Warning: Please take note that the employees at Easyinfoblog.com will never get in touch with you or ask you to do so in order to deal, help, or make a payment. A scammer is anyone who claims to be representing us in this way.
Note: The sole purpose of this article is to provide information. We are not agents for Visas. Beyond posting openings, we don’t offer any kind of support. Vacancies given on this website are obtained from the Internet. Please check the genuineness of the companies you are applying to while proceeding with the application.
6
Author: Simon RobertEasyInfoBlog is a multi-author blog. We have experts and professionals in various fields who share their ideas and expert knowledge to help you with your daily information needs. Thanks for reading!