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.
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.
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/
For full duties and responsibilities, please see the attached job description and person spec for full details
