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.
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.

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.
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 descriptio

• 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