This opportunity is closed for applications

The deadline was Thursday 29 July 2021
London Borough of Hackney

Recovery and migration of data

12 Incomplete applications

9 SME, 3 large

20 Completed applications

20 SME, 0 large

Important dates

Published
Thursday 15 July 2021
Deadline for asking questions
Thursday 22 July 2021 at 11:59pm GMT
Closing date for applications
Thursday 29 July 2021 at 11:59pm GMT

Overview

Specialist role
Data engineer
Off-payroll (IR35) determination
Supply of resource: the off-payroll rules will apply to any workers engaged through a qualifying intermediary, such as their own limited company
Summary of the work
To enable teams to effectively restore their business processes we need to retrieve and migrate their data to their newly procured system.
This project is to deliver:
Data discovery and extraction of data, ready for migration. We expect
a complete dataset with documentation for migration.
Latest start date
Monday 16 August 2021
Expected contract length
8 weeks
Location
London
Organisation the work is for
London Borough of Hackney
Maximum day rate
£750 per day

About the work

Early market engagement
Who the specialist will work with
Hackney Relationship Manager
Engagement from another Local Authority
What the specialist will work on
We need to successfully migrate the recovered data to a new system without access to the legacy application, knowledge of it’s database schema, or support from the vendor. The vendor of the new system will transform and load the data, so we need assistance to identify, extract and model the appropriate data from the recovered database of the legacy application. Users need to be able to validate the data in a database via a front end interface.

The specialist will deliver:
*Data discovery and extraction of data, ready for migration in new system
*A complete dataset with documentation for migration

Work setup

Address where the work will take place
Work can take place remotely. If onsite work is required, this will take place at London Borough of Hackney offices
Working arrangements
Remote working
Security clearance

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
  • Experience of working with Oracle databases
  • Experience of database modelling and architecture
  • Experience of working with SQL servers and CSV files
  • Data discovery experience to understand underlying data structure and relationships
  • Iterative approach to development, reconciliation and testing
  • Experience of working with AWS Cloud Infrastructure
Nice-to-have skills and experience
Experience of working with Planning, Building Control and Land Charges data

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
  • Take responsibility for their work
Additional assessment methods
  • Reference
  • Interview
  • Presentation
Evaluation weighting

Technical competence

60%

Cultural fit

7%

Price

33%

Questions asked by suppliers

1. Is there an incumbent/preferred supplier?
There is no incumbent/preferred supplier.
2. Could you please provide breakdown of further stages with dates? When exactly the final decision would be made?
Provisional Dates
Interview w.c. 2/8/2021
Aiming for a final decision by 6/8/2021
3. Would a supplier be qualified out if the resource having transferrable skills doesn’t have experience of “working with Planning, Building Control and Land Charges data” at all?
A supplier would not be qualified out if the resource does not have the above transferrable skills. It is a nice to have.
4. Is the consultant expected to work on a full-time basis (9 to 5) or is it up to suppliers to decide what arrangements will be required to complete the project on time?
We can negotiate the hours. Though the more regular the hours, the better.
5. What is the volume of records to be migrated?
The volume is currently unknown but should become clearer as part of the Data discovery.
6. How many different types of load files are to be prepared for uploading?
There are CSV files, which are record data and document metadata.
There are PDF files
7. 1. What types of resources are required and how many?

2. We assume that resources can work remotely from outside of UK (offshore) also. Please confirm.
1. Type of resources - Technical (DBA, Data Analyst or Data Scientist)
Number of resources - x1

2. No, we will not be allocating work outside of UK (offshore).
Due to GDPR restrictions and the possibility of having to send physical storage media to the successful applicant.
8. Is the data to be sanitised and/or deduplicated?
At present, there is no data cleaning requirement.

We’ve been able to recover the Oracle DBF files, have tested that they load successfully, and querying the tables returns data. The DBF files have been moved and are available from an AWS S3 bucket.
There is an open offer of help from colleagues at other Local Authorities using the legacy application.
We’re unable to restore the legacy application without the support of the vendor, which makes this non-viable.
9. Is the data to be mapped from legacy to new (i.e. M -> Male, F – Female)?
Yes, it will be mapped from legacy to new.
10. Would you consider using RPA to achieve the required results?
The structure of the old data compared to the new will limit this.