Job summary
An excellent opportunity has become available in the procurement department for a hardworking and dedicated Procurement Analyst at Sheffield Teaching Hospitals (STH). The trust requisite to analyse and assimilate data has grown in recent years and the need for additional support has become more evident. We have an ambitious programme of improvement which will focus the need for new systems to increase internal productive efficiencies. This will in turn deliver significant improvements to front line services in all areas of the trust.
Main duties of the job
The post holder will take lead in data analytics and assist the Procurement Efficiency Manager and others. This will include validating, analysing, interpreting, presenting and promoting the data within and outside the Trust. The post holder will also provide support to the Procurement Director and other senior colleagues, in providing detailed analysis describing the deliverables or end-benefits that are expected to accrue through various projects, identify the appropriate clinical and non-clinical metrics to illustrate this. The post holder will have excellent data analytical skills.
About us
You will be working for an organisation which values and respects all of its staff and the community it serves. The Trust is a leader in the NHS and research sectors and provides excellent benefits for its staff. This includes commitments to professional development but also many policies to support employees in balancing their personal and professional lives.
The Procurement department provides procurement and supply chain services to the Trust. The departments procurement teams take responsibility for developing strategies to meet the procurement needs of individual directorates and the Trust as a whole, and for delivering measurable savings from revenue expenditure in line with the Trusts formal Savings Plan. An exciting opportunity has arisen for an analyst to join the Procurement department; a role which will be pivotal in delivering substantial savings to the Trust.
Job description
Job responsibilities
- To process complex financial and statistical data to produce user-friendly reports about the cost and usage of goods and services, by interrogating the Trust I.T. systems using appropriate software tools, and liaising with external parties to collect other relevant data.
- To produce Savings Report for Director of Procurement, showing actual and forecast performance against Business Plan targets over any required period. Provide summary on key elements of the numbers.
- To provide detailed costing and expenditure information to a range of budget holders, budget managers, and Finance colleagues for general departmental use.
- Mentor the Deputy Procurement Analyst and Assistant Analyst in their development of analysis and reporting.
- Influence the selection and procurement of medical and non-medical consumables.
- Manage and maintain the Trusts catalogue and contract data, working alongside the Contracts teams, external catalogue management companies and suppliers to ensure the integrity of data as part of the Purchase to Pay and Inventory Management process is as robust as physically possible.
- Understanding that Invoice queries are a key scoring criteria and the benchmark of success when measuring the successful implementation of the Trusts Catalogue. Taking responsibility for the reduction of invoice queries.
- To support other Procurement colleagues in financial and analytical aspects of contract negotiations with suppliers, participating in negotiations when required.
- To co-ordinate response to requests for data from outside the department (other internal departments, HTE, NHS CPC, Office of Government Commerce, NHS Improvement, Department of Health et. al) leading to identification of savings opportunities.
- To represent the Trust on behalf of the Procurement Efficiency Manager at conferences and when meeting external IT suppliers and external end users (both public and private sector) and to provide reports on system demonstrations and meetings, building relationships and projecting a positive image of the trust and the department.
- To assist the Procurement Efficiency Manager in the procurement of systems and upgrades such as Purchase to Pay, Inventory Management, e-tendering and contract management solutions.
- To develop and maintain a comprehensive supplier database to support strategic work on Sustainability and other Socio-economic objectives.
- To work closely with the Clinical Procurement Specialist in order to identify potential products and ranges that can be rationalised in order to simplify and improve Supply Chain for individual departments and the Trust as a whole.
- Maintain a sound knowledge of Trust Standing Financial Instructions, Standing Orders and EU Procurement regulations in order to ensure that systems, processes and the actions of the jobholder comply.
- Manage and maintain databases and reference files within the Purchase Order, Inventory Management, SharePoint collaboration and e-Tendering systems.
- Utilise information technology systems provided by the Trust and other organisations, including MS Excel, Access, Integra Finance system, NHS Supply Chain software, PPIB, Procurement Dashboard, Docushare, e-tendering and catalogue management systems.
- To assist the Procurement Efficiency Manager to create and maintain a public website.
- To manage and act as the communication arm of the Procurement Department, disseminating reports on an ad hoc / Weekly / Monthly basis commensurate to Trust requirements, ensuring information is accurate and fit for purpose.
- To provide specialist process mapping support to the Procurement Department.
- Ensure data supplied by assistant analysts are robust and fit for purpose.
- Actively contribute to the eProcurement Team agenda to promote a culture of continuous improvement.
Please view the attached Job Description and Person Specification documents for full details regarding this post.
Job description
Job responsibilities
- To process complex financial and statistical data to produce user-friendly reports about the cost and usage of goods and services, by interrogating the Trust I.T. systems using appropriate software tools, and liaising with external parties to collect other relevant data.
- To produce Savings Report for Director of Procurement, showing actual and forecast performance against Business Plan targets over any required period. Provide summary on key elements of the numbers.
- To provide detailed costing and expenditure information to a range of budget holders, budget managers, and Finance colleagues for general departmental use.
- Mentor the Deputy Procurement Analyst and Assistant Analyst in their development of analysis and reporting.
- Influence the selection and procurement of medical and non-medical consumables.
- Manage and maintain the Trusts catalogue and contract data, working alongside the Contracts teams, external catalogue management companies and suppliers to ensure the integrity of data as part of the Purchase to Pay and Inventory Management process is as robust as physically possible.
- Understanding that Invoice queries are a key scoring criteria and the benchmark of success when measuring the successful implementation of the Trusts Catalogue. Taking responsibility for the reduction of invoice queries.
- To support other Procurement colleagues in financial and analytical aspects of contract negotiations with suppliers, participating in negotiations when required.
- To co-ordinate response to requests for data from outside the department (other internal departments, HTE, NHS CPC, Office of Government Commerce, NHS Improvement, Department of Health et. al) leading to identification of savings opportunities.
- To represent the Trust on behalf of the Procurement Efficiency Manager at conferences and when meeting external IT suppliers and external end users (both public and private sector) and to provide reports on system demonstrations and meetings, building relationships and projecting a positive image of the trust and the department.
- To assist the Procurement Efficiency Manager in the procurement of systems and upgrades such as Purchase to Pay, Inventory Management, e-tendering and contract management solutions.
- To develop and maintain a comprehensive supplier database to support strategic work on Sustainability and other Socio-economic objectives.
- To work closely with the Clinical Procurement Specialist in order to identify potential products and ranges that can be rationalised in order to simplify and improve Supply Chain for individual departments and the Trust as a whole.
- Maintain a sound knowledge of Trust Standing Financial Instructions, Standing Orders and EU Procurement regulations in order to ensure that systems, processes and the actions of the jobholder comply.
- Manage and maintain databases and reference files within the Purchase Order, Inventory Management, SharePoint collaboration and e-Tendering systems.
- Utilise information technology systems provided by the Trust and other organisations, including MS Excel, Access, Integra Finance system, NHS Supply Chain software, PPIB, Procurement Dashboard, Docushare, e-tendering and catalogue management systems.
- To assist the Procurement Efficiency Manager to create and maintain a public website.
- To manage and act as the communication arm of the Procurement Department, disseminating reports on an ad hoc / Weekly / Monthly basis commensurate to Trust requirements, ensuring information is accurate and fit for purpose.
- To provide specialist process mapping support to the Procurement Department.
- Ensure data supplied by assistant analysts are robust and fit for purpose.
- Actively contribute to the eProcurement Team agenda to promote a culture of continuous improvement.
Please view the attached Job Description and Person Specification documents for full details regarding this post.
Person Specification
Education and Qualifications
Essential
- Degree in any subject or extensive experience in an analytical post. GCSE Maths and English C Grade or above
- A-Levels or equivalent standard qualification
Desirable
- MBA or MSC, Chartered Institute of Purchasing and Supply Diploma
Experience
Essential
- Substantial experience of interpreting analytical data as a major part of responsibilities
- Experience of managing/using SharePoint portal
- Willing to study SQL report writing as part of responsibilities
- Experience of managing systems
- Experience of supporting and delivering projects
- MS Excel at advanced level.
- Ability to work with figures and demonstrate numeracy
- Understanding of the need for accurate information systems
Desirable
- Experience of writing SQL reports and use of automation (excel Macros)
- Experience of working in Procurement setting
- Experience of dealing with Senior Stakeholders
- Experience of eProcurement landscape
- An understanding of the purchase to pay lifecycle
Personal Qualities
Essential
- Ability to identify shortfalls in processes and rectify
- Ability to communicate complex statistical information to senior managers
- Ability to learn new software solutions quickly
- Highly numerical with an analytical mind-set.
- Well-developed communication skills, verbal and written
- Ability to work to conflicting deadlines and prioritise own workload
Skills and Knowledge
Essential
- Ability to validate data and produce accurate statistical reports
- Basic management / supervision training
- SharePoint Power Query
- Report writing and Dashboard creation skills
Desirable
- Commercial negotiation training
- Project Management training
Person Specification
Education and Qualifications
Essential
- Degree in any subject or extensive experience in an analytical post. GCSE Maths and English C Grade or above
- A-Levels or equivalent standard qualification
Desirable
- MBA or MSC, Chartered Institute of Purchasing and Supply Diploma
Experience
Essential
- Substantial experience of interpreting analytical data as a major part of responsibilities
- Experience of managing/using SharePoint portal
- Willing to study SQL report writing as part of responsibilities
- Experience of managing systems
- Experience of supporting and delivering projects
- MS Excel at advanced level.
- Ability to work with figures and demonstrate numeracy
- Understanding of the need for accurate information systems
Desirable
- Experience of writing SQL reports and use of automation (excel Macros)
- Experience of working in Procurement setting
- Experience of dealing with Senior Stakeholders
- Experience of eProcurement landscape
- An understanding of the purchase to pay lifecycle
Personal Qualities
Essential
- Ability to identify shortfalls in processes and rectify
- Ability to communicate complex statistical information to senior managers
- Ability to learn new software solutions quickly
- Highly numerical with an analytical mind-set.
- Well-developed communication skills, verbal and written
- Ability to work to conflicting deadlines and prioritise own workload
Skills and Knowledge
Essential
- Ability to validate data and produce accurate statistical reports
- Basic management / supervision training
- SharePoint Power Query
- Report writing and Dashboard creation skills
Desirable
- Commercial negotiation training
- Project Management training
Additional information
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).
