Lead Business Intelligence Analyst

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

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
  • Evidence ability to uphold the Trust's values Compassion Excellence Collaboration.
  • Good levels of concentration when analysing information and/or writing reports and faced with interruptions to answer queries;
  • Ability to concentrate for long periods on complex data analysis.
  • Highly organised, with a structured and logical approach to planning and prioritising workload;
  • Provide leadership support to others, displaying good behaviours and coaching and expecting good practice from members of the team
  • Capable of working on own initiative and able to meet deadlines;
  • Adaptability, flexibility and ability to cope with uncertainty and change;
  • High attention to detail.
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


Employer's website

https://royalpapworth.nhs.uk/working-here


Company
Royal Papworth Hospital NHS Foundation Trust
Location
Cambridge Bio Medical Campus, United Kingdom CB2 0AY
Employment Type
Permanent
Salary
£46148.00 - £52809.00 a year
Posted
Company
Royal Papworth Hospital NHS Foundation Trust
Location
Cambridge Bio Medical Campus, United Kingdom CB2 0AY
Employment Type
Permanent
Salary
£46148.00 - £52809.00 a year
Posted