Band 8b Senior Business Analyst - Income Reporting in London

Our trust has over 17,000 staff serving 2 million patients every year. It comprises Barnet Hospital, Chase Farm Hospital, the Royal Free Hospital, North Middlesex University Hospital and more than 30 services in the community. This larger scale organisation provides an unprecedented opportunity for us to continue our pioneering work, particularly in finding ways to deliver even better care to our patients.

Our mission is to deliver world class care and expertise in our clinical services, underpinned by world class teaching and research and we will continue to measure our progress against our five governing objectives: excellent outcomes, excellent patient and staff experience, excellent value for taxpayers' money, being safe and meeting our external duties, and building a strong organisation.

Everyone is welcome at Royal Free London NHS Foundation Trust. We're proud of our diversity and we continue to undertake new initiatives to advance equality for LGBT+, BME, gender equality, staff carers and people with disabilities and lived experiences to promote good relations and understanding between our staff.

Artificial intelligence (AI) is a set of technology that can perform various tasks that typically required human intelligence. Your application is your opportunity to demonstrate to us how you meet the requirements of the role. We recognise that AI tools can support accessibility, equity and confidence for applicants. However, it's important that examples and responses genuinely reflect your own experience and abilities, as these will be explored further during the selection process. AI must not be used to provide misleading or false information during any stage of the application journey. Further guidance can be found in the NLPSS Applicant Toolkit .

Job overview

Reporting to the Head of Income, the Senior Business Analyst - Income Reporting (External) leads the development, management, and optimisation of the Trust Group's income reporting systems, with responsibility for the SLAM database and the accurate extraction, processing, and reporting of clinical activity data. The role ensures the timely and accurate realisation of approximately £1.9bn in clinical income, supporting statutory, contractual, and commissioner reporting requirements.

As the technical lead for external income reporting, the post-holder produces and oversees commissioner income reports, contract performance analysis, statutory returns, and reconciliation processes, working closely with commissioners, operational services, informatics teams, and finance colleagues. The role combines advanced analytical and technical expertise in SQL, SLAM, and business intelligence tools such as Power BI or Qlik, with a strong focus on data management, reporting automation, and financial modelling.

The position also provides leadership and technical guidance to the Clinical Income team, supports income planning and service developments, develops pricing frameworks and commissioning guidance, and delivers complex scenario modelling, impact assessments, and performance analysis. The post-holder ensures compliance with NHS, commissioning, and accounting standards while representing the Income and Finance teams at internal and external stakeholder meetings.

Main duties of the job

Lead the Trust Group's external income reporting function, ensuring the accurate and timely production of monthly SLA, commissioner, statutory, and financial reporting, in line with NHS Payment Scheme (NTPS) and contractual requirements. Oversee the development and optimisation of income reporting systems, including SQL-based data extraction, complex data modelling, forecasting. Lead the modernisation of reporting automation, and migration of reports to Power BI.

Providing expert leadership in activity and income planning, commissioner negotiations, pricing and tariff interpretation, contract risk management, financial forecasting, and income maximisation initiatives. Ensure robust reconciliation processes between clinical activity, invoicing, and income received, while maintaining compliance with audit, year-end, and accounting requirements.

Manage and develop the External Clinical Income reporting team (one direct report, two indirect), setting objectives, supporting professional development, and ensuring delivery against competing priorities.

Deliver complex financial analysis, business cases, scenario modelling, and strategic advice to senior finance leaders, while representing the Trust at internal committees, commissioner meetings, and national income and pricing forums.

Act as the Trust's subject matter expert on NHS payment mechanisms, commissioning processes, and income reporting, deputising for the Head of Income as required.

Working for our organisation

Since our foundation in 1828, the Royal Free London has had a pioneering history, leading the way in many areas of healthcare: advancing our understanding of illness; taking advantage of the latest technology; developing new and better therapies; and tackling health and social inequalities.

That pioneering spirit continues to be central to our approach today and contributes to our record of delivering some of the best clinical outcomes for patients across our local and specialist services.

As a large NHS foundation trust , we employ more than 17,000 staff from 120 countries, serve a population of more than 1.6 million people across 70 sites in north London and Hertfordshire and are one of the biggest providers of cancer care in the UK.

We want to bring the best of the NHS to every patient, no matter which of our hospitals or services they visit.

We aim to achieve this through our three-fold mission of delivering world class treatment and local care, underpinned by groundbreaking research and the very best in class for learning and education.

From our four main hospitals and at various other satellite sites and hospital trusts, we offer local services for local people.

For more information please follow link

Detailed job description and main responsibilities

Please see the detailed job description and person specification for full job details and required experience and skills.

Person specification

Education and professional qualifications

• Master degree (or equivalent)
• CCAB qualified accountant (or equivalent)

Experience

• NTPS / PbR knowledge/experience
• Extensive knowledge and understanding of NHS financial environment/income regime
• Annual planning experience
• Managing and developing staff/teams

Skills and aptitudes

• Excellent verbal and written communication skills
• Sound knowledge and skills of all MS Office products and SQL management studios
• Advanced Excel skills
• Knowledge and experience in using Qlikview and/or Power BI reporting suite
• Able to interpret highly complex information and financial data to assess issues and anticipate problems and provide workable solutions

Royal Free Shared Commitments

• Demonstrable ability to meet the Trust shared Commitments

Personal Qualities & attributes

• Confident and Assertive
• Able to produce work to a consistently high standard
• Able to work effectively as part of a team
• Self Motivated
• Sound time

• AT* - Apprenticeship Training . Where AT* is entered next to the job title indicates that this vacancy is for an apprenticeship role.
• By applying for this role, you accept if successful, that your personal data may be transferred from the Trust to another NHS organisation where your employment transfers within the NHS. This is in accordance with the streamlining programme which aims at saving you time and improving efficiencies within the NHS when your employment transfers. Therefore we require you to complete your stat and Man e-learning modules prior to joining our organisation.
• If you are an EU/EEA citizen who does not have EU Settlement or Pre-Settled status, you will require a visa to work in the UK.
• You must already have the right to work in the United Kingdom or fully meet the eligibility criteria for sponsorship under the Skilled Worker visa route. We welcome applications from candidates who require visa sponsorship; however, we can only consider these where all UKVI requirements are met. Before applying, please ensure that both you and the role satisfy the relevant UK Visas and Immigration (UKVI) points-based system criteria, as applications that do not meet these requirements cannot be progressed. For more information about the criteria, please click here
• If you are offered a role with one of the NLPSS partner trusts, as part of pre-employment checks your identity and right to work documentation will be verified remotely (in most circumstances), using a certified identity verification service provider TrustID. You will be asked to capture an image of the relevant documents as well as a "selfie" using your smartphone/tablet (if available) for facial matching. TrustID will also perform a digital address check using Trunarrative and Equifax, which is a soft check and does not leave a footprint on your credit rating. For more information, visit
• The Trust uses electronic new starter forms on Trac to collect personal details. Information collected is securely stored and used to set up the employee record on the ESR HR system.
• The Trust will request a DBS (CRB) if post involves regulated activities. The Trust is compliant with the Disclosure and Barring Service Codes of practice and the Rehabilitation of offenders act.
• By applying for this post you are agreeing to Royal Free London NHS Foundation Trust transferring the information contained in this application to its preferred applicant management system. If you are offered a job, information will also be transferred into the national NHS Electronic Staff Records system.

Applications are welcome from people wishing to job share or work flexible patterns. We are committed to equal opportunities.

Please note:

• Due to the high number of applications that are received for some posts we may close this vacancy before the advertised closing date. Therefore please apply for this post as soon as you can, if you are interested and you meet the requirements of the Person Specification
• Only those candidates who clearly demonstrate how they meet the person specification will be shortlisted for this job.
• Interview arrangements will be communicated via email so please check your email regularly following the closing date.

Please be advised that due to exceptionally high demand, all Royal Free accommodation is at full capacity and waiting lists are being held. Average waiting times are 12 months. Please do not rely on Trust accommodation when you commence your role and ensure you investigate alternative accommodation for your arrival.

Employer certification / accreditation badges

Applicant requirements

You must have appropriate UK professional registration.

Documents to download

• 8B - Senior Business Analyst - Income Reporting (external) JD and person spec ( PDF , 444.1 KB )
• PS ( PDF , 198.9 KB )
• FR ( PDF , 111.4 KB )
• Corporate, Admin & Clerical, Other - benefits, about RFL, shared commitments and governing objectives ( PDF , 646.3 KB )

#J-18808-Ljbffr