South West London and St Georges Mental Health NHS Trust

Business Intelligence and Data Warehouse lead

Information:

This job is now closed

Job summary

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.

Main duties of the job

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. In this role you will be able to work flexibly throughout Monday to Friday around the core time frames from 10 to 4, giving you the very best of good work life balance.

About us

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.

Details

Date posted

14 February 2025

Pay scheme

Agenda for change

Band

Band 8b

Salary

£67,950 to £78,028 a year per annum inclusive of outer London HCAS

Contract

Permanent

Working pattern

Full-time

Reference number

294-CORP-7012020-JB-B

Job locations

Tolworth Hospital

Red Lion Rd

Surbiton

KT6 7QU


Job description

Job 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 Trusts 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 management.

Job description

Job 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 Trusts 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 management.

Person Specification

Training & Qualifications

Essential

  • Masters Level Degree or equivalent experience in database architecture, design and development.
  • Evidence of continuous professional development
  • PRINCE 2 or equivalent Project Management experience

Experience

Essential

  • Significant proven experience of implementing and developing business information systems tools within a large organisation.
  • Significant experience (5 years+) of designing and managing a SQL Server data warehouse, developing data feeds and working with complex data sets
  • Line management experience of highly technical staff.
  • Significant experience in a senior informatics role

Desirable

  • Experience of Business Information Systems and data sets in the NHS.
  • Experience of leading an information team in the Healthcare sector.

Knowledge & Skills

Essential

  • Detailed and expert Knowledge of the software delivery lifecycle in relation to physical data design and development.
  • Proven ability to lead a BI transformation project.
  • Detailed and expert Knowledge of enterprise architecture, and of the approaches, methods, and tools used.
  • Clear understanding and detailed working knowledge of data structures and data warehousing techniques
  • Expert level knowledge and experience of Microsoft SQL Server, Power BI

Desirable

  • Knowledge of data security and assurance in the NHS or public sector.
  • Good working knowledge of NHS datasets (patient, workforce, finance etc) and key metrics
Person Specification

Training & Qualifications

Essential

  • Masters Level Degree or equivalent experience in database architecture, design and development.
  • Evidence of continuous professional development
  • PRINCE 2 or equivalent Project Management experience

Experience

Essential

  • Significant proven experience of implementing and developing business information systems tools within a large organisation.
  • Significant experience (5 years+) of designing and managing a SQL Server data warehouse, developing data feeds and working with complex data sets
  • Line management experience of highly technical staff.
  • Significant experience in a senior informatics role

Desirable

  • Experience of Business Information Systems and data sets in the NHS.
  • Experience of leading an information team in the Healthcare sector.

Knowledge & Skills

Essential

  • Detailed and expert Knowledge of the software delivery lifecycle in relation to physical data design and development.
  • Proven ability to lead a BI transformation project.
  • Detailed and expert Knowledge of enterprise architecture, and of the approaches, methods, and tools used.
  • Clear understanding and detailed working knowledge of data structures and data warehousing techniques
  • Expert level knowledge and experience of Microsoft SQL Server, Power BI

Desirable

  • Knowledge of data security and assurance in the NHS or public sector.
  • Good working knowledge of NHS datasets (patient, workforce, finance etc) and key metrics

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

Additional information

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

South West London and St Georges Mental Health NHS Trust

Address

Tolworth Hospital

Red Lion Rd

Surbiton

KT6 7QU


Employer's website

https://www.swlstg.nhs.uk/ (Opens in a new tab)


Employer details

Employer name

South West London and St Georges Mental Health NHS Trust

Address

Tolworth Hospital

Red Lion Rd

Surbiton

KT6 7QU


Employer's website

https://www.swlstg.nhs.uk/ (Opens in a new tab)


Employer contact details

For questions about the job, contact:

Associate Director of Performance and Information

Jonathan Comfort

Jonathan.Comfort@swlstg.nhs.uk

02035135567

Details

Date posted

14 February 2025

Pay scheme

Agenda for change

Band

Band 8b

Salary

£67,950 to £78,028 a year per annum inclusive of outer London HCAS

Contract

Permanent

Working pattern

Full-time

Reference number

294-CORP-7012020-JB-B

Job locations

Tolworth Hospital

Red Lion Rd

Surbiton

KT6 7QU


Supporting documents

Privacy notice

South West London and St Georges Mental Health NHS Trust's privacy notice (opens in a new tab)