Commercial Analyst

The post-holder will be involved in the collation, processing, analysis, presentation & interpretation of, contract and financial costing information within the Commercial Analytics Team (consisting of Commissioning and Costing functions). Key to the role will be handling data from a variety of sources in varying formats, performing complex database queries and spreadsheet analyses to generate both routine & ad-hoc reports to support the business, capacity planning and information needs of the Trust.
We highly encourage candidates to contact either Amandeep Phull, Commercial Analytics Manager ([email protected]) or James Peel, Principal Commercial Analytics Developer ([email protected]) prior to applying to understand more about the role.
Please be advised that if you are shortlisted for the post, there will be an on-site assessment held on the 15th and 16th May l. Successful candidates at this assessment will proceed to remote interviews between 21st and 23rd May., Assist in the production and validation of routine and adhoc information (activity and cost information).
Conduct investigations into significant data anomalies and respond to queries from internal and external sources.
Assist in data analysis and modelling to support production of capacity plans, contract activity targets and activity costing.
Interrogate the data warehouse using SQL and interface with Excel, using pivot tables and functions for the purposes of analysis and report generation, presenting Trust data in appropriate formats as requested by the Advanced Commercial Analyst and other managers.
To support the Trust in the development and implementation of new data systems.
We strongly recommend that applicants evidence how you have met the skills requirement in the supporting information section of your application., 1. Work with the others Commercial Analysts in the production and validation of monthly Contract Monitoring (activity and cost information) to tight deadlines
2. Investigate significant contract variances and other queries from Commissioners or the CSU in line with SUS flex and freeze dates, down to individual patient detail
3. Production of routine information for submission to Healthcare Commissioners in line with Service Level Agreements (SLAs
4. Produce Non Contracted Activity (NCA) monitoring reports in line with monthly invoicing
5. Aid discussion with Commissioners regarding ad-hoc information requirements
6. Liaise with Clinical Commissioning Groups, NHSE and CSU representatives via communication pathways regarding information issues, offer advice and resolve any subsequent queries
7. Identify and action routine and ad-hoc information requirements from the Strategy department
8. Conduct the monitoring of Data Quality issues pertaining to Commissioning information, advising when lack of data or validation error is sufficient to prevent reporting pending their resolution
9. Maintain an up-to-date knowledge and understanding of national information resources, definitions and policies for utilisation such as: NHS Data Definitions, Payment by Results system, Secondary Uses Service, ICD10, OPCS 4 and HRG Coding conventions and Reference Cost Guidance
10. To provide expert advice and support on complex analysis work, techniques, contract monitoring and related information issues to others in the Trust.
For further details of the role please see the attached job description
To ensure that we provide world-class patient care, UHCW recruits people that can demonstrate the Trust's Values and Behaviours in their everyday life. Therefore, if you are invited to interview, you will be undertaking a Values Based Interview/Assessment, which explores not only what you do but how and why you do it.
Before applying, we encourage you to review the Trust's Values and Behaviours which can be accessed on the right side of this page under the job description.
The Supporting Information Section in your application should therefore reflect your understanding of the Trust's Values and associated Behaviours. You will be expected to provide us with examples from work experience and/or personal life which demonstrate these values through your behaviour.
The Trust is committed to Equal Opportunities within the workplace. All vacancies will be considered for Job Share unless otherwise stated. All applicants who have a disability and who meet the minimum criteria for the job will be interviewed. Where a post has an overwhelming response, this Trust may use random selection in order to reduce numbers to interview, any disabled applicants will automatically be guaranteed an interview and will be exempt from this process.
In submitting an application form, you authorise University Hospital Coventry & Warwickshire NHS Trust to confirm from your previous or current NHS employer and other prior employers; previous NHS service details and personal data held about you, including Occupational Health data (inoculations and screening tests). This data will be transferred using NHS Electronic Staff Record and third-party systems via an automated process and only used for the purposes of obtaining and maintaining accurate employment records, should you be appointed to the post.
UHCW NHS Trust, by virtue of its Green Plan, is committed to ensuring that the way we provide services minimises the impact on the environment and the future health of the public e.g. zero waste to landfill, reducing our carbon footprint and increasing our recycling and reuse percentages.
If you are successful at interview you will receive a conditional offer of employment and we'll ask you for information so that we can carry out pre-employment checks. You must successfully complete all pre-employment checks to progress to a final unconditional offer.
We must confirm the identity of our staff and their right to work in the United Kingdom. We will ask you to submit proof of your identity and right to work documents via a secure digital platform approved by the Home Office, named TrustID. Alternatively, you may be asked to attend our office with original documents.
Depending on you level of exposure with patients you may be required to undertake a Standard or Enhanced DBS. The cost of this check will be charged to you and will be deducted from your salary over the first 3 months of employment at the current rate.
All correspondence will be sent by email; please check your account regularly including your Junk/SPAM folders

University Hospitals Coventry and Warwickshire NHS Trust, rated as good by the Care Quality Commission, is one of the largest teaching Trusts in the UK.
We are extremely proud of our employees across our hospital sites, with high quality patient care at the heart of everything we do.
Boasting some of the most modern facilities in Western Europe, the Trust is renowned for being at the forefront of research and innovation as part of its blossoming reputation as a worldwide leader in healthcare.
We are proud to be recognised as a Pathway to Excellence^® designated organisation - please click the link for further details about this prestigious award. Pathway To Excellence ® - University Hospitals Coventry & Warwickshire (uhcw.nhs.uk)
By joining our exciting journey, you will form part of a passionate, talented team and will be able to access a wide range of learning and development opportunities. There has never been a better time to join our team.
The Trust is committed to building an organisation that makes full use of the talents, skills, experience, and different perspectives available in our diverse society. We want everyone to feel they are respected, valued, can achieve their potential and receive the most appropriate and relevant care. We will create an environment where the equality and human rights principles of fairness, respect, equality, dignity and autonomy are promoted and are part of the organisation's core values.