Job summary
An opportunity has arisen to work as a Corporate Income Analyst in the Income & Planning team within Finance.
We are looking for a person with strong accounting and Excel skills to help support the Senior Finance Manager in Income in month-end reporting of income by commissioner, reconciliations, analysis, and interpretation of income and activity. The person will be helping to ensure that the correct income is coming into the Trust. This role allows the successful candidate to understand the complex nature of income within the NHS and provide exposure to interactions with commissioners. You will be working with large volumes of data and will gain a better understanding of clinical activity and income within the Trust.
We are looking for a driven individual who is self-motivated, pro-active and with excellent planning and organisational skills.
Main duties of the job
Job summary
To obtain, analyse and interpret the core information required to monitor Performance against target for the Trust's corporate income budget.
To manage the ledger transactions to ensure all income categories are accurately presented within Trust financial reports.
To undertake the detailed work on budgeting, pricing, financial control and monitoring of all central income.
Plan workload effectively to ensure all weekly, monthly, quarterly and annual deadlines are met within specified timetables.
Investigate cash variances by Commissioner, liaising with Accounts Receivable as necessary.
Raise journals in accordance with calculations.
Interrogate financial information systems to analyse output.
Assist in the production of ad hoc reports for Commissioning Managers from bespoke databases e.g. Trust to Trust.
To ensure all sources of income on the contract schedule are billed accurately, to the correct organisation.
Ensure that all adhoc income advised is received and documentation maintained.
Ensure that all new income streams are accurately reported.
The post holder is expected to take an active interest in the development of his/her skills, experience and career.
About us
You will be working in a small and supportive team who is responsible for Trust wide accounting for NHS Income from commissioners. You will be a part of a vibrant finance team.
Job description
Job responsibilities
Duties and responsibilities
Communication
- Discuss & respond to queries from Commissioners, Providers and staff. Queries may be complex and contentious and involve an internal & external audience.
- Contribute positively to the Finance Department, maintain a high standard of professionalism, and support the department in achieving its financial and operational objectives in line with the business plan.
- Produce financial analyses for senior Trust managers.
- Produce monthly activity & Income reports to enable Invoicing for Commissioners, NHS Overseas Visitors and Non-England Organisations.
Patient/customer care (both direct and indirect)
- Incidental contact only with patients and relatives
Policy & Service development
- To contribute to the continuous development of good practice within the department. Continually reviews current procedures, redesigning processes to improve service delivery
- Interpret national guidance associated with data collection exercises and devise effective and efficient systems to deliver the required outcomes.
- To ensure robust, accurate and complete identification of activity and income in all categories
Analytical & Judgemental skills
- To resolve queries independently where appropriate or propose options to Manager to attain resolution.
- To undertake analyses of financial data when required, in order to enable Commissioners & External colleagues to understand and interpret Trust reports to facilitate prompt payment.
- To support the Senior Finance Manager of Income, in the production of monthly invoices/credit notes for performance as well as monthly invoicing for all Cost per Case Commissioners and NHS Overseas, using the SLA Monitoring system (SLAM).
- To support the Senior Finance Manager of Income, in the production of weekly activity & income reports for use by Trust Finance Managers.
- Participate in producing month end corporate income position in accordance with the monthly timetable.
- Produce Work In Progress monitoring statements for Commissioners
- Complete and present control account reconciliations (including provisions) to the Senior Finance Manager of Income, ensuring that the central record is maintained. Analyse the requirement for and identify the potential release of specific provisions to contribute to the Trusts financial Income and Expenditure position.
- To audit and reconcile activity data on a monthly basis to ensure that all activity is being accurately attributed to the correct income source, i.e. Cost per Case (CPC) or SLA etc. Report issues and risks to the Senior Finance Manager of Incomeand advise the Commissioning team when they are required to make adjustments, to records or processes.
People management
- Liaison with staff in other sections to ensure targets are met.
- Implement any revised procedures and provide training and support to staff in other sections as required.
Information management
- Use advanced spreadsheet functions (such as pivot tables, sumif and vlookup) to create and design spreadsheets to support the analysis of various income streams.
- Develop reports for routine or ad hoc purposes as directed using systems available
- Manipulate and format information and distribute externally and internally.
- Create and format databases and spreadsheets for use by Trust Managers where necessary to meet specific objectives.
- Identify areas where adaptations may be required to current systems to enable the Trust to record and charge for all elements of activity.
- Produce Ad hoc reports analysing all income and activity variances as required.
Other duties
- To undertake any other duties commensurate with the grade as requested.
Job description
Job responsibilities
Duties and responsibilities
Communication
- Discuss & respond to queries from Commissioners, Providers and staff. Queries may be complex and contentious and involve an internal & external audience.
- Contribute positively to the Finance Department, maintain a high standard of professionalism, and support the department in achieving its financial and operational objectives in line with the business plan.
- Produce financial analyses for senior Trust managers.
- Produce monthly activity & Income reports to enable Invoicing for Commissioners, NHS Overseas Visitors and Non-England Organisations.
Patient/customer care (both direct and indirect)
- Incidental contact only with patients and relatives
Policy & Service development
- To contribute to the continuous development of good practice within the department. Continually reviews current procedures, redesigning processes to improve service delivery
- Interpret national guidance associated with data collection exercises and devise effective and efficient systems to deliver the required outcomes.
- To ensure robust, accurate and complete identification of activity and income in all categories
Analytical & Judgemental skills
- To resolve queries independently where appropriate or propose options to Manager to attain resolution.
- To undertake analyses of financial data when required, in order to enable Commissioners & External colleagues to understand and interpret Trust reports to facilitate prompt payment.
- To support the Senior Finance Manager of Income, in the production of monthly invoices/credit notes for performance as well as monthly invoicing for all Cost per Case Commissioners and NHS Overseas, using the SLA Monitoring system (SLAM).
- To support the Senior Finance Manager of Income, in the production of weekly activity & income reports for use by Trust Finance Managers.
- Participate in producing month end corporate income position in accordance with the monthly timetable.
- Produce Work In Progress monitoring statements for Commissioners
- Complete and present control account reconciliations (including provisions) to the Senior Finance Manager of Income, ensuring that the central record is maintained. Analyse the requirement for and identify the potential release of specific provisions to contribute to the Trusts financial Income and Expenditure position.
- To audit and reconcile activity data on a monthly basis to ensure that all activity is being accurately attributed to the correct income source, i.e. Cost per Case (CPC) or SLA etc. Report issues and risks to the Senior Finance Manager of Incomeand advise the Commissioning team when they are required to make adjustments, to records or processes.
People management
- Liaison with staff in other sections to ensure targets are met.
- Implement any revised procedures and provide training and support to staff in other sections as required.
Information management
- Use advanced spreadsheet functions (such as pivot tables, sumif and vlookup) to create and design spreadsheets to support the analysis of various income streams.
- Develop reports for routine or ad hoc purposes as directed using systems available
- Manipulate and format information and distribute externally and internally.
- Create and format databases and spreadsheets for use by Trust Managers where necessary to meet specific objectives.
- Identify areas where adaptations may be required to current systems to enable the Trust to record and charge for all elements of activity.
- Produce Ad hoc reports analysing all income and activity variances as required.
Other duties
- To undertake any other duties commensurate with the grade as requested.
Person Specification
EDUCATION & QUALIFICATIONS
Essential
- Educated to Degree level or equivalent level
- Actively studying for CCAB professional qualification
EXPERIENCE & KNOWLEDGE
Essential
- Extensive experience in a finance department
- Knowledge of NHS Finance & Organisational structures, including an understanding of clinical activity and how it is coded and recorded
- Experience and knowledge of finance computer systems, financial coding structures.
SKILLS & ABILITIES
Essential
- Ability to plan and organise own workload and meet deadlines, which will involve balancing competing priorities within a fluctuating and demanding workload
- Ability to analyse, investigate and resolve queries independently and take appropriate decisions within broad departmental procedures and external guidelines
- Confident user of IT e.g. Microsoft Office, integrated financial ledger system, databases, with accurate output
- Able to create complex spreadsheets and databases to manipulate complex financial data, often using several systems simultaneously. Use advanced spreadsheet functions (e.g. pivot table, sumif & vlookup)
- Ability to concentrate, occasionally for prolonged periods. Ability to deal effectively with frequent interruptions
- Ability to interpret highly complex external guidance and implement locally
- Ability to present and communicate in writing and verbally with all levels of staff and external contacts, often in situations, which are complex and potentially contentious
- Ability to influence and negotiate with others
PERSONAL QUALITIES
Essential
- Ability to work as part of a team, approachable with good inter-personal skills. Team player prepared to contribute to how the department operates.
- Ability to manage competing requests for information from a variety of sources.
- Self motivated with a proactive approach to problem solving. Motivates others.
- Good time management - Highly organised approach and able to prioritise own work to meet tight deadlines and targets
- Acts with integrity and professionalism
- A positive "can do" attitude and a positive attitude to change
OTHER REQUIREMENTS
Essential
- Reliable work record. Office working conditions
Person Specification
EDUCATION & QUALIFICATIONS
Essential
- Educated to Degree level or equivalent level
- Actively studying for CCAB professional qualification
EXPERIENCE & KNOWLEDGE
Essential
- Extensive experience in a finance department
- Knowledge of NHS Finance & Organisational structures, including an understanding of clinical activity and how it is coded and recorded
- Experience and knowledge of finance computer systems, financial coding structures.
SKILLS & ABILITIES
Essential
- Ability to plan and organise own workload and meet deadlines, which will involve balancing competing priorities within a fluctuating and demanding workload
- Ability to analyse, investigate and resolve queries independently and take appropriate decisions within broad departmental procedures and external guidelines
- Confident user of IT e.g. Microsoft Office, integrated financial ledger system, databases, with accurate output
- Able to create complex spreadsheets and databases to manipulate complex financial data, often using several systems simultaneously. Use advanced spreadsheet functions (e.g. pivot table, sumif & vlookup)
- Ability to concentrate, occasionally for prolonged periods. Ability to deal effectively with frequent interruptions
- Ability to interpret highly complex external guidance and implement locally
- Ability to present and communicate in writing and verbally with all levels of staff and external contacts, often in situations, which are complex and potentially contentious
- Ability to influence and negotiate with others
PERSONAL QUALITIES
Essential
- Ability to work as part of a team, approachable with good inter-personal skills. Team player prepared to contribute to how the department operates.
- Ability to manage competing requests for information from a variety of sources.
- Self motivated with a proactive approach to problem solving. Motivates others.
- Good time management - Highly organised approach and able to prioritise own work to meet tight deadlines and targets
- Acts with integrity and professionalism
- A positive "can do" attitude and a positive attitude to change
OTHER REQUIREMENTS
Essential
- Reliable work record. Office working conditions
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).
