This opportunity is closed for applications

The deadline was Wednesday 14 July 2021
HM Revenue & Customs

1052-DPS Data Management Preparation & Acquisition - SR624137341

5 Incomplete applications

2 SME, 3 large

4 Completed applications

1 SME, 3 large

Important dates

Published
Wednesday 30 June 2021
Deadline for asking questions
Wednesday 7 July 2021 at 11:59pm GMT
Closing date for applications
Wednesday 14 July 2021 at 11:59pm GMT

Overview

Off-payroll (IR35) determination
Contracted out service: the off-payroll rules do not apply
Summary of the work
Provide impact assessments
Demand Management
Delivery Management including testing & rollback capabilities
Business Requirements
Solution Design
ETL Code Delivery
Virtual databases code delivery
Meta Data Management Administration
Incident/problem management
Batch operation -support/recovery
Event Management/ HPI Management –Provide support when required
Change Management –Evaluate change within SLA’s
Capacity/performance management
Knowledge management
Latest start date
Monday 20 September 2021
Expected contract length
24 months
Location
North West England
Organisation the work is for
HM Revenue & Customs
Budget range
Up to £17,000,000.00

About the work

Why the work is being done
Data Platform Services (DPS) provides enterprise-wide platform engineering capabilities that enable the building of reporting, searching, risking, advanced analytics and cognitive services.

DPS provides the core platform capabilities needed by:
• Chief Data Office to implement enterprise data management, manage data sharing and acquisition and provide advanced analytics exploitation services.
• Customer Groups to assemble, build and run line of business data services.
• Various data consumers within HMRC Business to exploit data, within a supported self-serve framework.

DPS offers the supporting capabilities that enable HMRC to become a data-driven and insight-led organisation, drive data innovation and adoption of emerging AI/ML technologies.
Problem to be solved
HMRC has a large and complex legacy Data Analytics estate which needs simplification, and consolidation and transformation to meet the challenges the department now faces.

HMRC design and build services to provide environments on which to manage, provision, prepare and transform data and provide services to exploit that data across the organisation, and other government departments.

Assist HMRC in the migration, RUN and evolution of products and services in the cloud.
Who the users are and what they need to do
All HMRC customer groups (Customer Compliance, Customer Services, Customer Strategy and Tax Design, Corporate, VOA) need platform products they can consume and data on which they can build their specific line of business exploitation services.

HMRC Chief Data Office needs platform products which enable Data Management, Governance and Data Sharing including Meta Data Management, Data Quality and Profiling.
Early market engagement
N/A
Any work that’s already been done
DPS has been working since 2018 on a new strategy for provision of Data and Analytics services based around a hybrid hosting model with a Logical Data Warehouse at its core. There is a significant amount of work remaining to continue delivery of that evolving platform roadmap.

The new platform products will have been delivered at handover, and the focus will be upon extending their use across the data analytics estate and wider enterprise.

Currently building services in the cloud and migrating the legacy estate.
Existing team
Suppliers will be working with a number of HMRC teams including Data Platform Services. This will also include colleagues from within HMRC, including different suppliers and with project & programme teams.
Current phase
Not applicable

Work setup

Address where the work will take place
Primary Location will be agreed as per instruction in each SOW onboarded during the agreement.

The Primary Location assigned will be Salford or Southend on Sea. Full address details below.

Trinity Bridge House
2 Dearmans Place
Salford, Manchester
UK
M3 5BS

Alexander House
21 Victoria Avenue
Southend on Sea
UK
SS99 1AA

The supplier shall cover all Travel and Subsistence costs to the Primary Location.

Upon request by the Authority, supplier personnel shall expected to travel to other HMRC locations in the UK and the cost of this travel will be covered by HMRC's Travel and Subsistence Expenses policy.
Working arrangements
The supplier will be required to co-locate with the existing platform teams, mixed teams comprising both internal staff and other contractors, up to 2 days per week.

Travel will be required to other HMRC Delivery Centres. No additional expenses chargeable to HMRC for travel or accommodation in agreed base office locations per SOW.

We expect the successful supplier to provide upskilling to permanent staff to increase internal capability.

Up to 24 hour support maybe required for some products and services. Some evening and weekend working maybe required for delivery teams. Example: weekend deployments.
Security clearance
All supplier personnel assigned to this work shall have BPSS clearance in place for contract commencement date.

All supplier personnel assigned to this work shall be eligible to apply for SC clearance. The supplier, with support from the Authority, shall apply for SC clearance on the contract commencement date.

Additional information

Additional terms and conditions
HMRC Mandatory Terms

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
  • Experience working with and leveraging the benefits of AWS and Microsoft Azure Cloud hosted services
  • Experience working with range of ETL and ELT tools to design, create, deploy and operate enterprise services focussing on re-use, consistency and performance. Must include Pentaho Data Integrator and Talend.
  • Experience defining and implementing Data Quality rules at enterprise scale using SAS Data Flux / Data Management Studio.
  • Experience Data Modelling and creation of physical models conformant with Enterprise Data Model and organisation standards using SAP Powerdesigner.
  • Capability for Java and Javascript development.
  • Creating performant and resilient ETL/ELT jobs for a large enterprise, including use of the apache Spark engine with Scala.
  • Supporting 24x7 Data Acquisition and Data Preparation services.
  • Experience Managing and Administering relational, graph, in memory and NOSQL database including Oracle, MYSQL, Redshift, NEO4j and Hbase.
  • Test driven development with Business Intelligence services including use of Continuous Integration environments
  • Automated and Performance testing of ETL / ELT services
  • Experience using and administering Metadata and Information Management solutions including Informatica Axon and EDC
  • Experience using and administering Data Virtualisation solutions including Denodo.
  • Experience Managing and Administering ETL services including Pentaho and Talend.
  • Experience Managing and Administering Data Quality services with Data Management Studio.
  • Designing and building solutions fully conformant with WCAG 2.0.
  • Experience of customer facing issue and incident resolution.
  • Producing and maintaining technical documentation and a Knowledgebase.
  • Providing accurate and timely information to maintain a CMDB.
  • Working safely within a UK based secure engineering environment at Security Clearance level
  • Experience with Batch, Message and Streaming data Acquisition and associated acquisition architectures such as lamda.
Nice-to-have skills and experience
  • Experience with Red Hat Linux 6 and later
  • Experience working with Databases containing 100’s TB’s of data and object / Hadoop storage containing PB’s of data.
  • Experience/knowledge of working with Government Digital Strategy (GDS)

How suppliers will be evaluated

All suppliers will be asked to provide a written proposal.

How many suppliers to evaluate
5
Proposal criteria
  • Accountability- successful delivery of project or outcome under time constraints whilst demonstrating value for money. Operating a service to agreed standards and implementing remedial action where outcomes are not met.
  • Agility - delivering iteratively and incrementally within a context of evolving requirements following SCRUM and Kanban approaches
  • Knowledge embedding - making knowledge capture and sharing part of day to day activities. Ensuring successful handover at any required stage of a project or a service.
  • Delivering business value – making sure business requirements are understood, validated via positive challenge and delivered against while understanding the value being generated (i.e. business intent)
  • Innovative thinking – think outside the set of existing organisational constraints to arrive the most appropriate and efficient route to deliver desired outcomes
  • MVPs – effective definition and delivery of true MVPs that shorten time to delivering business value
  • Reusability by design – ensuring solutions are formulated from reusable capabilities as well as ensuring new capabilities are reusable
  • Simplicity by design – a clear focus on producing and positively challenging solutions to be as simple as possible
  • Design for minimising build and run costs
  • Responsive mobilisation – ability to resource work and start delivering in 4-5 weeks
  • Enough capacity to ensure supplier can cope with DPS demand, in the specified locations
  • Enough depth and breadth of capability across the supplier resource pool, in the specified locations
  • Supplier teams are expected to use HMRC's collaboration software like Jira, Confluence and Teams
  • Experience with Cloud development
  • Microservices design and development
  • Experience working in Agile framework and/or Scrum
Cultural fit criteria
  • Demonstrate action to support health and wellbeing, including physical and mental health, in the contract workforce.
  • Influence staff, suppliers, customers and communities through the delivery of the contract to support health and wellbeing, including physical and mental health.
  • Inclusive and accessible recruitment practices and retention focussed activities including those provided in the Guide for line managers on recruiting, managing and developing people with a disability or health condition.
  • Implementing the 6 standards in the Mental Health at Work commitment and, where appropriate, the mental health enhanced standards in Thriving at Work
  • Public reporting by the tenderer and its supply chain on the health and wellbeing of staff comprising the contract workforce, following the recommendations in the Voluntary Reporting Framework.
  • Engagement plans to engage the contract workforce in deciding the most important issues to address.
  • Methods to measure staff engagement over time and adapt to any changes in the results.
  • Processes for acting on issues identified.
Payment approach
Fixed price
Additional assessment methods
  • Reference
  • Presentation
Evaluation weighting

Technical competence

60%

Cultural fit

10%

Price

30%

Questions asked by suppliers

1. Can you outline the expected timetable of events following the submission of this Tender on July 14th 2021?
Thank you for your question.

Please see attached the indicative timeline.

14 July 2021 – opportunities close
15-27 July 2021 – evaluation and moderation phases
28 July 2021 – proposal issued
11 Aug 2021 – proposals received
12-24 Aug 2021 – evaluation and moderation phases
25-31 Aug 2021 – presentations phase
1 Sept 2021 – final moderation
2-19 Sept 2021 – internal approvals, contract creation
20 Sept 2021 – contract start
2. In relation to question: Experience Managing and Administering Data Quality services with Data Management Studio
There are many data management studios such as from Talend, SAS, Microsoft, DataFlux etc. Can HMRC please clarify/elaborate a bit more on the data management studio that this question refers to?
Thank you for your question.

Supplier should have relevant and recent experience of the SAS data flux tooling as a data management studio in managing and administering data quality services.
3. Are you open to evidences outside UK?
Thank you for your question.

Unless specifically stated in the requirements, experience outside the UK can be submitted. We would recommend using recent and relevant UK based experience as this would give greater understanding of your company technical and resource abilities to delivery to the UK market.
4. How do the requirements for this opportunity work alongside those being delivery today via previous DOS contracts which are not due to expire until 2022?
Thank you for your question.

The previous DOS contracts do not expire until 2022 however the volume of work HMRC has delivered through these contracts over the past 18 months now means that the funds under these contracts will be used up in 2021. The new contracts will replace the existing DOS4 contracts.