Portfolio Insight and Reporting Specialist

Job Summary

Are you an organised and pro-active individual that thrives on extracting, analysing and presenting complex data to internal and external customers? If so, our Portfolio Insight and Reporting Specialist role may be for you. Central to this crucial role is delivering analytical products including highly complex modelling to support reporting of high quality management information and insight that enable NHSBSA business decisions. You will create complex datasets using a variety of business intelligence tools and present highly sensitive data to internal and external stakeholders. You will provide expert analysis to support business improvements that contribute to the NHS Business Service Authority\’s (NHSBSA) strategic goals. To thrive in this role, you\’ll be a confident and personable professional with the ability to communicate well at all levels.

You\’ll join a great team with varied and exciting work on offer.

What do we offer?

• 27 days leave (increasing with length of service) plus 8 bank holidays
• Flexible working (we are happy to discuss options such as compressed hours)
• Flexi time
• Hybrid working model (we are currently working largely remotely)
• Career development
• Active wellbeing and inclusion networks
• Excellent pension
• NHS Car lease scheme
• Access to a wide range of benefits and high street discounts!

Main duties of the job

Insight: Take ownership for the creation and maintenance of analysis, reports and dashboards that support Portfolio delivery across functions and decision making across the NHSBSA, working with specific teams and business areas as required. The post holder will be an expert in advanced analytics with the ability to collate and evaluate quantitative and qualitative data using appropriate query tools for reporting and modelling.

Reporting: Communicate and present highly complex and sensitive data and analysis effectively at all levels to both internal and external stakeholders, ensuring information is accurate, accessible and understandable to a wide audience. The post holder will deliver a timely and targeted suite of reports and dashboards that analyse trends, show data comparisons and provide appropriate statistical business performance information.

Stakeholder Management & People: Work collaboratively with a diverse range of customers and users within the organisation at all levels to define and develop new products that create added value management information to leaders, managers and colleagues. The post holder will support the Portfolio Office Manager to communicate and build commitment to a shared data and reporting vision and sense of purpose across the Portfolio Management Directorate.

About Us

Here at the NHS Business Services Authority (NHSBSA), what we do matters.

We manage the NHS Pension scheme, process prescription payments and much more. Our services are used by NHS organisations, contractors and the public: we’re proud to be part of something meaningful, that touches millions of lives.

We design our services around customer needs and place people at the heart of our organisation. That’s why when you join us, you’ll be empowered and supported to help your career grow.

As one of the UK’s Best Big Companies to work for, we’re connected to our values: Collaborative, Adventurous, Reliable and Energetic. We care about our people, our purpose, and your progress.

We strive to offer a fantastic colleague experience, where every colleague is heard, supported and respected. Wellbeing, diversity and inclusion is at the centre of this, and you can join our Lived Experience Networks who help us bring our authentic selves to work.

We’re committed to being a flexible employer and we try to offer a working pattern that suits you where possible, through hybrid working, flexible hours and more.

Alongside a competitive salary with pay progression, we offer a people-centric benefits package, connecting you to the rewards and benefits you value most!

Ready to join us in delivering business service excellence to the NHS, helping people live longer, healthier lives? Apply today and see where the NHSBSA can take you.

We are people connected to care.

Job Description

In this role, you are accountable for

Insight

• Handling and creating highly complex datasets by using business intelligence tools, raw data, SQL queries and data mining techniques to clean, process, interrogate, analyse, and visualise data in an effective and informative manner in the most efficient way possible.
• Conducting expert and advanced analysis and develop methods to collect, collate and evaluate quantitative and qualitative highly complex data using appropriate query tools for reporting and modelling.
• The creation and maintenance of analysis, reports and dashboards that support portfolio delivery across functions and decision making across NHSBSA, working with specific teams and liaising with all business areas as required.
• Developing complex predictive forecasting methodologies to inform and drive strategy and its deliverables. This will involve portfolio planning, as part of business planning, including formulation and development of options.
• Resolving highly complex information problems where there is no precedent or where leading opinions may conflict. Provide analyses to support development and refinement of metrics and reports to highlight trends, identify outlier behaviours within the data sets and risks within NHSBSA services.
• Making use of available IT to automate tasks where appropriate.
• Undertake periodic validation checks of performance and management data to ensure quality, integrity and accuracy.

Reporting

• Communicating and presenting highly complex and highly sensitive data and analysis effectively at all levels and to both internal and external stakeholders, to both technical and non-technical audiences both verbally and in writing. Ensuring the information provided is accessible and understandable to a wide audience and conforms to high standards.
• Delivering timely and targeted suite of reports and dashboards in a robust method, which analyse trends over time, shows comparisons of data and encompasses appropriate statistical methods and forecasts of performance. Ensures the accurate delivery of all commentary which forms part of quality information.
• Developing fully documented analysis and dashboards to satisfy both routine and ad hoc insight to senior management to support critical decision making within specific teams and across the NHSBSA, in line with business needs and required specifications along with accompanying notes and definitions to provide actionable intelligence. Also provide an expert resource in both technical skills required to create reports and also the design of dashboards to communicate information and insight effectively.
• Ensure information provided is accessible and understandable and conforms to high standards. Strong communication skills, both oral and written, enabling the promotion of data quality and insight across the Portfolio Management Directorate; providing guidance, recommendations and training to portfolio delivery communities.
• Coordinate portfolio reporting and provide analysis of performance.
• Drive accurate data and usage of Project Portfolio Management Tool (PPM reporting across the directorate, contributing to continuous development of tool to meet sub-portfolio directorate needs).
• As one of the key administrators of the PPM tool, ensure that updates supplied by third party are appropriately tested in advance of receipt of upgrade and participate in regular stakeholder engagement meetings to address challenges and build relationships.
• The maintenance of business intelligence tools to meet new and changing requirements.Planning and organising own workload and manage activities

Stakeholder Management & People

• Training and providing advice across specific teams in relation to the appropriate usage and understanding of data and information.
• Working collaboratively with a diverse range of customers/users within the organisation at all levels to define and develop new information products, enhance existing information provision and support target monitoring work.
• Being an active member of the wider Portfolio Office Team. Continually supporting team development and challenging the status quo to ensure a consistent, value adding management information provision to leaders, managers and colleagues.
• Supporting the Portfolio Office Manager to communicate and build commitment to a shared vision and sense of purpose across the directorate.
• Work collaboratively with colleagues across the NHSBSA and specific teams, includingPortfolio Finance Business Partners and the Benefits Management Team to ensure accuracy and integrity of data and reporting.

#J-18808-Ljbffr