Data Analyst

Job description

Job responsibilities

Job Purpose

1. Providing data and business intelligence insights to the SOEPS Procurement Team to support strategic and operational procurement decisions and activities.

2. Analysing supplier spend &PO/Non-PO transactional data, identifying contractual leakage & spending trends.

3. Developing spend, contract management, cost saving and SLA/KPI dashboards and reports using data visualisation tools (PowerBI)

4. Managing data, data classification/cleansing and applying standards and data structures to develop actionable procurement intelligence and insights

5. Generating value from data, extract insights and collate data from various sources to inform strategies, planning pipelines and identify new opportunities and priorities.

6. Promoting the use of procurement data in wider initiatives and business decisions to enable competitive sourcing decisions.

7. The implementation of effective procurement data structures, for spend, contracts, tendering and supplier data, among others while developing strategies for delivering year-on-year incremental value through the use of data.

8. Collaborate with the Team and wider stakeholders to profile data users and their requirements to ensure information is presented and reported in a way stakeholder can interpret and promotes action.

The post holder will:

1. Proactively and positively contribute to the successful overall performance of the Trust.

2. Deliver excellent levels of customer service to all patients/visitors and staff at the Trust.

3. Act as an advocate for the Trust & its contribution to the Health Service arena through creating and maintaining effective partnerships and relationships with staff, patients and the general public.

4. Develop and support the Trust culture of collaborative, flexible cross-team working and commitment to delivering quality services and outcomes, which maintain the Governments policies on public health.

5. Work with sensitivity and an understanding of the issues facing those working to deliver health services to the UK population.

6. Comply with corporate governance structure in keeping with the principles and standards set out by the Trust.

7. Develop effective ways of working and create strong partnerships and relationships with all stakeholders to support the implementation of the Governments policies on Health.

8. If your employment is to a post that requires you to be registered with a professional body, the continuation of your employment is conditional upon you continuing to be registered with the appropriate professional body. The Trust will require evidence of current registration

9. In compliance with the Trust's practices and procedures associated with the control of infection, you are required to:

10. Adhere to Trust Infection Control Policies assuring compliance with all defined infection control standards at all times.

11. Protect patients, staff and visitors from infection by performing hand hygiene when entering or leaving clinical areas and after each contact with a patient or patients equipment.

Specific Core Functions

1. Be responsible for analysing spend data with suppliers to be able to help predict future spend patterns, non-purchase order spend or identify contractual leakage

2. Maintaining assigned data sets, establishing and developing standards for data management, such as protocols for uploading data to systems, and tracking their effectiveness and usage.

3. Classify, cleanse and maintain assigned data sets, establish and develop standards for data management, such as protocols for uploading data to systems, and track their effectiveness and usage.

4. Design effective procurement data structures, for spend, contracts, tendering and supplier data, among others.

5. Support the development of strategies for delivering year-on-year incremental value through the use of data

6. Extract insights from data to inform strategies, planning and innovation pipelines; identify new opportunities and determine priorities.

7. Collate data from various sources to create reports, dashboards and visualisations that facilitate the easy and effective use of data by stakeholders.

8. Devise and apply models and algorithms to mine the available stores of big data.

9. Conduct competitor profiling, gap analyses and market analyses in key categories to support strategy development.

10. Profile internal data users and their requirements to ensure information is presented and reported in a way stakeholder can interpret and action.

11. Work with the IT department to ensure master data is appropriately structured, codified and cybercompliant.

12. Assist in the development of internal Central Business Services Team policies and procedures and improvements in how the Analytics & Business Intelligence team can better support the wider Procurement team and function.

13. Ad Hoc one off or longer-term special projects, as agreed with the Senior Managers within SoEPS Team.

Communications and Working Relationships

1. Communications will involve:

Face to face and by telephone

Within formal and informal meetings

Written, letters, , e-mail, and reports

2. Staff Groups will include:

Directorate Business Managers

Clinical and Associate Clinical Directors and other Clinicians

Executive and Non-Executive Directors

3. External:

Other NHS organisations

Government Procurement Solutions and other national framework providers

Suppliers

Person Specification

Personal Qualities

Essential

• Communicate (oral and written formats)
• Clearly manage priorities and tasks in order to meet timely deadlines
• Express information clearly and succinctly through the presentation
• of data in pivot tables, graphs, spreadsheets and reports
• See the bigger picture, offer challenge, identify opportunities to
• business challenges and implement improvements
• Customer focused
• Be responsive and to work flexibly and on an agile basis.

Skills and Knowledge

Essential

• Data modelling able to apply established techniques a to build effective data models.
• Knowledge of data and analytical tools, including advanced Excel and SQL.
• Knowledge and use of Data Visualisation tools such as PowerBI and able to produce intuitive data analysis, representations and reports.
• Uses analytical thinking and logical reasoning to spot patterns and draw conclusions and insights from data or observations.
• Able to incorporate many sources of information and perspectives to
• arrive at a coherent conclusion, bridging the divide between
• procurement needs and data availability.
• Divergent thinking: seeks new information and avenues of analysis to
• explore ideas freely. Holistic thinking: holds the big picture in mind
• without losing sight of the detail.
• Collaboration Active listening: fully engages in interactions to
• understand, interpret and evaluate.
• Influence and persuasion: the ability to simplify , communicate and
• influence diverse groups of stakeholders; and present complex data sets and recommendations.
• Storytelling engages audiences by presenting data in a compelling and intuitive way.

Desirable

• Business Acumen,appreciation of the business implications of decisions and situations.
• Good understanding: of procurement and supply chain processes.
• An understanding of Procure to pay procedures gained through
• working in a Procurement or Finance environment

Qualifications

Essential

• Educated to 5 GCSEs at C Level or equivalent

Desirable

• Graduate in data science, mathematics, computer science or statistics.
• Chartered Institute of Purchasing and Supply (degree level) or equivalent

Employer details

Employer name

Portsmouth Hospitals University NHS Trust

Address

Queen Alexandra Hospital

Southwick Hill Road

Cosham

Portsmouth

PO6 3LY

Employer's website

https://www.porthosp.nhs.uk/work-for-us/ (Opens in a new tab)