Awarded to Draper and Dash Ltd

Start date: Wednesday 1 June 2022
Value: £340,000
Company size: SME
South London and Maudsley NHS Foundation Trust

Informatics Strategic Business Partnership : Power BI Visualisation

16 Incomplete applications

12 SME, 4 large

35 Completed applications

31 SME, 4 large

Important dates

Published
Wednesday 29 December 2021
Deadline for asking questions
Wednesday 5 January 2022 at 11:59pm GMT
Closing date for applications
Wednesday 12 January 2022 at 11:59pm GMT

Overview

Off-payroll (IR35) determination
Contracted out service: the off-payroll rules do not apply
Summary of the work
Visulaisations in PowerBI
Requirements Gathering
Testing and validation
Process review and SOP creation
Data Assurance and Quality management and reporting
Latest start date
Tuesday 1 February 2022
Expected contract length
2 years
Location
London
Organisation the work is for
South London and Maudsley NHS Foundation Trust
Budget range
Up to £180,000

About the work

Why the work is being done
The Trust are implementing a new 5-year strategy with some ambitious goals. To support this strategy the Trust needs to be collating data from the many source systems in use across the Trust into the Data Warehouse, bringing this data into an appropriate data architecture and then visualising this data back to show the impact of the changes made to achieve the Trusts goals.

There is also an initiative to improve the Trusts Data Assurance and improve data quality.

The complexity of the data, the number of source systems where data is not available to the Data Warehouse, the need to improve the catalogues of approved metrics, the ever-changing landscape and building asks for data, the Informatics team requires the ability to work alongside strategic partners that can support flexing the workforce as needed to the areas where there is most need.
Problem to be solved
We are looking for ongoing support: estimated at 3 full time equivalents, who can be changed for individuals with appropriate skill sets as needed to support data modelling, creating certified datasets, metrics definition, requirements gathering, report visualisation and data and quality assurance. There is not a fixed delivery plan at present, so depending on trust priorities skilled resources will need to be able to be adapted to the current requirement.
These individuals need to understand national requirements and definitions to ensure that defined and agreed metrics support national guidance and reporting.
This needs to allow for an increase in available resources over the allocation at a fixed cost rate. Due to the ongoing requirements of the Trust, projects will be initiated as needed, and will depend on timeframes as to the level of resourcing that may be required, over the core 3 FTEs listed above.
Who the users are and what they need to do
As a customer I need to be able to call on additional resource to support the team when there is varying demand for Informatics service. This will provide the Trust with a faster transition and reduce reliance on individual contractors.
Early market engagement
None
Any work that’s already been done
None
Existing team
Supplier's main contacts will be the Associate Director of Informatics. The Trust has five separate Informatics teams: Informatics, Performance, Quality Improvement, Clinical Informatics, and the Biomedical Research Centre (BRC); and there is a shift to aligning these resources to ensure all teams work to the same data principles and processing.
Current phase
Not started

Work setup

Address where the work will take place
South London and Maudsly NHS Foundation Trust, Maudsley Hospital, Denmark Hill, Camberwell, London SE5 8AZ.
Working arrangements
Mainly off-site, with visits to our offices as required by the project.
Security clearance
Not required

Additional information

Additional terms and conditions
None

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
  • How is your organisation structured to manage the flexing of staff depending on the needs of the service.
  • Describe your documentation and handover methods, to ensure the incumbent team receive all the appropriate information to support the visualisations and models
  • It is essential the supplier has a robust assurance methodology. Describe how you maintain high standards.
  • Standardisation - Ability to rationalise data, reducing duplication, and standardising data so that everyone gets the same results.
Nice-to-have skills and experience
  • Describe with examples your ability to deliver at pace
  • Experience of sustainable provision and support, delivering on cost through effective and efficient design, providing future proofing

How suppliers will be evaluated

All suppliers will be asked to provide a written proposal.

How many suppliers to evaluate
3
Proposal criteria
  • Technical solution
  • Value for money
  • Approach and methodology
Cultural fit criteria
  • We are looking to appoint a partner company that can demonstrate to us that they are thinking about our future
  • Will need the expertise and experience to understand emerging technology that will make a difference to our user
  • While we want to be a leader in NHS technology, we also want to make sure we are only taking advantage of technology that adds true value
  • Works as a team with our organisation and other suppliers where necessaryWorks as a team with our organisation and other suppliers where necessary
  • Ready to challenge the status quo
  • Champions equality, diversity and digital inclusion
  • Is innovative and forward thinking
  • Shares knowledge and experience with clients
  • Provides honest and expert feedback
  • Uses innovative, cost effective techniques to engage website users
  • Takes responsibility for the quality of their work
  • Transparent and collaborative when making decisions
  • Works well with clients of varying technical expertise
  • Able to demonstrate the value of their approach and understands the value of data and analytics
Payment approach
Time and materials
Additional assessment methods
  • Case study
  • Reference
  • Presentation
Evaluation weighting

Technical competence

60%

Cultural fit

15%

Price

25%

Questions asked by suppliers

1. Is the £180K budget for the full two years? or just a portion of this contract length?
£180 k is per year maximum - in addition to the 3 WTE, there is the possibility for extra projects or resources will be funded as needed.
2. Is this tender applicable for small business with the required technology and skill sets?
Fine for small business, as long as have the skills needed to flex to what is required.
3. Can you please clarify the absence of Technology mentioned in description in the Essential and Nice to have skills ?
We use PowerBI, Azure Data Factory and SQL. Individuals for this role will mainly need to be skilled in PowerBi and Excel, working o predefined data sets. In some instances may need skills to create data sets. Also looking for people who can define requirements from users of our source systems.
4. Please could you provide some information around the existing Data Warehouse and the technologies in use?
We use Microsoft Data Factory as PaaS. SQL. Visualisation through PowerBI.
5. For the essential skills questions above, are you expecting a statement of methodology and standards, or evidence using a customer example, as per the DOS response guidance?
Customer example, as per the DOS response guidance?
6. In Cultural Fit, “Champions equality, diversity and digital inclusion’,
is this applicable for small business who are yet to formulate a DEI policy ?
In Cultural Fit, “Champions equality, diversity and digital inclusion’,
is this applicable for small business who are yet to formulate a DEI policy ?
Yes, you do not have to have a formal written ploicy in place
7. Can an SME with no prior NHS experience bid for the project ?
Of course, but experience of organisations like the NHS with similar cultures and habits would be an advantage
8. Can you please affirm if you have an SME champion in the organisation ?
This depends on what is being worked on. But in general we have an SME for each request.
9. Regarding “How is your organisation structured to manage the flexing of staff depending on the needs of the service ?” What is the amount of staff you need to flex and support the growing workload ?
What timelines do you plan to help enable expansion ?
How does this requirement SME to fairly compete against the big onshore suppliers ?
This is an unknown quantity and will depend on any given project that arises. It is unlikely to be more then 2 or 3 people at most for any project and more likely 1.
10. In the Essential Skills, can you please elaborate on “support the visualisations and models” ? What kind of models do you have and need support on ? Is it machine learning models or AI models or simple data analytics models ?
We would be looking for individuals to support building data models, and visualising data to requirements, possible defining the requirements.
11. Can we check who is the incumbent supplier for the project ?
There is no incumbent supplier, this is a new ask. At present we bring in indivudal consultants but this takes time to find individuals and get them up to speed, so we are trying to find an alternative way to manage this.
12. Can you please elaborate with examples on the Assurance Methodology and High standards ? Please provide some examples in the incumbent supplier.
We are trying to implement assurance methods including SOPS, Data Quality checks and process validation. We want to know what sorts of processes you use to ensure that what your team are providing is to a good standard and how you can help us improve our assurance.