Band 7 Finance BI Reporting Analyst - Income
Job summary
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 QlikView 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.
Main duties of the job
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 QlikView 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.
About us
The Royal Free London NHS Foundation Trust is one of the UK's biggest and most innovative trusts. Across three main hospitals, our dedicated army of staff care for over 1.6million patients, treat more than 200,000 in A&E, deliver over 8,000 babies and carry out more than 17million tests.
Our size, scale and influence offer you unrivalled career opportunities and a forward-thinking approach to working that works around your lifestyle. From flexible hours and generous benefits, to next level training, we make it easier to take your career to the top.
For more information please follow link https://www.royalfreelondonjobs.co.uk/
Job description
Job responsibilities
For full duties and responsibilities, please see the attached job description and person spec for full details
Person Specification
Royal Free World Class Values
- Demonstrable ability to meet the Trust Values
Education and professional qualifications
- Educated to a degree level in relevant subject or equivalent level qualification or significant experience working at a similar level in a specialist area
- CCAB (accountant) qualified
Experience
- 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 informatics experience
- Acute NHS income reporting experience
- Acute NHS Contracts experience
Skills and Aptitudes
- Excellent verbal and written communication skills
- Sound knowledge and skills of all MS Office products, SSIS packages, and SQL management studios.
- Excellent Excel skills
- 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
Personal Qualities and 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 management skills
- Embraces change
- Effective communicator
- Customer Focused
- Committed to self-development
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.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
Royal Free London NHS Foundation Trust
Address
Enfield Civic Centre
Silver Street
Enfield
EN1 3XA
United Kingdom
Employer's website
https://www.royalfreelondonjobs.co.uk/