Lead Business Intelligence Analyst

Royal Papworth Hospital NHS Foundation Trust; Cambridge; On-site; GBP 60,000 - 70,000; Full time

Job summary

Royal Papworth Hospital NHS Foundation Trust is seeking a Lead Business Intelligence Analyst to join the BI Team in Cambridge. You will deliver BI reports and dashboards to support patient, business and performance management decisions, and lead reporting development across clinical and data quality areas.

The role sits in the Finance Directorate, collaborating with the Digital Directorate to enhance cross-team analytics and reporting processes.

Qualifications

• Educated to degree level in a relevant discipline or equivalent professional and management experience.
• 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).
• Knowledge of Data Quality and its implications; Experience in the use of Business Intelligence tools for reporting (Power BI, Qlikview/Sense, SSRS).

Responsibilities

• Provide external and internal customers BI reports to support Trust objectives.
• Lead development of extracts, reports, dashboards and improve reporting processes.
• Offer interpretive analytics and commentary on data.
• Collaborate with Finance and Digital Directorates to deliver reporting solutions.

Skills

Statistical analysis

NHS data systems

Power BI

Qlikview/Sense

SQL

Excel

PowerPoint

Leadership

Stakeholder management

Data visualization

Education

Degree in relevant discipline

CPD

Tools

Microsoft SQL Server

SSRS

R

SPSS

Job description

Royal Papworth Hospital NHS Foundation Trust

Lead Business Intelligence Analyst

The closing date is 19 November 2026

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

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

• Educated to degree level in relevant discipline or equivalent professional and management experience.
• Evidence of further CPD

Experience

• 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
• 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
• 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

• 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.
• 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 name

Royal Papworth Hospital NHS Foundation Trust

Kingfisher Way, Hinchingbrooke Business Park