Contracts Support Assistant

Job description

Job responsibilities

1. Administrative Support and Data Analysis for Contracts

a. Assist the Contracts Managers with collecting relevant documentation and information required for contracts including but not limited to quality compliance and insurance certificates and Trust policies.

b. Provide data analysis for new contract requests such as cost modelling and comparison for trust income versus contract price based on expected activity levels. Collecting the relevant information to do this.

c. Act as a primary point of contact to receive Key Performance Indicators from the Trusts contracted providers. Analyse KPIs versus the contract, query discrepancies and escalate breaches to the Service Manager and Head of Contracts.

d. Support the Divisions when they require ad hoc reports and help with regard to contracting issues.

e. Assist the Head of Contracts with Exit Planning tasks when clinical sub-contracts approach expiry/termination. Ensuring that all contract requirements of termination are tracked.

f. Be the primary recipient of specialised commissioning circulars. Maintain the tracker, seek advice from the (Head of Contracts/Senior Contracts Manager), cascade relevant information, queries and responses inside and outside of the trust as appropriate.

g. Assist the trusts Health Informatics Team with the quarterly data collection and submission of metrics required for the Specialised Service Quality Dashboards (SSQD). Prompt the service teams to provide their quarterly data, track the data requests and responses, assist with the interpretation of the metrics to support accurate data collection.

h. Collect and collate weekly data for the Central Diagnostic Centre (CDC) and submit this via the NHS England portal. This requires engagement with internal and external service teams, clinicians and ability to extract data from trust sources (e.g. the data warehouse).

i. Perform regular housekeeping of the contracts register at least once per month produce three lists of contracts to the Business Development Team as follows: where the contract is due to expire within the next 6 months, where the contract status is query (or similarly ambiguous), where the contract has expired. This will require planning and organisation of workload and reflect prioritisation of the wider team.

j. For all Business Development contracts, perform a regular audit and check of invoices in and out versus expected contract value. For NHS-NHS contracts where ASPH is the Provider this must be annually, for other contracts this may be every two years (or more frequently where the contract is considered high risk).

k. Support the Head of Contracts with responding to general data queries, including Freedom of Information Requests (FOIs). Identify appropriate data sources, prepare draft responses for review by the Head of Contracts, keep the FOI tracker up to date.

l. Be able to provide short term cover for the Contracts Managers (for planned and short term unplanned leave).

m. Work unsupervised using own initiative following departmental, trust and national guidance, policies and procedures escalating to senior managers, when necessary,

n. Provide and receive complex information, some of which may be contentious or sensitive and present it in such a way that it can be understood by the target audience, This may require providing data to colleague who are unfamiliar with data analysis and techniques so will need support and persuasion for the most appropriate way for the data to be presented. Such data includes, but is not limited to, spend and activity information for hospital services to patients including that which is contracted in or out with other partner organisations.

o. Review data reports as required, reviewing a range of options and analysis, ensuring that the systems used are robust and data anomalies are identified and investigated and then flagged as appropriate. Such data reports include, but are not limited to, trust patient level or service level activity and spend information.

p. Support Contract Manager with review of current working practices and policies and make suggestions for service development and improvement in line with national guidance and best practice.

Person Specification

Qualifications and Further Training

Essential

• Educated to degree level or equivalent experience

Desirable

• IT and data analysis qualifications e.g. relating to Microsoft Excel and SQL Server Management Studio

Experience

Essential

• Work experience involving data analysis, data preparation and presentation
• Experience of working within an NHS or Healthcare environment

Desirable

• Experience with Electronic Patient Records Systems
• Experience of performance monitoring or management

Knowledge

Essential

• NHS Constitution
• Trust vision, values and strategic objectives
• PBR / NHS Tariffs / NHS Payment System
• Knowledge of the use of data and how it is used to identify, track and monitor improvements

Desirable

• NHS data standards
• Contracting cycle

Skills

Essential

• Effective written and verbal communication, and able to present complex information to others
• Highly effective analytical skills and high level Microsoft Excel skills - able to use formulas, pivots and other data analysis functions
• Able to use the Microsoft Office Suite to an advanced standard (Word, Excel, PowerPoint, Teams)
• Able to work autonomously and with confidence to take decisions, within the remit of the job role
• Able to work independently where necessary to tight deadlines and to prioritise effectively against conflicting priorities
• Ability to identify problems/areas of risk and plan appropriate actions/interventions
• Ability to impart advice with clarity, adjusting style/approach as necessary
• Presentation and communication skills including data analysis and report writing
• Able to establish credibility and positive relationships with managers
• Able to work under pressure

Desirable

• SQL or similar database skills or the ability to learn them

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.

Employer details

Employer name

Ashford & St. Peter's Hospitals NHS Foundation Trust

Address

St. Peter's Hospital

Guildford Road

Chertsey

KT16 0PZ

Employer's website

https://www.ashfordstpeters.nhs.uk/ (Opens in a new tab)