Awarded to Incremental Group

Start date: Thursday 3 March 2022
Value: £358,030
Company size: SME
The Pensions Regulator

TPR Auto Enrolment Reporting MI & Optimisation

2 Incomplete applications

2 SME, 0 large

6 Completed applications

6 SME, 0 large

Important dates

Published
Monday 29 November 2021
Deadline for asking questions
Monday 6 December 2021 at 11:59pm GMT
Closing date for applications
Monday 13 December 2021 at 11:59pm GMT

Overview

Off-payroll (IR35) determination
Contracted out service: the off-payroll rules do not apply
Summary of the work
Extend our current Azure hosted reporting and MI capability to include TPRs Auto Enrolment (AE) service requirements. This will include capturing AE reporting requirements, designing a data warehouse (physical model) and implementing a selection of reports, and MI, as a prototype.
Latest start date
Monday 17 January 2022
Expected contract length
3 months +6 months(optional)
Location
No specific location, for example they can work remotely
Organisation the work is for
The Pensions Regulator
Budget range
Stage 1 £75,000- £140,00
Stage 2 (optional) £150,000- £280,00

About the work

Why the work is being done
TPR are moving into the next phase of its strategic roadmap, evolving the services and solutions that support AE. Since the original architecture and solutions were established, over the last 10 years, there has been significant change in how the AE services are delivered. This includes the recent transition of outsourced services and supporting technology into TPR.
Our next step is consolidating and rationalising AE data stores and reporting capabilities onto the TPR strategic solutioned (called Data Platform).
Problem to be solved
TPR has a new strategic Data Platform* that we are looking to extend into AE. We require a supplier to support the following deliverables in Stage 1 and Stage 2(Optional) :
 Capture requirements on how the business require to leverage data and information (inc. reports, MI/dashboards, etc.)
 Design new physical data models to support AE’s data reporting and analysis requirements
 Align the AE data model with other models within TPR
 Create a single version of the truth
 Implement real-time reporting and analytics
 Prototype a selection of reports and dashboards that will demonstrate the capability
 Ensure data is held in a structure that meets business needs and is optimised for MI and report writing
 Maintain business data integrity
 Optimise database design and storage to maximise efficiency
 Models take into account storage costs and data retention policies
 Create pipelines/transformation to structure data as required
 Provide models/schemas to support self-service reporting
 Meet security requirements, including at data level

* The Data Platform uses the following technologies:
• Azure Data Lake
• Azure Databricks
• Azure Synapse Analytics
• Azure SQL Server
• Azure CosmosDB
• Microsoft PowerBI
• Azure Functions
Who the users are and what they need to do
Reporting and MI capabilities are an enabler of the AE service. This is used by all UK employers, for declaration of their duties, and TPR staff who manage and support the AE service.

MI is widely used throughout TPR AE and broadly comprises these user bases:
1. Users who receive MI to inform decision making
2. Users who need to self-serve their own reports with some capability to manipulate and interrogate data
3. Power users who need to manipulate and interrogate data at a granular level
Early market engagement
Any work that’s already been done
The scoping and high-level definition of the data architecture has started, and we anticipate that we will have a high-level entity model for future architecture available by the time this work starts.

TPR has recently implemented a new Data Platform for the organisation and built several use cases outside of AE to demonstrate the functionality. We assume this will be the vehicle for delivery and implementation of the AE MI improvements.
Existing team
TPR has business and technical teams that will contribute to this work and will need to inherit and maintain following implementation.
Current phase
Not applicable

Work setup

Address where the work will take place
See below regarding remote working. If there are any face-to-face meetings or in-house workshop facilitation, it is likely to happen at this address.

The Pensions Regulator
Napier House
Trafalgar Place
Brighton
BN1 4DW
Working arrangements
We will work remotely with the team during developing. Facilitation of the workshops is also likely to be remote.
Occasional face to face meeting might be required at Brighton subject to agreement and circumstances.
Security clearance
DBS level clearance will be required for all personnel before commencement of the contract and the TPR reserves the right to require SC level depending on the nature work during the term of the engagement.

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
  • have the necessary skills and experience in designing enterprise data warehouses
  • have the necessary skills and experience in building MI and reports
  • have the necessary skills and experience in the technologies used by the TPR Data Platform
  • have the necessary skills and experience in the languages used by the TPR Data Platform i.e. T-SQL, Gremlin, etc.
  • have the necessary skills and experience in creating business data models from the Dynamics 365 Customer Service Dataversehave the necessary skills and experience in data standards
  • have the necessary skills and experience in identifying improvement opportunities
  • have the necessary skills and experience in evaluating options and recommendations for optimisation
  • have the necessary skills and experience to design, build and test MI and Reporting solutions
  • have the necessary skills and experience in data standards
  • have the necessary skills and experience of innovation and strategic thinking
  • have the necessary skills and experience in communicating with business stakeholders
  • have the necessary skills and experience of working as part of wider client team
Nice-to-have skills and experience

How suppliers will be evaluated

All suppliers will be asked to provide a written proposal.

How many suppliers to evaluate
5
Proposal criteria
  • Case Study/Work History of a similar project in the last 2 years
  • technical solution
  • Team structure
  • Stage 1 must be completed and accepted before 31st March 2022
Cultural fit criteria
  • work as a team with our organisation
  • be transparent and collaborative when making decisions
  • share knowledge and experience with our organisation
Payment approach
Fixed price
Additional assessment methods
  • Case study
  • Work history
  • Reference
Evaluation weighting

Technical competence

65%

Cultural fit

5%

Price

30%

Questions asked by suppliers

1. 01. Can you please confirm whether Q5 is one question or is meant to be two separate questions?:
“have the necessary skills and experience in creating business data models from the Dynamics 365 Customer Service Dataversehave the necessary skills and experience in data standards”
The last part of the question is typing mistake. Please ignore the "have the necessary skills and experience in data standards" part. Thank you for pointing it out.
2. Can you confirm if shortlisted suppliers will have the opportunity to present?
We are not planning for presentation session(s). The evaluation will be based on the written proposal.
3. Has any external supplier been involved in the initial scoping work? If so, who?
No, the scoping was done by TPR IT. A similar work is in progress with SSRA but not for AE.
4. Who from your team will be scoring applications for this opportunity and what positions do they hold?
The question is not relevant for 1st round of evaluation. TPR IT and Commercial will nominate a team for evaluation. In case you have confidentiality concerns the case study is aimed to evaluate competence and sensitive customer data should not be provided.
5. Can you please provide an anticipated timeline for this procurement that includes dates for: 1) Shortlisting Notification for Stage 2 2) Submission Deadline for Stage 2 3) Presentation 4) Evaluation period 5) Award Notification
Please note that the holiday season and internal resources will influence the dates below, therefore the information below is guidance only. Actual dates will be published after each phase is completed.
Publication of the 2nd round to shortlisted suppliers - 20th December. Submission deadline - 5th January. Target date for supplier to start work - 17th January.
We are still working on support to provide as much time for Q&A as possible.
6. Can you please advise if one supplier could be awarded all opportunities? Keen to understand why the opps were split into smaller separate opportunities
There is no restriction preventing the award of all the opportunities to one supplier. However in case of the "Assurance" element, that would have to be provided by a ring fenced team. If necessary this will be covered in the contracting phase. Several factors were taken into account when the 4 opportunities were published. A good example would be the exact details of the work to be completed in Stage 2 after April 2022.
7. Q3 & Q4 are quite similar in that it only calls out “i.e. T-SQL, Gremlin, etc.” in Q4, can you advise if the same answer is acceptable or should we disregard Q3 here?
These are two separate questions. Q3 is looking for skills/experience on the platforms i.e. Azure Synapse Analytics, Data Bricks, SQL Server etc. and Q4 is asking about the skills/experience in the languages they use e.g. TSQL, Gremlin
3. have the necessary skills and experience in the technologies used by the TPR Data Platform
4. have the necessary skills and experience in the languages used by the TPR Data Platform i.e. T-SQL, Gremlin, etc.
8. Will you have to demonstrate tech alignment in the case study examples e.g. T-SQL?
Yes. We want to see case studies that have included the platforms and languages listed as required.

Please note that for the 1st round due to the format restriction only limited information can be provided. More details can be provided in the second round of evaluation.
9. Do you have experience in all the necessary languages used by the TPR Data Platform i.e. T-SQL, Gremlin, etc.?
We do have some in-house expertise with the languages listed and we are looking for a supplier that can complement our own resources.