Job summary
This is a fixed term role within the income team, leading on
- The departmental automation and Power BI program
- Development of reporting systems through task automation, building macros, queries in SQL or other techniques to improve efficiency of various processes performed by the team
- Scope, develop, deploy and maintain reports using Business Intelligence tools such as Power BI
Interview date: 25th October 2023 - Please date, no other date will be considered.
Main duties of the job
- Lead on scoping, project planning and maintaining good project documentation for the departmental program for automation and Power BI transformation
- Be the lead Power BI developer as part of the departmental Power BI transformation project - converting legacy reports (in excel, Qlikview) into Power BI
- Liaise with key stakeholders to gather input, output and user interface requirements for new Power BI reports and apps
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
Please see attached job description for more information about this role and working at Royal Free London NHS Foundation Trust.
Job description
Job responsibilities
Please see attached job description for more information about this role and working at Royal Free London NHS Foundation Trust.
Person Specification
Royal Free World Class Values
Essential
- Demonstrable ability to meet the Trust Values
Education & professional Qualifications
Essential
- Educated to a degree level in relevant subject or equivalent level qualification or significant experience working at a similar level in a specialist area
Desirable
Experience
Essential
- Knowledge of the NHS National Tariff
Desirable
- 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
Essential
- Excellent verbal and written communication skills
- Sound knowledge and skills of all MS Office products, SSIS packages, and SQL management studios.
- Excellent Excel 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 of the NHS National Tariff
- Knowledge and experience in using PowerBI reporting suite
Desirable
- Knowledge of visual basics
- Ability to communicate complex financial information to non-finance colleagues
Person Specification
Royal Free World Class Values
Essential
- Demonstrable ability to meet the Trust Values
Education & professional Qualifications
Essential
- Educated to a degree level in relevant subject or equivalent level qualification or significant experience working at a similar level in a specialist area
Desirable
Experience
Essential
- Knowledge of the NHS National Tariff
Desirable
- 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
Essential
- Excellent verbal and written communication skills
- Sound knowledge and skills of all MS Office products, SSIS packages, and SQL management studios.
- Excellent Excel 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 of the NHS National Tariff
- Knowledge and experience in using PowerBI reporting suite
Desirable
- Knowledge of visual basics
- Ability to communicate complex financial information to non-finance colleagues
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
Additional information
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
