Portfolio Insight and Reporting Specialist - Any NHSBSA site, NE15 8NYSalary: £38,682 to £46,580 a yearContract: PermanentWorking Pattern: Full-time, Flexible workingReference Number: G9914-25-0160 Job summaryAre 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?o Hybrid working - offering flexibility to work predominantly from home with the opportunity to be office based should you prefer, or if business needs require it.o 27 days leave (increasing with length of service) plus 8 bank holidays o Opportunities for developmento Active wellbeing and inclusion networkso Excellent pension o Various salary sacrifice schemeso Employee Assistance programme, offering free 24/7 support for you and your loved oneso Access to a wide range of benefits and high street and online discountsMain duties of the jobInsight: 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 usHere 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 descriptionJob responsibilitiesIn this role, you are accountable for1. InsightHandling 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.2. ReportingCommunicating 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 activities3. Stakeholder Management & PeopleTraining 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.Person SpecificationPersonal Qualities, Knowledge and SkillsEssential Able to critically appraise, interrogate and interpret highly complex data and advise on actions based on the comparison of a range of options. Analytical and logical approach to problem solving Able to present information as a subject matter expert clearly and communicate technical concepts to a varied audience at all levels, both verbal and written Able to use database, statistical, word processing, spreadsheet and presentational IT packages to produce highly complex and highly sensitive reports Accurate with the ability to prioritise own workload and work independently within established parameters Skilled in the translation of business needs and issues into logical, analytical frameworks that outline and support reporting requirements Understanding of the principles of effective report design and able to check own work in an objective manner Flexible and committed team player with the ability to use own initiative and work on multiple activities in a changing environment Desirable Advanced skills in Microsoft Office Packages Able to identify and act on future needs and opportunities ExperienceEssential In-depth specialist knowledge of information and quality analysis through relevant qualification(s) or acquired through training or relevant on the job experience. Experience in advanced data collection, validation and analysis with an advanced understanding of the importance of quality data. Experience in personally resolving highly complex queries. Significant experience of advising and supporting business areas to gain more insight and value from data Practical applied experience of using Business Intelligence tools with large data sets to develop dashboards, reporting or analyses based upon customer requirements Desirable Worked in the NHS or other large organisation. Experience of handling sensitive data. QualificationsEssential Degree or equivalent in a relevant discipline such as data analysis or can demonstrate equivalent work experience or further education training. Desirable Portfolio management and/or project management qualification e.g. P3O, PRINCE2 **** When applying for this role, please read the Supporting Documents on the apply page. ***