Commercial Analyst

NHS; Coventry; On-site; GBP 31,000 - 38,000; Full time

Job summary

A public healthcare organization is seeking a Commercial Analyst to handle data analysis and reporting. Responsibilities include validating information and conducting data investigations. This role offers a salary between £31,049 to £37,796 annually, with flexible working options including home or remote work. Candidates should be skilled in SQL and Excel, and able to communicate effectively with stakeholders.

Qualifications

• Experience with data analysis and presentation.
• Strong SQL skills for database querying.
• Proficiency in Excel to manage and analyze data.

Responsibilities

• Assist in the production and validation of routine and adhoc information.
• Conduct investigations into significant data anomalies.
• Support the development of new data systems.

Skills

Data analysis

SQL

Excel

Communication

Problem-solving

Job description

University Hospitals Coventry and Warwickshire NHS Trust

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.

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.

Note that 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 until 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.

About us

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.

Job responsibilities

• Work with the other Commercial Analysts in the production and validation of monthly Contract Monitoring (activity and cost information) to tight deadlines
• 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
• Production of routine information for submission to Healthcare Commissioners in line with Service Level Agreements (SLAs
• Aid discussion with Commissioners regarding ad-hoc information requirements
• Liaise with ICB, NHSE and CSU representatives via communication pathways regarding information issues, offer advice and resolve any subsequent queries
• Identify and action routine and ad-hoc information requirements
• 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
• Maintain an up-to-date knowledge and understanding of national information resources, definitions and policies for utilisation such as: NHS Data Definitions, NHS Payment Scheme, Secondary Uses Service, ICD10, OPCS 4 and HRG Coding conventions and Reference Cost Guidance
• To provide expert advice and support on complex analysis work, techniques, contract monitoring and related information issues to others in the Trust.

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.

Salary and Benefits

£31,049 to £37,796 a year pro rata

Contract

Permanent, Full-time, Flexible working, Home or remote working, Compressed hours

Contact

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

University Hospitals Coventry and Warwickshire NHS Trust is an equal opportunities employer and welcomes applications from all sections of the community.