Business Intelligence and Systems Lead

Tavistock & Portman NHS Foundation Trust
£58,698 to £65,095 a year per annum inclusive HCAS
Closing date
12 Jun 2023

View more

Other Health Profession
Band 8A
Contract Type
Full Time
The post holder will lead and develop the information management and analysis function within the directorate that supports decision-making within the Tavistock and Portman NHS Foundation Trust.

The post holder will play a significant role in contributing to the strategic development of information functions to maximise benefits to the organisation.

A number of exciting business intelligence (BI) projects are being carried out within the IM& T directorate and many more are in the roadmap. Successful candidate will be leading relevant technical functions in those projects, which will ultimately make significant contribution to the patient care the Trust provides.

Main duties of the job

The post holder will be expected to lead, influence, and negotiate to drive forward the development of business intelligence processes, functions, tools, lead, train and assist the wider informatics team to develop technical solutions for reporting requirements, including automation of reports and processes, and the use of data visualization tools such as Power BI, or similar tools.

As a member of the Transformation Directorate and operating across all functional teams making up the directorate, including Information and Communications Technology (ICT), Informatics, Estates & Facilities (E& F) as well as Information Governance & Security, the Business Intelligence (BI) and Systems Lead will be responsible for managing Systems and BI Reporting functions in the Trust covering both our clinical and education activities.

About us

The Tavistock and Portman NHS Foundation Trust is a specialist mental health trust with a focus on training and education alongside a full range of mental health services and psychological therapies for children and their families, young people and adults. With 500 staff across a number of sites, we are committed to improving mental health and emotional wellbeing, believing that high quality mental health services should be available for all who need them. We bring a distinctive contribution based on the importance we attach to social experience at all stages of people's lives, and our focus on psychological and developmental approaches to the promotion of health and the prevention and treatment of mental ill health.

Job description

Job responsibilities

The post holder will lead on the development of the Trust data warehouse, including all phases of planning, designing, development, training and roll out to the Trust Directorates.

The data warehouse to act as central data repository and will take datafeeds from various Trust systems such as Clinical Systems, Student Education Systems (SITS), HR, Finance, Data Quality and other information systems to support Trust wide reporting.The post holder will be responsible for managing the Data Warehouse, and where required, supporting other SQL based systems and Power BI reporting solutions. Responsibilities include ensuring that the data model, data loading, and information reporting is reliable, and that internal and external deadlines are consistently met.

Remote working:

The Informatics team is currently operating remotely. But team members are required to come on site if required or decided by the management.

Interview & technical test:

There will be a 20/30-minute technical test comprising of advanced SQL, Power BI and Data warehouse related questions.

Interview will be conducted via MS Teams or Zoom. We will confirm the date and interview link in due time.

Person Specification



  • Good academic background. Educated to master level in a similar subject or equivalent experience.
  • Evidence of continuous professional development i.e., attending short courses (SQL, SQL Reporting Services, XML, Java Script), and self-study.

Previous Experience


  • oPrevious demonstrable Business Intelligence, Data Warehouse or DBA experience
  • Current working knowledge and experience of using SQL and Business Objects
  • oPrevious demonstrable experience operating in an analyst capacity in a technical environment
  • oExperience of the whole project life-cycle and a structured project management methodology


  • Experience of NHS Information provision, local and national requirements



  • Be a fluent and effective communicator at all levels.
  • Skilled negotiator able to develop relationships and manage stakeholders within IT, the business and IT third parties
  • Excellent understanding of data modelling, report development, performance tuning and query optimisation techniques


  • Development of strategic plans



  • oExpert Knowledge of Business Intelligence and Data Warehouse tools and concepts
  • oITIL principles and procedures.

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.

Certificate of Sponsorship

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) .

Employer details

Employer name

Tavistock and Portman NHS Foundation Trust


Tavistock Centre



Any attachments will be accessible after you click to apply.


Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert