Job summary
This Commercial Procurement Data and Systems Manager role will support across all teams within within the Commercial Procurement Services function.
The post holder will be an integral part of the Commercial Procurement Business Operations team within the Procurement Services Function, supporting the Director of Procurement Services and Head of Commercial Procurement Business Operations with key procurement data and systems transformation deliverables across the all teams within the Commercial Procurement Services team, as well as supporting and leading key operational and strategic initiatives across North East London (NEL).
This is a key role to support the Director of Commercial Procurement Services and Head of Commercial Procurement Business Operations to assist with the implementation of the BHRUT vision and strategy for Commercial Procurement, as approved by the Trust Board, with a specific focus on continuous development, improvement and transformation across the entire spectrum of procurement data and systems.
This role will also be integral to supporting the Trust towards delivering a Best in Class Commercial Procurement Service for BHRUT and Integrated Collaboration across North East London (NEL) across the spectrum of procurement data and systems deliverables. To achieve this, the role will be central to managing and maintaining key relationships with internal and external stakeholders at all levels.
Main duties of the job
- SQL Development (advanced queries) ETL/SSIS/SSRS
- Hands on experience on MSBI technologies primarily (SQL, SSIS, Power BI)
- Work closely with business analysts and solution architects to implement MS SSIS ETL solutions.
- Actively participate in business requirements gathering sessions and understand client requirements.
- Datamodelling, database design, ETL, Azure (ADLS, ADF, ADB) and Microsoft BI Stack.
- Create, present and get sign-offs for design documents and unit test scenarios.
- Mentor team
- Optimize SQL server queries to efficiently and quickly retrieve data.
- Create and design best-practice data warehouse solutions that support business reporting tasks.
- Good and clear communication
- To develop and implement data pipelines that extracts, transforms and loads data into data products such as Azure Data lake, SQL databases, and Power BI.
- Ingesting, storing, processing, enriching and provisioning large data sets.
About us
Under the leadership of our Chair, Jacqui Smith and Matthew Trainer, our Chief Executive we provide care for the residents of three diverse London boroughs. More than half of our 7,500 strong workforce are from black, Asian and minority ethnic groups and most live in Barking and Dagenham, Havering and Redbridge. We also provide healthcare services to people in south-west Essex, and specialist neurosciences services to the whole of the county.
Our services include all the major specialties of large acute hospitals, operating from two main sites - King George Hospital in Goodmayes and Queen's Hospital in Romford. We also provide outpatient services at Brentwood Community Hospital, Barking Hospital, Loxford Polyclinic and Harold Wood Polyclinic.
We know we have more work to do to improve waiting times for urgent and emergency care, and this will be one of the many benefits of our closer collaboration with Barts Health. Working with them and with all our partners across north east London, we will find a sustainable solution to enhance patient care.
We are particularly proud of our regional Neurosciences Centre; Radiotherapy Centre; Hyper Acute Stroke Unit; and dedicated breast care service at King George Hospital. We're also pleased to be part of the NEL Cancer Alliance.
Job description
Job responsibilities
For further information on this role, please see the attached detailed Job Description and Person Specification.
The person specification listed below is not the full specification requirements for the role. Please ensure you review the full specification on the job description prior to submitting your application.
Applicants are advised to read all the information on the advert and the supporting information before completing and submitting an application. As you complete your application please ensure you clearly demonstrate how you meet the criteria in the person specification for this post by adequately completing the supporting information section of the application form.
All new staff appointed at the Trust are subject to a 6 month probationary period.
Applications should be made online, however, queries regarding the application process or assistance with completion of the form (for applicants with a disability) can be made to Stefan Heins, Recruitment Advisor, on 01708435000 ext 5933. Further details regarding the post may be obtained by contacting the manager as per the contact details above.
Job description
Job responsibilities
For further information on this role, please see the attached detailed Job Description and Person Specification.
The person specification listed below is not the full specification requirements for the role. Please ensure you review the full specification on the job description prior to submitting your application.
Applicants are advised to read all the information on the advert and the supporting information before completing and submitting an application. As you complete your application please ensure you clearly demonstrate how you meet the criteria in the person specification for this post by adequately completing the supporting information section of the application form.
All new staff appointed at the Trust are subject to a 6 month probationary period.
Applications should be made online, however, queries regarding the application process or assistance with completion of the form (for applicants with a disability) can be made to Stefan Heins, Recruitment Advisor, on 01708435000 ext 5933. Further details regarding the post may be obtained by contacting the manager as per the contact details above.
Person Specification
Education/ Qualifications
Essential
- Graduate qualification in a data and systems related field or equivalent experience.
Desirable
- Full Professional qualification in Chartered Institute of Procurement and Supply (MCIPS) or equivalent full qualification and membership or equivalent experience
- Prince 2 Project Management qualification or equivalent
Skills/ Abilities
Essential
- Strong visible leadership style; providing professional leadership by leading by example with the ability to work in a matrix structure as both an effective team member and inspirational team leader.
- High level of IT skills and excellent working knowledge of various MS packages Excellent presentation skills
- Proficient in SQL, and Cloud based analytical tools like Power BI or Clikview or Tableau
Experience/ Knowledge
Essential
- Hands on experience in Requirement gathering, writing functional specification and Data flows
Desirable
- Experience of leading risk management and risk mitigation plans relating to commercial procurement; specifically experience of leading on ensuring and assuring that the Trust is not exposed to financial, service or reputational risk as a result of commissioning, procurement and contract management activities.
Person Specification
Education/ Qualifications
Essential
- Graduate qualification in a data and systems related field or equivalent experience.
Desirable
- Full Professional qualification in Chartered Institute of Procurement and Supply (MCIPS) or equivalent full qualification and membership or equivalent experience
- Prince 2 Project Management qualification or equivalent
Skills/ Abilities
Essential
- Strong visible leadership style; providing professional leadership by leading by example with the ability to work in a matrix structure as both an effective team member and inspirational team leader.
- High level of IT skills and excellent working knowledge of various MS packages Excellent presentation skills
- Proficient in SQL, and Cloud based analytical tools like Power BI or Clikview or Tableau
Experience/ Knowledge
Essential
- Hands on experience in Requirement gathering, writing functional specification and Data flows
Desirable
- Experience of leading risk management and risk mitigation plans relating to commercial procurement; specifically experience of leading on ensuring and assuring that the Trust is not exposed to financial, service or reputational risk as a result of commissioning, procurement and contract management activities.
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.
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.
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).
