Data Analyst

The Walton Centre NHS Foundation Trust

Information:

This job is now closed

Job summary

Are you ambitious, would you welcome a challenge and are you willing to promote and embrace change? If so then please read on.

Health Procurement Liverpool (HPL) is a specialist procurement alliance between Alder Hey Childrens Hospital, The Clatterbridge Cancer Centre, Liverpool Heart & Chest Hospital and The Walton Centre.

HPL was established in April 2021 and is hosted by The Walton Centre NHS Foundation Trust. Each organisation is an equal partner of the shared service with all organisations working together to set the strategic direction of HPL.

This is an exciting time to join HPL, a service that is leading the way in procurement collaboration across the region and is heavily invested and passionate about our people.

HPL is creating an environment to support all of our staff to develop and grow, share skills and knowledge, to embrace innovation, deliver excellence and value within our procurement activities and has the ambition to become a world class procurement function of the future.

This role is perfect for someone wanting to take that next step in their career or for someone looking for a different stage to shine on.

HPL will give you the platform to showcase your Procurement skills, within a supportive and forward thinking team, so if you can buy and get people bought in, we want to hear from you.

HPL currently has an exciting opportunity for an experienced and highly

motivated Procurement professional to join the team as a Data Analyst.

Main duties of the job

The post holder will be required to work closely with the P2P & Data Lead as part of the Procurement team and across the organisations to develop and maintain close working relationships with a wide range of stakeholders to help drive efficiencies throughout the Trust.

The successful candidate will be educated to GCSE level, with evidence of CPD in data analytics and business intelligence. A qualification in Information Technology or relevant experience is desirable.

The post holder will be required to develop intelligent dashboards that will allow colleagues across all HPL organisations a one stop shop to access real time information relating to the performance and delivery of the procurement service. Whilst also being responsible for collating & uploading of national data requirements.

The post holder will support in the delivery of the Trust procurement strategy and any current/ upcoming national Procurement agendas.

If you have the relevant skills, abilities and experiences that this post demands and you are ready for a challenge, we would like to hear from you.

For more information or an informal discussion please contact, Adam Campbell, P2P & Data lead on 07890897875 or email Adam.Campbell7@nhs.ne

About us

The Walton Centre NHS Foundation Trust is the only NHS trust to hold dual accreditation for the Investors in People we invest in people and we invest in wellbeing standards and has been awarded Gold status for both. The Walton Centre is a leader in the treatment and care of neurology and neurosurgery, placing the patient and their family at the heart of everything we do. As the only specialist hospital trust in the UK dedicated to providing comprehensive neurology, neurosurgery, spinal and pain management services we are proud to be rated as an Outstanding Trust by the Care Quality Commission (CQC), and champion change throughout the field of neuroscience. Originally formed in 1992, the Trust received Foundation Trust status in 2009.

With around 1,450 staff, The Walton Centre treats more than 127,000 outpatients and 18,000 inpatients each year. We have leading specialists and incredibly dedicated staff delivering excellent clinical outcomes for brain, spinal and neurological care nationally and internationally. Teams across our site in Fazakerley, Liverpool, offer a world-class service in diagnosing and treating injuries and illnesses affecting the brain, spine and peripheral nerves and muscles, and in supporting people suffering from a wide range of long-term neurological conditions.

Date posted

22 May 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£27,055 to £32,934 a year

Contract

Permanent

Working pattern

Full-time

Reference number

C9160-427600

Job locations

The Walton Centre

Lower Lane

Liverpool

L9 7LJ


Job description

Job responsibilities

The post holder will be required to develop intelligent dashboards that will allow colleagues across all HPL organisations a one stop shop to access real time information relating to the performance and delivery of the procurement service.

  • To support the strategic direction of Health Procurement Liverpool by creating and maintaining robust repeatable processes for all procurement-based data.
  • To provide information to support procurement projects via the maintenance and update of spend analysis from all available sources.
  • Assist Procurement colleagues in the efficient requesting and processing of data for : baseline, tender evaluation, contract award, catalogue update/uploads, monthly KPIs and ongoing monitoring to enhance compliance;
  • Contribute to the sharing of best practice within the Procurement team so that both internal and external data sources are engaged in an effective and consistent way.
  • Support database and system developments within the department including but not limited to the trusts contracts database and procurement dashboards;
  • Support in the collation, analysis and submission of nationally required data in a timely and effective manner;
  • Support with data collection and procurement response to all trust(s) FOI requests;
  • To work professionally aligned with the trusts informatics team in supporting the development of procurement dashboards and reports to support the delivery of the procurement strategy

Responsibilities

Collates, interprets and presents data to support the development and implementation of the Health Procurement Liverpool Strategy and provide management information to support initiation and monitoring of procurement projects

Assists the Procurement team(s) to identify savings and better practice opportunities across a range of projects.

Develops professional and intelligent dashboards that can be used both internally and externally;

Supports Procurement Managers through the collation and analysis of data and to provide relevant and innovative formats of Management Information: supporting the baseline process, providing evaluation techniques throughout the procurement process, ensuring robust data collection techniques enabling efficient creation of catalogues and monitoring compliance to all contracts, and ensuring effective data management at all times.

Ensures Trust/Supplier data is routinely received in line with business processes, and effectively managed to meet multiple outputs.

Monitors purchasing trends across the Trust, to develop category knowledge and aid the collation of market intelligence.

Provides information for the Senior Management Team to support their decision making in realising efficient business processes in re-engineering the supply chain

Provides information to support the submission of data in relation to Carter Metrics and associated procurement league tables and develops appropriate dashboards for both internal and external use.

Ensures learning from own projects is shared within the Procurement team, and the wider organisation, through active promotion of tools and techniques.

Provides input to the development and implementation of the Procurement Systems Strategy, with particular emphasis on data collection methodologies and management information tools and techniques.

Supports the P2P & Data Lead for all trust freedom of information requests (FOIs) relating to procurement information, ensuring that accurate procurement data and information is returned in a timely manner to support the trust(s) responses to FOI requests.

Source, analyse and deliver timely, high-quality complex data to senior procurement team members to support the delivery of the annual procurement CIP reports and ongoing data analysis to support new CIP schemes identified throughout the year;

Produce on a monthly basis the departments Key Performance Indicators incorporating changes and amendments as determined by the senior management team;

Generate and analyse data to meet the requirements of any local and national initiatives to include, but not limited to, Sustainability and Transformation Plans (STP) and Local Delivery Systems (LDS), the Lord Carter Recommendations as detailed in the report Review of Operational Productivity in NHS Providers along with the associated Model Hospital initiatives to maximise procurement opportunities, the Nationally Contracted Products Programme and the Procurement Partnership Board as established by HealthTrust Europe

Brings together multiple data sets from a number of organisations to support the accurate categorisation and development of a short, medium and long term procurement work plan.

Support the P2P & Data Lead for the development and delivery of procurement specific training packages across the HPL supported by the use of data analysis and specific dashboards to ensure that users maximise procurement opportunities and obtain value for money in all non-pay related spend.

Support the P2P & Data Lead with Catalogue Management and the development/uploading into systems also challenging the non-use of catalogues in order to reduce the requirement for non-catalogue requests.

Communication

Develops appropriate relationships with external suppliers to ensure automated data capture of sales information, with regular monitoring, and appropriate development for use of management information.

Provide outputs to the Procurement team to track benefits realisation, supporting the baseline process through best use of appropriate data.

Through the provision and interpretation of data, supports the Purchasing/ catalogue and compliance staff to improve business processes, aid product standardisation and enhance service development option appraisals.

Investigates and resolves queries and discrepancies.

Ensures reporting timetables are met through planning and organising workload.

Highlights opportunity for changes to working practices and procedures.

Manages own workload and contributes to team effort in support of other colleagues.

To continually review operational performance ensuring optimum resource levels to deliver customer expectations and maximise savings opportunities.

Ability to present (both verbally and visually) complex data and information to an audience of internal and external colleagues and use appropriate software/systems to support.

Contributes to relationships with NHS Supply Chain (NHS SC), Crown Commercial Services (CCS), HealthTrust Europe (HTE) and other procurement partners as appropriate to support the timely production and management of data requirements.

Actively contribute in the continuous review, development and improvement of systems, processes and services in support of the Trusts commitment to a comprehensive and coordinated approach to procurement.

Ability to think quickly and respond to requests for information with accurate detail, often within short timescales.

Create and maintain good working relationships with internal customers providing advice and guidance on matters relating to the management of data.

Analyses complex data streams often from multiple organisations as part of HPL.

Facilitates the collection of data from new sources, and interprets data as appropriate.

Inputs and manipulates data using appropriate systems and databases including design and improvement of database usage

Maintains comprehensive, up to date and accurate databases, in line with agreed processes.

Ability to interpret supplier data and information with a knowledge and understanding of products and services used within a healthcare setting.

Ability to categorise expenditure by various formats including but not limited to supplier, category, e-class, subjective codes to create work plan data and information.

Ability to convert raw data into meaningful and understandable information.

Produce data reports that aid product/service demand forecasting and projections in order to measure and monitor performance as well as aid sound business decision making.

Support with the development of KPI reports that provide detailed information on performance and early warning indicators.

To contribute to the ongoing development and monitoring of departmental performance indicators including but not limited to those identified in the HPL strategy and the Lord Carter report.

Flag data areas identified as an area for concern against set and agreed service targets, using projections and predictions to highlight potential issues early so intervention can take place.

Support with the development, issuing and collation of customer satisfaction surveys and preparing the results to ensure that they are in a presentable and understandable format.

General Duties

To ensure that when creating, managing and sharing information records it is done in an appropriate way, subject to statutory requirements and agreed security and confidentiality policies, procedures and guidelines. All employees are responsible for implementing and maintaining data quality, ensuring that records are legible and attributable and that the record keeping is contemporaneous

To adhere to relevant Code of Practice of Professional body (if appropriate)

The post holder must be flexible in the duties performed and it is expected that similar duties, not specifically listed above, will be carried out as required and may be cross site.

The duties contained in this job description are not intended to be exhaustive. The duties and responsibilities of this post are likely to evolve in line with the Trusts continued organisational development.

Job description

Job responsibilities

The post holder will be required to develop intelligent dashboards that will allow colleagues across all HPL organisations a one stop shop to access real time information relating to the performance and delivery of the procurement service.

  • To support the strategic direction of Health Procurement Liverpool by creating and maintaining robust repeatable processes for all procurement-based data.
  • To provide information to support procurement projects via the maintenance and update of spend analysis from all available sources.
  • Assist Procurement colleagues in the efficient requesting and processing of data for : baseline, tender evaluation, contract award, catalogue update/uploads, monthly KPIs and ongoing monitoring to enhance compliance;
  • Contribute to the sharing of best practice within the Procurement team so that both internal and external data sources are engaged in an effective and consistent way.
  • Support database and system developments within the department including but not limited to the trusts contracts database and procurement dashboards;
  • Support in the collation, analysis and submission of nationally required data in a timely and effective manner;
  • Support with data collection and procurement response to all trust(s) FOI requests;
  • To work professionally aligned with the trusts informatics team in supporting the development of procurement dashboards and reports to support the delivery of the procurement strategy

Responsibilities

Collates, interprets and presents data to support the development and implementation of the Health Procurement Liverpool Strategy and provide management information to support initiation and monitoring of procurement projects

Assists the Procurement team(s) to identify savings and better practice opportunities across a range of projects.

Develops professional and intelligent dashboards that can be used both internally and externally;

Supports Procurement Managers through the collation and analysis of data and to provide relevant and innovative formats of Management Information: supporting the baseline process, providing evaluation techniques throughout the procurement process, ensuring robust data collection techniques enabling efficient creation of catalogues and monitoring compliance to all contracts, and ensuring effective data management at all times.

Ensures Trust/Supplier data is routinely received in line with business processes, and effectively managed to meet multiple outputs.

Monitors purchasing trends across the Trust, to develop category knowledge and aid the collation of market intelligence.

Provides information for the Senior Management Team to support their decision making in realising efficient business processes in re-engineering the supply chain

Provides information to support the submission of data in relation to Carter Metrics and associated procurement league tables and develops appropriate dashboards for both internal and external use.

Ensures learning from own projects is shared within the Procurement team, and the wider organisation, through active promotion of tools and techniques.

Provides input to the development and implementation of the Procurement Systems Strategy, with particular emphasis on data collection methodologies and management information tools and techniques.

Supports the P2P & Data Lead for all trust freedom of information requests (FOIs) relating to procurement information, ensuring that accurate procurement data and information is returned in a timely manner to support the trust(s) responses to FOI requests.

Source, analyse and deliver timely, high-quality complex data to senior procurement team members to support the delivery of the annual procurement CIP reports and ongoing data analysis to support new CIP schemes identified throughout the year;

Produce on a monthly basis the departments Key Performance Indicators incorporating changes and amendments as determined by the senior management team;

Generate and analyse data to meet the requirements of any local and national initiatives to include, but not limited to, Sustainability and Transformation Plans (STP) and Local Delivery Systems (LDS), the Lord Carter Recommendations as detailed in the report Review of Operational Productivity in NHS Providers along with the associated Model Hospital initiatives to maximise procurement opportunities, the Nationally Contracted Products Programme and the Procurement Partnership Board as established by HealthTrust Europe

Brings together multiple data sets from a number of organisations to support the accurate categorisation and development of a short, medium and long term procurement work plan.

Support the P2P & Data Lead for the development and delivery of procurement specific training packages across the HPL supported by the use of data analysis and specific dashboards to ensure that users maximise procurement opportunities and obtain value for money in all non-pay related spend.

Support the P2P & Data Lead with Catalogue Management and the development/uploading into systems also challenging the non-use of catalogues in order to reduce the requirement for non-catalogue requests.

Communication

Develops appropriate relationships with external suppliers to ensure automated data capture of sales information, with regular monitoring, and appropriate development for use of management information.

Provide outputs to the Procurement team to track benefits realisation, supporting the baseline process through best use of appropriate data.

Through the provision and interpretation of data, supports the Purchasing/ catalogue and compliance staff to improve business processes, aid product standardisation and enhance service development option appraisals.

Investigates and resolves queries and discrepancies.

Ensures reporting timetables are met through planning and organising workload.

Highlights opportunity for changes to working practices and procedures.

Manages own workload and contributes to team effort in support of other colleagues.

To continually review operational performance ensuring optimum resource levels to deliver customer expectations and maximise savings opportunities.

Ability to present (both verbally and visually) complex data and information to an audience of internal and external colleagues and use appropriate software/systems to support.

Contributes to relationships with NHS Supply Chain (NHS SC), Crown Commercial Services (CCS), HealthTrust Europe (HTE) and other procurement partners as appropriate to support the timely production and management of data requirements.

Actively contribute in the continuous review, development and improvement of systems, processes and services in support of the Trusts commitment to a comprehensive and coordinated approach to procurement.

Ability to think quickly and respond to requests for information with accurate detail, often within short timescales.

Create and maintain good working relationships with internal customers providing advice and guidance on matters relating to the management of data.

Analyses complex data streams often from multiple organisations as part of HPL.

Facilitates the collection of data from new sources, and interprets data as appropriate.

Inputs and manipulates data using appropriate systems and databases including design and improvement of database usage

Maintains comprehensive, up to date and accurate databases, in line with agreed processes.

Ability to interpret supplier data and information with a knowledge and understanding of products and services used within a healthcare setting.

Ability to categorise expenditure by various formats including but not limited to supplier, category, e-class, subjective codes to create work plan data and information.

Ability to convert raw data into meaningful and understandable information.

Produce data reports that aid product/service demand forecasting and projections in order to measure and monitor performance as well as aid sound business decision making.

Support with the development of KPI reports that provide detailed information on performance and early warning indicators.

To contribute to the ongoing development and monitoring of departmental performance indicators including but not limited to those identified in the HPL strategy and the Lord Carter report.

Flag data areas identified as an area for concern against set and agreed service targets, using projections and predictions to highlight potential issues early so intervention can take place.

Support with the development, issuing and collation of customer satisfaction surveys and preparing the results to ensure that they are in a presentable and understandable format.

General Duties

To ensure that when creating, managing and sharing information records it is done in an appropriate way, subject to statutory requirements and agreed security and confidentiality policies, procedures and guidelines. All employees are responsible for implementing and maintaining data quality, ensuring that records are legible and attributable and that the record keeping is contemporaneous

To adhere to relevant Code of Practice of Professional body (if appropriate)

The post holder must be flexible in the duties performed and it is expected that similar duties, not specifically listed above, will be carried out as required and may be cross site.

The duties contained in this job description are not intended to be exhaustive. The duties and responsibilities of this post are likely to evolve in line with the Trusts continued organisational development.

Person Specification

Qualifications

Essential

  • A good standard of general education incl. GCSE Maths and English or equivalent
  • Evidence of CPD in data analytics and or business intelligence (e.g. SQL, statistics, visualisation software e.g. power BI, Qlik, Tableau).

Desirable

  • Information Technology qualification or relevant experience.

Experience

Essential

  • Specialist knowledge of:
  • Writing SQL queries;
  • Experience using power BI tools;
  • Experience of developing Extract Transform Load (ETL) solutions and design data warehouse structures
  • Advance knowledge of Microsoft applications & Excel, contract and compliance monitoring tools
  • Data mining and interpretation skills
  • Change management
  • Team based working
  • Business intelligence
  • Highly developed PC skills
  • IT literate with data/information management (evaluation, analysis, reporting and archiving skills)
  • Programme and project management
  • Knowledge of procurement processes and procedures in a public sector environment
  • Advanced organisational skills
  • Managing complex data and information
  • Managing/collating data to support freedom of information requests
  • Demonstrates ability to motivate team performance to achieve objectives
  • Ability to plan and prioritise workload
  • Good communication skills - verbal, written, IT
  • Ability to communicate with a wide group of stakeholder across multiple organisations
  • Fully conversant with the application and operation of e-procurement systems
  • Ability to respond to requests promptly and provide accurate information in easily readable formats.

Desirable

  • Experience of working in a procurement department.
  • Finance system awareness
  • Interest in assessing new technology capabilities
  • Production and delivery of training to groups of staff
  • Database management
  • Project management
  • Knowledge of procurement and supply chains within the NHS
  • Knowledge of catalogue solutions
  • Knowledge of FOI processes and requirements
  • Presentation skills.
Person Specification

Qualifications

Essential

  • A good standard of general education incl. GCSE Maths and English or equivalent
  • Evidence of CPD in data analytics and or business intelligence (e.g. SQL, statistics, visualisation software e.g. power BI, Qlik, Tableau).

Desirable

  • Information Technology qualification or relevant experience.

Experience

Essential

  • Specialist knowledge of:
  • Writing SQL queries;
  • Experience using power BI tools;
  • Experience of developing Extract Transform Load (ETL) solutions and design data warehouse structures
  • Advance knowledge of Microsoft applications & Excel, contract and compliance monitoring tools
  • Data mining and interpretation skills
  • Change management
  • Team based working
  • Business intelligence
  • Highly developed PC skills
  • IT literate with data/information management (evaluation, analysis, reporting and archiving skills)
  • Programme and project management
  • Knowledge of procurement processes and procedures in a public sector environment
  • Advanced organisational skills
  • Managing complex data and information
  • Managing/collating data to support freedom of information requests
  • Demonstrates ability to motivate team performance to achieve objectives
  • Ability to plan and prioritise workload
  • Good communication skills - verbal, written, IT
  • Ability to communicate with a wide group of stakeholder across multiple organisations
  • Fully conversant with the application and operation of e-procurement systems
  • Ability to respond to requests promptly and provide accurate information in easily readable formats.

Desirable

  • Experience of working in a procurement department.
  • Finance system awareness
  • Interest in assessing new technology capabilities
  • Production and delivery of training to groups of staff
  • Database management
  • Project management
  • Knowledge of procurement and supply chains within the NHS
  • Knowledge of catalogue solutions
  • Knowledge of FOI processes and requirements
  • Presentation skills.

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Additional information

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

The Walton Centre NHS Foundation Trust

Address

The Walton Centre

Lower Lane

Liverpool

L9 7LJ


Employer's website

https://www.thewaltoncentre.nhs.uk/ (Opens in a new tab)


Employer details

Employer name

The Walton Centre NHS Foundation Trust

Address

The Walton Centre

Lower Lane

Liverpool

L9 7LJ


Employer's website

https://www.thewaltoncentre.nhs.uk/ (Opens in a new tab)


For questions about the job, contact:

P2P & Data Lead

Adam Campbell

adam.campbell7@nhs.net

Date posted

22 May 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£27,055 to £32,934 a year

Contract

Permanent

Working pattern

Full-time

Reference number

C9160-427600

Job locations

The Walton Centre

Lower Lane

Liverpool

L9 7LJ


Supporting documents

Privacy notice

The Walton Centre NHS Foundation Trust's privacy notice (opens in a new tab)