Dorset HealthCare University NHS Foundation Trust
Dorset HealthCare NHS Trust Estates and Facilities-Data &Performance reporting review and refinement
17 Incomplete applications
14 SME, 3 large
8 Completed applications
7 SME, 1 large
Important dates
- Published
- Thursday 10 June 2021
- Deadline for asking questions
- Monday 14 June 2021 at 11:59pm GMT
- Closing date for applications
- Thursday 17 June 2021 at 11:59pm GMT
Overview
- Specialist role
- Business analyst
- Off-payroll (IR35) determination
- Summary of the work
- Dorset HealthCare are looking for a Technical Business Analyst to support the Estates and Facilities function with Data and reporting refinement with the final output of a series of interactive dashboards and reports to enhance their customer service.
- Latest start date
- Monday 28 June 2021
- Expected contract length
- Between 6 and 8 months
- Location
- South West England
- Organisation the work is for
- Dorset HealthCare University NHS Foundation Trust
- Maximum day rate
- Total budget for project completion is £70,000 including VAT and include all agency fees and expenses.
About the work
- Early market engagement
- NONE
- Who the specialist will work with
- The Senior Leadership team of the Estates and Facilities department as well as the CAFM manager, the head of estates and the head of property.
- What the specialist will work on
-
The specialist shall be required to familiarise themselves with the current systems, processes and procedures utilised within the Estates Department.
This requires a comprehensive understanding of complex information gathering techniques as well as BPMN process mapping and dimensional modelling to develop a clear insight into the compliance and performance achieved by the Estates dept including individual team members.
This role is pivotal in providing analysis and design of the data structure that will be handed over to the development team. This will then be used as the primary source to create a series of dashboards and reports.
Work setup
- Address where the work will take place
- The specialist can be home based but may be required to access properties across Dorset
- Working arrangements
- The working arrangements will be required to suit the progress of the project, therefore requires flexibility to deliver the project, whilst being mindful of other conflicting draws upon the leadership resource.
- Security clearance
- No, however some data may be of a sensitive nature and require discretion
Additional information
- Additional terms and conditions
Skills and experience
Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.
- Essential skills and experience
-
- Ability to use CAFM systems to support a move within the directorate from management by presenteeism, to management by output.
- Ability to providing a clear insight into compliance activities by discipline achieved within a directorate.
- Ability to create compliance reporting including the completion of remedial activity against compliance checks to ensure that they are achieved within a specified timescale.
- Ability of collecting and using data that will assess the performance of teams or individual staff. The aim shall be to ensure the most efficient service is delivered.
- Ability to develop the use of existing under-utilised systems. We have a system for Leases and licences where we believe performance can be improved.
- Proficient in the use of MS Teams
- Proficient in the use of Teamwork Projects
- Proficient in the use of Teamwork Desk
- Proficient in the use of SQL Management Studio
- Be highly skilled in the transformation of non-technical requirements to high technical documentation and the ability to translate those requirement both verbally and in writing to varying levels of user
- Ability to create documentation to support data warehouse dimensional modelling
- Ability to create BPMN process diagrams
- Ability to define, document and communicate Analytical and statistical data to key stakeholder
- Nice-to-have skills and experience
-
- Evidence similar work for other organisations
- Demonstrate a proven background in this field
- Confirm they have worked within the NHS previously in similar roles
How suppliers will be evaluated
All suppliers will be asked to provide a work history.
- How many specialists to evaluate
- 3
- Cultural fit criteria
-
- work as a team with our organisation and other suppliers
- be transparent and collaborative when making decisions
- have a no-blame culture and encourage people to learn from their mistakes
- take responsibility for their work
- share knowledge and experience with other team members
- challenge the status quo
- be comfortable standing up for their discipline
- can work with clients with low technical expertise
- Additional assessment methods
-
- Interview
- Scenario or test
- Evaluation weighting
-
Technical competence
65%Cultural fit
5%Price
30%
Questions asked by suppliers
- 1. Is there a current incumbent or preferred supplier?
- We can confirm that there is not an incumbent or a preferred supplier.
- 2. Could you confirm the IR35 status please?
- We can confirm that this role is outside IR35.
- 3. Is there an incumbent in the role and also please confirm the IR35 Status?
- We can confirm that there is not an incumbent or a preferred supplier and that this role is outside IR35.
- 4. Hi there, please could you state whether this role is inside or outside IR35? Thank you in advance
- We can confirm that this role is outside IR35
- 5. Does IR35 apply?
- We can confirm that this role is outside IR35
- 6. Can I send more than one applicant across?
- You can recommend more than one applicant.
- 7. Will you accept experience of other similar products (e.g. MS Project) or do specialists need to have experience of Teamwork Project and Teamwork Desk
- We do need all applicants to be able to meet the must criteria as set out in the advertisement.
- 8. Please can you provide the outcome of the IR35/CEST/Off-payroll determination that would have been done for this role?
- We can confirm that this role is outside IR35
- 9. Is there an incumbent/preferred supplier for this role?
- We can confirm that there is not an incumbent or a preferred supplier.
- 10. Is there an expectation that the candidate will be asked to implement change to the processes following the analysis of the compliance and performance of team members?
- No, this will fall to the developers to do however if the candidate has Dev, Power Bi skills then they might look to create a proof of concept although this is not expected.
- 11. What are the expected data inputs for the Dashboards and Reports?
- The data inputs vary from project to project and could be direct linked server connections, csv extracts Web-service connections etc
- 12. Can I send more than one applicant across?
- Apologies, it has just come to light that the information first posted in answer to this question is inaccurate. As part of the framework rules, only one applicant is permitted to be submitted. So please ensure the most compatible and suitable applicant is put forward for the role.
- 13. Where do we submit CV’s to?
- For technical issues please contact the Crown Commercial Service on the email address as follows cloud_digital@crowncommercial.gov.uk