Business Intelligence BI Analyst

Northamptonshire Healthcare Foundation Trust

Information:

This job is now closed

Job summary

Northamptonshire Healthcare NHS Foundation Trust (NHFT) are looking to recruit a BI Analyst, to work within the Business Intelligence Service, which is responsible for performance improvement and contract management of existing services, and provision of reporting functionality to support operational management of clinical services.

The Trust are aiming to use Power BI to provide interactive visualisations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators. Core to this is the function of improving, maintaining and administrating both the Trusts Data Warehouse, and the associated Power BI reporting systems, where the position holder will be expected to utilise their advanced level SQL & Power BI skills to manage both routine and ad-hoc processes and developments within the current framework.

Main duties of the job

  • Develop essential reporting systems to support the trust's future BI Systems Project.
  • Provide expertise in developing, using and the day-to-day BAU support of Power BI, SQL & the Trust's Data Warehouse.
  • Provide direct training and user-support for all system users.
  • Initiate investigation of new data quality issues raised by the Business Intelligence Service, to understand and document the source, the scope and the seriousness of each issue, and manage potential risks.
  • Provide technical support to DQ & Compliance Manager, BI Information Analyst and DQ Facilitators, delivering in-depth reporting and analysis, which enables them to fulfil their roles.
  • Provide direct support to members of the Business Intelligence Service, providing information to support reporting to Operational Managers & Leads.
  • Maintain an expert knowledge of the Trust's PAS system SystmOne, and an in depth understanding of how its data is interpreted within Trust's Data-Warehouse in relation to reporting and data extraction.
  • Become proficient in understanding of how the Trust's Data Warehouse works, and the implications of changes, both from an Operational and Business Intelligence point of view.
  • Provide expert support and knowledge in the identification, validation, collation and analysis of information and data from a number of different sources.
  • To adhere to all appropriate Trust policies and procedures in relation to current role within the Trust

About us

NHFT is an integrated primary care and mental health Trust, providing physical, mental health and specialty services in both hospital settings and out in the community. Because we put the person at the centre of all we do, we focus on delivering care that is as easy to access as possible. This means many of our services can be provided at home, work or in schools.We also provide health services to various prisons and detention centres in Bedfordshire and Cambridgeshire.

NHFT promotes a culture of learning to improve the care and safety of our patients and staff, which focuses on people who enable our Trust to be 'outstanding' by supporting opportunity, innovation, development and growth.

Date posted

11 June 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

270-TF150-CORP

Job locations

St Marys

London Road

Kettering

NN15 7PW


Job description

Job responsibilities

For further information on the advertised role, please refer to the job description located under the Supporting Documents heading. The full person specification can be accessed under the About You Section of the document.

Job description

Job responsibilities

For further information on the advertised role, please refer to the job description located under the Supporting Documents heading. The full person specification can be accessed under the About You Section of the document.

Person Specification

Qualifications

Essential

  • Degree level qualification (or relevant experience)
  • Post graduate diploma or specialist qualification (or equivalent experience)
  • Evidence of Continued Professional Development

Desirable

  • Product Lifecycle Management & Improvement Tools (e.g. PRINCE2/Agile/QSIR)

Personal attributes and abilities

Essential

  • Enthusiastic, motivated, autonomous as well as being a good team leader
  • Able to engage with a variety of people, including those within identified Team, and those in external agencies
  • Able to use own initiative and make decisions independently
  • Committed to continual quality and service improvement
  • Self-aware and committed to professional and personal development
  • Flexible and proactive attitude

Experience

Essential

  • Ability to capture and translate business requirements
  • Ability to create effective and meaningful dashboards and reports that support decision making across the Trust
  • Experience of using Power BI/Power Query/DAX
  • Proven experience of working with multiple senior stakeholders to build relationships and communication channels
  • Experience of delivering effective training and providing user support to non-technical staff and colleagues
  • Application of analytical techniques and tools to solve business problems

Desirable

  • Experience of working in a health or social care environment

Knowledge

Essential

  • Understanding of the local NHS structure, strategy, vision and policy

Desirable

  • Highly developed, in-depth specialist knowledge, underpinned by theory and professional experience of disciplines including technical development over an extended period
Person Specification

Qualifications

Essential

  • Degree level qualification (or relevant experience)
  • Post graduate diploma or specialist qualification (or equivalent experience)
  • Evidence of Continued Professional Development

Desirable

  • Product Lifecycle Management & Improvement Tools (e.g. PRINCE2/Agile/QSIR)

Personal attributes and abilities

Essential

  • Enthusiastic, motivated, autonomous as well as being a good team leader
  • Able to engage with a variety of people, including those within identified Team, and those in external agencies
  • Able to use own initiative and make decisions independently
  • Committed to continual quality and service improvement
  • Self-aware and committed to professional and personal development
  • Flexible and proactive attitude

Experience

Essential

  • Ability to capture and translate business requirements
  • Ability to create effective and meaningful dashboards and reports that support decision making across the Trust
  • Experience of using Power BI/Power Query/DAX
  • Proven experience of working with multiple senior stakeholders to build relationships and communication channels
  • Experience of delivering effective training and providing user support to non-technical staff and colleagues
  • Application of analytical techniques and tools to solve business problems

Desirable

  • Experience of working in a health or social care environment

Knowledge

Essential

  • Understanding of the local NHS structure, strategy, vision and policy

Desirable

  • Highly developed, in-depth specialist knowledge, underpinned by theory and professional experience of disciplines including technical development over an extended period

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

Northamptonshire Healthcare Foundation Trust

Address

St Marys

London Road

Kettering

NN15 7PW


Employer's website

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


Employer details

Employer name

Northamptonshire Healthcare Foundation Trust

Address

St Marys

London Road

Kettering

NN15 7PW


Employer's website

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


For questions about the job, contact:

Data Quality and Compliance Manager

Rachel Hill

rachel.hill@nhft.nhs.uk

07753317382

Date posted

11 June 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

270-TF150-CORP

Job locations

St Marys

London Road

Kettering

NN15 7PW


Supporting documents

Privacy notice

Northamptonshire Healthcare Foundation Trust's privacy notice (opens in a new tab)