Awarded to Futures

Start date: Monday 2 August 2021
Value: £70,000
Company size: SME
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

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


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
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
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
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


Cultural fit




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