Skip to main content

This site is independent of the NHS and the Department of Health.

Please wait, loading

Job summary

Main area
Commercial Analytics
Grade
NHS AfC: Band 7 / Trainee paid at 75% of Band 7
Contract
Permanent
Hours
  • Full time
  • Flexible working
  • Home or remote working
  • Compressed hours
37.5 hours per week
Job ref
218-AC-B7-6563683-C
Employer
University Hospitals Coventry and Warwickshire NHS Trust
Employer type
NHS
Site
UHCW
Town
Coventry
Salary
£46,148 - £52,809 per annum
Salary period
Yearly
Closing
02/03/2025 23:59

Employer heading

University Hospitals Coventry and Warwickshire NHS Trust logo

Advanced Commercial Analyst

NHS AfC: Band 7 / Trainee paid at 75% of Band 7

Job overview

We are looking for an experienced and motivated analyst to play a pivotal role in the development of the Trust’s analytics provision.  The successful candidate will be expected to work on their own initiative as well as part of a team providing expertise to define and establish reporting requirements to improve operational delivery and support commissioning and costing processes within the Trust.  The role also includes the line management of the Commercial Analysts providing leadership, guidance and support where required.

The role requires gaining a detailed understanding of data and reporting requirements through extracting, processing and analysing the data recorded and presenting its findings to support Trust staff at all levels.  You will be expected to offer guidance and interpretation to ensure analysis is both appropriate and useful to users, producing comparisons and trends, summarising findings and investigating any areas where data quality issues are identified. 

The ideal candidate will have excellent technical skills in SQL, SSRS, and Excel, or strong experience of similar technologies and the ability to adapt quickly to using these. NHS experience would be a strong advantage, but significant analytical experience gained working within a large and complex organisation will be essential.

Main duties of the job

You will work as part of a close-knit team, offering analytical support to the Specialty Groups and must be happy to work on-site.  Once established in the role, there is some flexibility for hybrid / home working although, there will be a minimum requirement to work 2 days on site.

UHCW is a large organisation that delivers a complex mix of healthcare, and this requires the successful candidate to possess the necessary skill set.  It is important that you evidence how you meet the requirements outlined in the person specification using real life examples where possible. 

Please be advised that a trainee role will be considered if a successful band 7 candidate is not appointed.  Candidates will need to demonstrate that they possess strong experience and meet the majority of the requirements but may require support/development to meet a particular technical aspect of the role.  If appointed as a trainee you will be paid at 75% of Band 7 salary (Annex 21) until competencies are achieved. This would be expected to take 12 months.

*Please be advised that initial face-to-face assessments will take place in week commencing 18th March 2025.  If successful at this assessment you will proceed to interview in week commencing 25th March 2025.

*Previous applicants need not apply.

Working for our organisation

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.

Detailed job description and main responsibilities

  • Carry out complex analysis to support Trust staff at all levels, offering guidance and interpretation to ensure the analysis is both appropriate and useful. Producing comparisons, trends, summary and narrative and investigating any areas requiring further investigation, ensuring analysis methodology is documented and a systematic approach is taken.
  • Produce internal and external information in support of the business of the Trust in an accurate and timely manner, summarising complex data and information and presenting findings to various technical and non-technical groups including delivering formal presentations to large groups where necessary. Highlighting difficulties in data quality, completeness and/or interpretation of commissioning information as appropriate
  • Be proactive in the initiation of information analyses, suggesting information reports, scenario modelling, interpretation and forecasting trends, providing analysis and advise on information for future programmes of work and service delivery
  • Utilise experience, knowledge, judgement and skills to develop and improve commissioning information reporting systems for operational and strategic monitoring of patient-based information in line with National data requirements and definitions. This will be achieved using a variety of reporting tools and a combination of advanced procedures in MS Excel, Access and SQL Server
  • Analyse and interpret trends and advise on information for service planning, undertaking patient activity forecasting as required. Undertake capacity and business planning information analysis ensuring that assumptions used in modelling are discussed and agreed with commissioners.
  • Utilise appropriate skills and software to advise on and enable simulation, predictive analysis and scenario testing to inform decision making by performance and operational leads
  • Lead discussion with the operational teams to identify and implement data requirements and adaptations as necessary to support the project within set timescales
  • Discuss with commissioners any ad-hoc information requirements and timeframes for receipt of information.  To liaise as necessary with Trust staff to ensure these requirements are met
  • Respond to and resolve queries from commissioners on information and performance issues in liaison with the Head of Commercial Analytics
  • Support the Trust’s National Costs Collection process ensuring that information is supplied within the agreed set deadlines
  • Ensure that relevant information is available to comply with current commissioning developments including the National Tariff Payment System
  • Liaise with the Principal Commercial Analytics Developer and members of the Commercial Analytics team as appropriate to ensure Key Performance Indicators (KPIs) and milestones are developed to measure and monitor the progress of delivery
  • Lead on service development in the role’s own specialist areas, proposing changes and developing and implementing policy for this area, ensuring processes are robust, efficient and well documented
  • Utilise appropriate benchmarking tools for example Telstra Health and Model Hospital to identify and model areas of potential service improvement from analysis of peers.

For further details of the role please see the attached job description

Person specification

Qualifications

Essential criteria
  • See supporting documents
Desirable criteria
  • See supporting documents

Experience

Essential criteria
  • See supporting documents
Desirable criteria
  • See supporting documents

Knowledge

Essential criteria
  • See supporting documents
Desirable criteria
  • See supporting documents

Skills

Essential criteria
  • See supporting documents
Desirable criteria
  • See supporting documents

Employer certification / accreditation badges

No smoking policyAge positiveDisability confident leaderImproving working livesArmed Forces Covenant (Silver Award)Pathway to excellenceCare quality commission - GoodPregnancy Loss PledgeHeart Charter

Applicant requirements

The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.

Documents to download

Apply online now

Further details / informal visits contact

Name
Amandeep Phull
Job title
Commercial Analytics Manager
Email address
[email protected]
Apply online nowAlert me to similar vacancies