Advanced Commercial Analyst inCoventry inCoventry PUBLISHED THU 28 NOV 2024

The post holder will be responsible for the provision of information through analysis, interpretation and investigation to support commissioning and costing processes. This is a senior post within the Commercial Analytics department and therefore the post holder will be expected to work on their own initiative providing high level information analysis, systems development skills and expertise to define and establish reporting requirements to improve operational delivery and contribute to the development of the Trust's analytics provision.

The post holder will lead on producing high quality data and will be proactive in improving the use of commissioning and costing information throughout the Trust, including leading in the development of the Trust's commissioner reporting solutions. This includes the line management of the Commercial Analysts.

UHCW is a large organisation that delivers a complex mix of healthcare and this requires the role to possess the necessary skill set. It is important that you evidence with examples of how you meet the requirements outlined in the person specification.

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

*We strongly recommend that you evidence how you have met the skills requirement in the supporting information *

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.

• 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

About us

1. 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
2. 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.
3. 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
4. Lead discussion with the operational teams to identify and implement data requirements and adaptations as necessary to support the project within set timescales
5. 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
6. Respond to and resolve queries from commissioners on information and performance issues in liaison with the Head of Commercial Analytics
7. Support the Trusts National Costs Collection process ensuring that information is supplied within the agreed set deadlines
8. Ensure that relevant information is available to comply with current commissioning developments including the National Tariff Payment System
9. 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
10. Lead on service development in the roles own specialist areas, proposing changes and developing and implementing policy for this area, ensuring processes are robust, efficient and well documented
11. 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