Band 7 Finance BI Reporting Analyst

Band 7 Finance BI Reporting Analyst - Income

Royal Free London is recruiting for a Finance BI Reporting Analyst (Income) to support the group Income team.

The role, based at Enfield Civic Centre (2 days per week, and 3 days working from home), would suit an ambitious and dynamic candidate looking to work in a large acute trust that is continually evolving and growing.

The successful candidate will provide a comprehensive income reporting and business intelligence service to the Trust, supporting the accurate and timely reporting of clinical activity and income.

The post-holder will lead the production of monthly income reports, support external commissioner reporting requirements, and ensure activity and income data is complete, accurate and clearly understood. A key focus of the role will be the development of automated reporting solutions and Power BI dashboards, replacing legacy Excel and Qlik View processes with modern, efficient and intuitive reporting tools.

Working closely with Income, Contracts, Informatics, Data Quality, Finance Managers, clinical teams and operational managers, the post-holder will analyse income trends, investigate variances from plan, support commissioner reconciliations and provide expert advice on NHS income reporting, SLAM, National Tariff and commissioning requirements.

The post-holder will:

Lead the production of the Trust's monthly income reports and external monitoring returns in line with agreed reporting timetables.

Produce, process and validate activity and income data through SLAM, ensuring submissions to commissioners and external bodies are complete, accurate and provided in the required format.

Develop and maintain automated reporting processes, using tools such as SQL, Excel macros and Power BI to improve efficiency, accuracy and consistency across the Income team.

Lead the departmental programme to convert legacy Excel and Qlik View reports into Power BI dashboards and reporting apps.

Scope, design, build and maintain Power BI reports that provide clear, intuitive and actionable insight into income, activity, performance and key trends.

Analyse monthly income variances from plan, trends in activity and income, and differences between flex and final data, identifying anomalies and working with Informatics, Data Quality and finance colleagues to resolve issues.

Provide advice and guidance to clinical teams, operational managers and finance colleagues on income reporting, National Tariff requirements, commissioning arrangements and the drivers of income performance.

• Demonstrable ability to meet the Trust Values

• Educated to a degree level in relevant subject or equivalent level qualification or significant experience working at a similar level in a specialist area

• Knowledge of the NHS National Tariff
• Proven experience working within the NHS financial environment
• Experience of using SUS/HES Acute datasets
• Implementation of an Acute NHS planning/contracting round
• Acute NHS income reporting experience

• Excellent verbal and written communication skills
• Sound knowledge and skills of all MS Office products, SSIS packages, and SQL management studios.
• Advanced SQL skills
• Knowledge of CIVICA SLAM
• Numerate and able to analyse and interpret data and information accurately and effectively
• Able to analyse and interpret highly complex information and financial data to assess issues and anticipate problems and provide workable solutions
• Knowledge and experience in using PowerBI reporting suite
• Ability to communicate complex financial information to non-finance colleagues

• 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 management skills
• Customer Focused
• Committed to self-development

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.

£55,524 to £62,652 a year

Per annum inclusive of HCAS