Commissioning Finance & Data Analyst
WHO WE ARE:
Cardiff and Vale University Health Board is one of the largest Integrated Health Board in the UK, employing over 16,000 staff and providing over 100 specialist services. Serving a population of around 500,000 people living in Cardiff and the Vale of Glamorgan, we are focussed on the health and care needs of our local population whilst also working with our partners to develop regional services.Together we are committed to improving health outcomes for everyone and to delivering excellent care and support.
Our mission is “Living Well, Caring Well, Working Together”. We have recently refreshed our strategy, Shaping Our Future Wellbeing, which sets out the Health Board’s Vision for improving the health and wellbeing of the populations we serve by 2035 through the delivery of our strategic objectives; Putting People First, Providing Outstanding Quality, Delivering in the Right Places, and Acting for the Future.We have challenging times ahead, but we are confident that by tackling these challenges together, we can support people to live healthier lives and reduce the unfair differences in the prevalence of illness and health outcomes we see in our communities today.
We aspire to deliver outstanding care and treatment for people when they need it, where they need it; care that compares well with the best in the world, but to do so, we need to transform how we deliver services over the next decade and beyond.
We are a values-driven organisation and out goals will only be realised if our values are at the heart of everything we do. Created by colleagues, patients and their families and carers, our values are:
- We are kind and caring
- We are respectful
- We have trust and integrity
- We take personal responsibility
OUR REGION:
Wales has much to offer with miles of stunning coastline, UNESCO world heritage sites and beautiful countryside. Cardiff, the thriving Welsh capital, has something for everyone. It is a fantastic city to live and work in with an abundance of sports, arts and cultural attractions.Situated to the west of Cardiff, the Vale of Glamorgan offers a combination of beautiful Welsh countryside and a dramatic natural coastline, as well as charming towns including Penarth and Cowbridge. Those seeking more culture may find themselves drawn to the National Museum, St Fagan’s Museum of Welsh Life or the Millennium Centre, home of the Welsh National Opera.
Whether city life or rural living, Cardiff and the Vale offers the best of both worlds.
Job overview
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.
Working for our organisation
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 living
in Cardiff and the Vale of Glamorgan, we are focussed on the health and care needs of our local population whilst working with our partners to
develop 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. As
an organisation we are unashamedly ambitious for our population’s health, rising to the challenges of today and tomorrow through our 10-year
strategy, 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 closely
with 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 the
west of Cardiff, the Vale of Glamorgan offers a combination of beautiful Welsh countryside and a dramatic natural coastline. Whether city life or
rural living, Cardiff and the Vale offers the best of both worlds.
Detailed job description and main 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
Knowledge
Essential criteria- 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
- 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
Skills
Essential criteria- 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
- Knowledge of VBA / SQL & Power Query
MANAGING YOUR APPLICATION:
We are committed to promoting inclusion, where all staff have a sense of belonging. We welcome applications from everyone and recognise the need for our workforce to represent the diversity of the population we serve. We value our differences and fully advocate, cultivate and support an inclusive working environment where staff treat one another with dignity and respect and where diversity is celebrated.We aim to create a working environment where every individual can fulfil their potential no matter their disability, sex, gender identity, race, sexual orientation, age, religion or belief, pregnancy and maternity or marriage and civil partnership status.
We are keen to break down barriers in the UHB, and encourage applications from under-represented groups.
Applicants are invited to apply in Welsh. Any application submitted in Welsh will not be treated less favourably than an application made in English.
The UHB reserves the right to close this vacancy after 24 hours if a large number of suitable applications are received. Therefore, we encourage early applications to ensure consideration for this post.
Please check your email account regularly. Successful applicants will receive all recruitment related correspondence via the email account registered on the application form.
To work in the UK, all candidates who are not UK or Republic of Ireland (RoI) nationals require sponsorship to obtain either a Health and Care visa or Skilled Worker visa, unless you have permission to work via another route. Non UK / RoI candidates wishing to apply should self-assess the likelihood of obtaining a Certificate of Sponsorship by visiting Work in the UK.If you are eligible for the Health and Care visa, application costs are lower and you do not need to pay the annual Immigration Health Surcharge.