Business Intelligence and Data Warehouse lead

South West London and St Georges Mental Health Trust
City of London
2 days ago
Create job alert

A Vacancy at South West London and St George's Mental Health NHS Trust.


An exciting opportunity has arisen within the Trust’s Performance and Information Team for an experienced senior informatics professional to play a key role in the ongoing development and transformation of the Trust’s data warehouse and Business Intelligence solutions.


We are seeking a passionate and forward-thinking individual with a proven track record of driving improvements in Business Intelligence. The ideal candidate will have extensive experience in Microsoft SQL Server for data warehouse development and the administration of an enterprise-level Business Intelligence platform, such as Tableau.


This is a fantastic opportunity for a skilled informatics professional to make a significant impact within the Trust. If you are passionate about Business Intelligence and eager to drive meaningful change, we encourage you to apply.


Please note this role does not offer sponsorship.


This role will have an assessment as part of the interview process to help fully assess candidates’ suitability for the post, which takes place in form of an interactive presentation to senior stakeholders at Trust premises (on-site), with the topic and exercise given on the day, and cannot be done remote.


The successful candidate will provide technical leadership for the Trust’s Information Management team, serving as an authoritative source of expertise. A key aspect of this role involves enhancing existing solutions and scripts to optimize efficiency and accuracy, as well as conducting peer reviews of code through a structured change control process.


Working closely with the Associate Director of Performance and Information and the team’s Principal Analyst, the post holder will contribute to shaping the future direction of the team and its strategic developments.


Flexible Working

We are proud to offer agile and flexible working opportunities as part of our new ways of working, and we are happy to talk flexible working at the interview stage. The team operate a hybrid working arrangement whereby we utilise home working alongside mandatory office days each week.


We are Proud to Belong at South West London and St George’s Mental Health NHS Trust.


We have expert services, a rich history and a clear commitment to providing the best quality care for those with mental ill-health. The Care Quality Commission already rates our services as ‘good’ - we aspire to be ‘outstanding’.


This is a great time to join us. We are transforming the way we care for our communities to support our mission of Making Life Better Together. We have built two brand new mental health facilities at Springfield University Hospital, which are amongst the best in the world. More developments are planned across our sites and services.


We are inclusive and diverse and strive to be actively anti racist. We want to attract people from all backgrounds and experiences to enrich the work we do together. We are proud to co-produce and involve our local communities in all that we do.


We offer flexible working, career development and a variety of benefits to enable a positive, welcoming environment in which our people and their careers can thrive.


Come and join our inclusive teams and help our patients on their recovery journey.


Key Responsibilities

  1. Provide support as the ‘subject matter expert’ in the determination of Trust data and business information system requirements; offering detailed advice on data collection, management and reporting strategies. This will involve working collaboratively with stakeholders to understand highly complex issues, provide highly technical solutions and support for interpreting and resolving highly complex data set reporting requirements, often without precedent, or with conflicting options.
  2. Develop and implement ‘cutting edge’ business intelligence tools which may not be being used by any other NHS organisations to deliver the Trust’s Digital Strategy and service transformation programmes.
  3. Responsible for the development and operation of multiple and business critical Trust wide business intelligence systems.
  4. Provide authoritative expert information to senior staff including executives, guidance, and advice on all matters pertaining to the design, development, implementation, and support of the trust data warehouse.
  5. Be the driving force behind the adoption of new data technologies in the organisation.
  6. Ensure the development and delivery of integrated performance dashboards (using data from multiple Trust systems) to support effective performance management and decision making for all staff across the Trust.
  7. Line manage the Information Management and business Intelligence development team to provide mentoring, staff development, appraisal to ensure all resources are deployed to maximise efficiency and quality of delivery.
  8. Design Trust wide systems to Identify data quality issues and manage strategies to resolve them.
  9. Design and develop data schemas using Microsoft SQL Server and associated technologies such as Python – the post holder shall have expert level knowledge of SQL.
  10. Be able to demonstrate an ability through previous experience of administering an enterprise level Business Intelligence software, such as Tableau Server.
  11. Provide a DBA function to the Business Intelligence team, by fine tuning queries and implementing a change management approach.
  12. Be familiar with and be an expert in all phases of the Software Development Life Cycle.
  13. Liaise and work closely with the IT Modernisation team to maintain, develop and enhance infrastructure supporting BI.
  14. Update and maintain the detailed functional and technical system specifications of data warehouse and BI platform.
  15. Keep up to date on industry best practice, frameworks, methods and tools relating to the design, development, implementation and support of data warehouses, and data.

This advert closes on Wednesday 14 Jan 2026.


#J-18808-Ljbffr

Related Jobs

View all jobs

Business Intelligence and Data Warehouse lead

BI & Data Warehouse Developer | Global Data Platform

BI & Data Warehouse Developer — Elevate Analytics

Data Engineering Manager

Principal Data Engineer FTC | Chelsea and Westminster Hospital NHS Foundation Trust

Principal Data Engineer FTC...

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Science Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.