Job summary
The NHS Benchmarking Network provides data collection, analysis and reporting services to the NHS. Each year the Network runs over thirty projects, collecting over two million data items directly from the NHS and healthcare sector.
Main duties of the job
Role Responsibilities
Help to improve and develop existing Excel/VBA tools.
Design and develop new tools and systems in Excel/VBA to meet the needs of project team.
Work closely with product, analyst and developer teams in support of projects.
Provide Excel-based data analysis support to project teams.
Support coding standards and best practices
About us
Benchmark Management Consulting (BMC) are the official research support team to the NHS Benchmarking Network, one of the world's largest healthcare comparison services, offering a comprehensive suite of benchmarking and analytics solutions to its 300+ member organisations across the UK.
In addition, we facilitate two national audits - the National Audit for Care at the End of Life (NACEL) and the Cardiovascular Disease Prevention Audit (CVDPREVENT) - and use our unique and comprehensive data sets, especially in the area of mental health, to support strategic decision-making and allocation of resources across the UK healthcare system.
Benchmark aims to create and encourage an environment that is committed to promoting equality, diversity, working inclusively, and valuing the differences that individuals can bring to the workplace. We uphold these principles in our organisational values and behaviours towards each other and our patients. We welcome applications irrespective of age, disability, sex, gender identity and gender expression, race or ethnicity, religion or belief, sexuality, or other personal circumstances.
Job description
Job responsibilities
Excel is used in a variety of ways within the company:
Project team staff use it to analyse data.A large volume of data is collected via Excel data collection templates (over 5,000 completed templates) were processed in 2023.Our PDF reporting systems are built as an Excel/PowerPoint hybrid system using VBA code and produce over 15,000 unique pages of analysis per year.A range of other Excel/VBA tools to automate processes and provide a user-friendly interface for project staff.
Benefits
Base salary of £35,000-£40,000, depending on experience.Remote working is possible.Annual bonus scheme (subject to personal and business performance).25 days holiday increasing to 28 after 18 months service, plus statutory bank holidays.Flexible 8-hour shift around 6 core working hours.Contributory pension.
The role is primarily based at the BMC office in Manchester, with the possibility to work from home. Occasional travel to attend events may be required.
Please note that we are unable to sponser candidates for this role.
Job description
Job responsibilities
Excel is used in a variety of ways within the company:
Project team staff use it to analyse data.A large volume of data is collected via Excel data collection templates (over 5,000 completed templates) were processed in 2023.Our PDF reporting systems are built as an Excel/PowerPoint hybrid system using VBA code and produce over 15,000 unique pages of analysis per year.A range of other Excel/VBA tools to automate processes and provide a user-friendly interface for project staff.
Benefits
Base salary of £35,000-£40,000, depending on experience.Remote working is possible.Annual bonus scheme (subject to personal and business performance).25 days holiday increasing to 28 after 18 months service, plus statutory bank holidays.Flexible 8-hour shift around 6 core working hours.Contributory pension.
The role is primarily based at the BMC office in Manchester, with the possibility to work from home. Occasional travel to attend events may be required.
Please note that we are unable to sponser candidates for this role.
Person Specification
Qualifications
Essential
- Experience of building and maintaining complex spreadsheets.
- Experience of using Excel to analyse data.
- Experience of coding using VBA.
- Experience in building tools in Excel/VBA for others to use.
Experience
Essential
- Ability to solve complex problems and to think creatively.
- Ability to meet project deadlines.
- Ability to work independently and as part of a team.
- A strong customer-focus.
- Good communication skills.
- Good problem-solving skills.
- Adaptability.
- Ability to work under pressure.
Desirable
- Experience in building tools in Excel/VBA for others to use.
- Experience of using Excel/VBA to automate processes.
- Experience in using Python.
- Experience in SQL
Person Specification
Qualifications
Essential
- Experience of building and maintaining complex spreadsheets.
- Experience of using Excel to analyse data.
- Experience of coding using VBA.
- Experience in building tools in Excel/VBA for others to use.
Experience
Essential
- Ability to solve complex problems and to think creatively.
- Ability to meet project deadlines.
- Ability to work independently and as part of a team.
- A strong customer-focus.
- Good communication skills.
- Good problem-solving skills.
- Adaptability.
- Ability to work under pressure.
Desirable
- Experience in building tools in Excel/VBA for others to use.
- Experience of using Excel/VBA to automate processes.
- Experience in using Python.
- Experience in SQL
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
