Job overview

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.

Please note if you are shortlisted for the post, there will be an on-site assessment held on the 28th and 29th October.  Successful candidates at this assessment will then proceed to be interviewed on 4th and 5th November.

Please be advised that a trainee candidate will be considered if a successful band 5 candidate is not appointed. If appointed as a trainee you will be paid at 75% of Band 5 salary (Annex 21) until in competencies are achieved. This would be expected to take 12 months.

Main duties of the job

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

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.