Commissioning Finance & Data Analyst
Job Description
Job summary
The Financial Commissioning Team is responsible for the reporting, analysis and financial management of the UHB's healthcare contracts for both secondary and tertiary services.
This role provides support and advice to the Contracting Accountants and Principal Finance Manager, with a focus on information management, activity reporting systems and data flows, alongside general financial management. This involves access to and processing of sensitive patient level information supporting the UHBs cross border financial flows.
This role involves:
- supporting in the production of the UHB contract monitoring files and associated patient datasets
- development of the monitoring processes through advanced Microsoft Excel and Access usage, or other systems
- database maintenance and development to supporting contract and non-contract financial management
- preparation and reporting of the UHB outflows
- supporting in the production of internal performance management schedules
contributing to the wider financial management agenda including month-end reporting, non-contract activity and payments/receipts management.
Main duties of the job
This role involves:
- supporting in the production of the UHB contract monitoring files and associated patient datasets
- development of the monitoring processes through advanced Microsoft Excel and Access usage, or other systems
- database maintenance and development to supporting contract and non-contract financial management
- preparation and reporting of the UHB outflows
- supporting in the production of internal performance management schedule
- contributing to the wider financial management agenda including month-end reporting, non-contract activity and payments/receipts management.
- manipulation and presentation of complex and large datasets through Microsoft Excel
- use of Microsoft Excel formulae and Pivot Tables
- use of Microsoft Access to maintain / develop forms for data capture and validation
- use of Microsoft Access to query and match complex datasets
- use of other activity and financial systems
The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.
About us
Cardiff and Vale University Health Board is one of the largest Integrated Health Boards in the UK, employing over 15,000 staff, providing over 100specialist services. Working across 6 hospital sites, we have a diverse range of career opportunities to offer. Serving around 500,000 people livingin Cardiff and the Vale of Glamorgan, we are focussed on the health and care needs of our local population whilst working with our partners todevelop regional services.Our mission is "Caring for People, Keeping People Well", and our vision is that every person's chance of leading a healthy life should be equal. Asan organisation we are unashamedly ambitious for our population's health, rising to the challenges of today and tomorrow through our 10-yearstrategy, Shaping our Future Wellbeing. We are contributing to a healthier Wales with great emphasis placed on innovation and improvement,learning from around the world and leading the way in clinical research. Partnership working is strong at Cardiff and Vale, and we work closelywith our staff and our community.Cardiff, the thriving Welsh capital, is a fantastic city to live and work in with an abundance of sports, arts and cultural attractions. Situated to thewest of Cardiff, the Vale of Glamorgan offers a combination of beautiful Welsh countryside and a dramatic natural coastline. Whether city life orrural living, Cardiff and the Vale offers the best of both worlds.
Job responsibilities
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac
Person Specification
English
Essential
- Good interpersonal, communication and presentation skills including the ability to interpret complex financial concepts for non-financial managers.
- Experience working with and managing complex information and data through spreadsheets and databases
- Demonstrable ability to work on multiple complex tasks simultaneously and produce high quality work within tight deadlines and within resource constraints
Desirable
- NHS Financial Management Experience
- Efficient in the use of Oracle, ESR, BIS
- Ability to communicate effectively with a wide range of professional staff and managers at all levels, both internal and external to the organization
- Knowledge of activity data collection and reporting
English
Essential
- Excellent IM&T Skills, literate with practical computer application skills covering Microsoft products including: -Excel - complex spreadsheets, formulae and pivot tables with ability to learn / develop -Access - table structures, queries and forms with ability to learn / develop
Desirable
- Knowledge of VBA / SQL & Power Query
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 (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).
Employer details
Employer name
Cardiff and Vale University Health Board
Address
Woodland House
Maes-Y-Coed Rd
Cardiff
CF14 4HH
