Lead Business Intelligence Analyst

Job Advert Skip to main content

document.body.className = ((document.body.className) ? document.body.className + ' js-enabled' : 'js-enabled');

Cookies on NHS Jobs

We've put some small files called cookies on your device to help us make improvements to our site.

To improve our site we'd also like to use cookies which will send information to Google Analytics. You can read more about our cookies before you choose.

Accept analytics cookies Do not accept analytics cookies

Jobs

Menu

• Sign in
• Create an account

• English
• Cymraeg

Menu Close menu

• Search
• Sign in
• Create an account
• Display in Welsh (Cymraeg)

• Search
• Sign in
• Create an account
• Display in Welsh (Cymraeg)

BETA Your feedback will help us to improve this service.

Royal Papworth Hospital NHS Foundation Trust Lead Business Intelligence Analyst

The closing date is 19 November 2026

Apply for this job

Job summary

Royal Papworth Hospital is looking for an experienced Lead Business Intelligence Analyst to join their Business Intelligence Team. The team is responsible for a wide range of information analysis relating to patient information, business and performance management indicators and clinical and data quality issues. The Team is integral to the Trust's performance management framework and it's specialist knowledge plays an important part in operational decision-making.

The role sits within the Finance Directorate and will work closely with the Digital Directorate to deliver the requirements of the role and to deliver increasing collaboration between the two teams.

Main duties of the job

The Lead Business Intelligence Analyst will be responsible for providing external and internal customers business intelligence reports designed to support and deliver the Trust's objectives. The post holder will be responsible for improving and innovating reports to fully exploit data rich clinical systems and providing interpretive analytics and commentary. The Lead will need to have expertise in specific areas but will also be expected to understand all areas of activity and support others to complete their tasks and improve reporting processes. The post holder will be expected to lead some development of extracts, reports, dashboards and help end-users of the report to analyse and interpret the information.

About us

Royal Papworth Hospital NHS Foundation Trust is the UK's leading heart and lung hospital, delivering care to more than 50,000 patients a year in its new state-of-the-art hospital in Cambridge. We perform the most heart and/or lung transplants in the UK and carried out the UK's first successful heart transplant in 1979. It also offers emergency heart attack treatment, sleep centre care and is one of just five centres nationally for those in severe respiratory failure.

Based on the Cambridge Biomedical Campus the largest centre of medical research and health science in Europe the Trust is at the heart of treatments of the future. Royal Papworth became the first hospital trust in the country to be rated outstanding in all five areas assessed by the Care Quality Commission - a rating it still holds today. The Trust holds its values of compassion, excellence & collaboration at its core, and all colleagues joining the team are expected to uphold these in their day-to-day roles & interactions. Royal Papworth is proud of its diverse workforce and encourages people to embrace their individuality.

The Trust values difference and welcomes all applications irrespective of age, disability, gender reassignment, marriage and civil partnership, pregnancy & maternity, race, religion & belief, sex and sexual orientation. Providing they meet the minimum post criteria, applicants with disabilities will be offered an interview.

For a street view tour: https://royalpapworth.nhs.uk/virtual-tour

Details

Date posted

06 November 2026

Pay scheme

Agenda for change

Band

Band 7

Salary

£49,387 to £56,515 a year

Contract

Fixed term

Duration

16 months

Working pattern

Full-time

Reference number

175-2627-2008

Job locations

Royal Papworth Hospital

Papworth Road

Cambridge Bio Medical Campus

Cambridge

CB2 0AY

United Kingdom

Kingfisher House, Huntingdon

Kingfisher Way, Hinchingbrooke Business Park

Huntingdon

Cambridge

PE29 6FH

United Kingdom

Job description

Job responsibilities

On this page you will find a Role Profile which provides information about the hospital and full details about the role. We recommend that you review this and refer to it as you complete your application. Please include how you will meet the Trust Values Compassion, Excellence and Collaboration. If you would like more information about the role or working at Royal Papworth Hospital, please get in touch with the contact for this role.

Job description

Job responsibilities

On this page you will find a Role Profile which provides information about the hospital and full details about the role. We recommend that you review this and refer to it as you complete your application. Please include how you will meet the Trust Values Compassion, Excellence and Collaboration. If you would like more information about the role or working at Royal Papworth Hospital, please get in touch with the contact for this role.

Person Specification

Qualifications

Essential

• Educated to degree level in relevant discipline or equivalent professional and management experience.

Desirable

• Evidence of further CPD

Experience

Essential

• Experience of statistical or analytical work in health or social care taking responsibility for developing and delivering a wide range of analysis
• Experience of NHS acute Trust computer/information systems (Data warehouse, PAS).
• Experience of activity modelling, waiting list profiling and capacity planning.
• Detailed knowledge of the NHS data dictionary and its application.
• Knowledge of Data Quality and its implications
• Experience in the use of Business Intelligence tools for reporting, e.g. Qlikview/Sense, Power BI, Tableau, SSRS, etc
• Business Intelligence
• Highly developed analytical and problem solving skills and is capable of interpreting and evaluating complex, multi-faceted information;
• Can extract the key points from diverse and complex sets of information;
• Ability to present highly complex information to a wide range of audiences, with differing levels of understanding, in a suitable format and with appropriate explanation;
• Understands and is able to demonstrate the importance of well-designed processes to achieve standards;
• Focused on delivering value to users in a way that meets their needs;
• Excellent IT skills in both Excel and PowerPoint;
• Planning and organisation
• Has good organisation skills, including the ability to juggle competing priorities and tight deadlines;
• Possess the ability to plan the achievement of goals, tasks or projects for themselves and others
• Personal and Leadership
• Possess strong interpersonal skills and ability to forge effective and collaborative professional relationships both internally and externally;
• Must be able to provide and receive complex, sensitive or contentious information, negotiate with stakeholders on difficult and controversial issues, and present complex and sensitive information to others;
• Effectively communicates to ensure projects are prioritised effectively and expectations are managed.
• Has a continuous improvement mindset and is able to learn from previous mistakes to improve outputs;
• Well developed leadership skills with the ability to motivate others not necessarily directly reporting to this role
• Can clarify complex situations and support strategy development in own area;
• Experience of coaching and mentoring less experienced information analysts in the performance of their assigned duties

Desirable

• Ability to write detailed analytic queries in SQL, investigate and resolve complex queries, issues and problems.
• Experience in acute RTT/Cancer/Diagnostics Reporting
• Knowledge of and ability to utilise statistical reporting solutions such as `R` and `SPSS`
• Experience of leading a team.
• Able to demonstrate an ability to move between the detail and the big picture;
• Knowledge and understanding of NHS data flows and data sets available within the NHS, including knowledge of the NHS Data Dictionary, currencies of healthcare commissioning, coding and information systems within the NHS;
• Experience of working with databases, especially Microsoft SQL Server;
• Experience of building reporting dashboards in Qlikview
• Coaching and mentoring others with analytical tasks

Additional Criteria

Essential

• As well as being able to demonstrate examples of how they work in a way that is consistent with our values of compassion, excellence and collaboration the successful candidate will be able to clearly demonstrate a commitment to driving culture change through equality, diversity and inclusion.
• Good levels of concentration when analysing information and/or writing reports and faced with interruptions to answer queries.

Desirable

• Enthusiastic and passionate about analytics and value-added information provision.

Person Specification

Qualifications

Essential

• Educated to degree level in relevant discipline or equivalent professional and management experience.

Desirable

• Evidence of further CPD

Experience

Essential

• Experience of statistical or analytical work in health or social care taking responsibility for developing and delivering a wide range of analysis
• Experience of NHS acute Trust computer/information systems (Data warehouse, PAS).
• Experience of activity modelling, waiting list profiling and capacity planning.
• Detailed knowledge of the NHS data dictionary and its application.
• Knowledge of Data Quality and its implications
• Experience in the use of Business Intelligence tools for reporting, e.g. Qlikview/Sense, Power BI, Tableau, SSRS, etc
• Business Intelligence
• Highly developed analytical and problem solving skills and is capable of interpreting and evaluating complex, multi-faceted information;
• Can extract the key points from diverse and complex sets of information;
• Ability to present highly complex information to a wide range of audiences, with differing levels of understanding, in a suitable format and with appropriate explanation;
• Understands and is able to demonstrate the importance of well-designed processes to achieve standards;
• Focused on delivering value to users in a way that meets their needs;
• Excellent IT skills in both Excel and PowerPoint;
• Planning and organisation
• Has good organisation skills, including the ability to juggle competing priorities and tight deadlines;
• Possess the ability to plan the achievement of goals, tasks or projects for themselves and others
• Personal and Leadership
• Possess strong interpersonal skills and ability to forge effective and collaborative professional relationships both internally and externally;
• Must be able to provide and receive complex, sensitive or contentious information, negotiate with stakeholders on difficult and controversial issues, and present complex and sensitive information to others;
• Effectively communicates to ensure projects are prioritised effectively and expectations are managed.
• Has a continuous improvement mindset and is able to learn from previous mistakes to improve outputs;
• Well developed leadership skills with the ability to motivate others not necessarily directly reporting to this role
• Can clarify complex situations and support strategy development in own area;
• Experience of coaching and mentoring less experienced information analysts in the performance of their assigned duties

Desirable

• Ability to write detailed analytic queries in SQL, investigate and resolve complex queries, issues and problems.
• Experience in acute RTT/Cancer/Diagnostics Reporting
• Knowledge of and ability to utilise statistical reporting solutions such as `R` and `SPSS`
• Experience of leading a team.
• Able to demonstrate an ability to move between the detail and the big picture;
• Knowledge and understanding of NHS data flows and data sets available within the NHS, including knowledge of the NHS Data Dictionary, currencies of healthcare commissioning, coding and information systems within the NHS;
• Experience of working with databases, especially Microsoft SQL Server;
• Experience of building reporting dashboards in Qlikview
• Coaching and mentoring others with analytical tasks

Additional Criteria

Essential

• As well as being able to demonstrate examples of how they work in a way that is consistent with our values of compassion, excellence and collaboration the successful candidate will be able to clearly demonstrate a commitment to driving culture change through equality, diversity and inclusion.
• Good levels of concentration when analysing information and/or writing reports and faced with interruptions to answer queries.

Desirable

• Enthusiastic and passionate about analytics and value-added information provision.

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.

Employer details

Employer name

Royal Papworth Hospital NHS Foundation Trust

Address

Royal Papworth Hospital

Papworth Road

Cambridge Bio Medical Campus

Cambridge

CB2 0AY

United Kingdom

Employer's website

https://royalpapworth.nhs.uk/working-here (Opens in a new tab)

Employer details

Employer name

Royal Papworth Hospital NHS Foundation Trust

Address

Royal Papworth Hospital

Papworth Road

Cambridge Bio Medical Campus

Cambridge

CB2 0AY

United Kingdom

Employer's website

https://royalpapworth.nhs.uk/working-here (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Hiring Manager

Elizabeth Ellar

[email protected]

01223638000

Details

Date posted

06 November 2026

Pay scheme

Agenda for change

Band

Band 7

Salary

£49,387 to £56,515 a year

Contract

Fixed term

Duration

16 months

Working pattern

Full-time

Reference number

175-2627-2008

Job locations

Royal Papworth Hospital

Papworth Road

Cambridge Bio Medical Campus

Cambridge

CB2 0AY

United Kingdom

Kingfisher House, Huntingdon

Kingfisher Way, Hinchingbrooke Business Park

Huntingdon

Cambridge

PE29 6FH

United Kingdom

Supporting documents

Privacy notice

Royal Papworth Hospital NHS Foundation Trust's privacy notice (opens in a new tab)

Support links

• Privacy policy
• Terms and conditions
• Accessibility Statement
• Cookies
• Help and guidance

© Crown copyright