This opportunity is closed for applications

The deadline was Monday 6 July 2020
Redbridge Council

Data Migration Specialist for Local Authority Housing Service

23 Incomplete applications

19 SME, 4 large

43 Completed applications

40 SME, 3 large

Important dates

Published
Monday 22 June 2020
Deadline for asking questions
Monday 29 June 2020 at 11:59pm GMT
Closing date for applications
Monday 6 July 2020 at 11:59pm GMT

Overview

Specialist role
Data engineer
Summary of the work
Redbridge are seeking a Data Migration & Interfaces Manager to oversee the data cleansing, migration and interfacing activities of the project.

The core legacy housing system Northgate (OHMS) is to be replaced as well as six other legacy systems including Asset Management (Codeman) and Needs (Hope).
Latest start date
Monday 10 August 2020
Expected contract length
twelve months
Location
No specific location, eg they can work remotely
Organisation the work is for
Redbridge Council
Maximum day rate
Please quote Fixed Term Contract or Day Rate.

Tasks to be broken down to work packages.

About the work

Early market engagement
Who the specialist will work with
You will report into the project manager and be an integral part of a small project team.

You will mentor junior data analysts.
What the specialist will work on
Develop a Data Migration Strategy and document, which covers business/data quality requirements, sources of data from the legacy systems.

Manage the data cleansing and migration work-stream.

Oversee the implementation of interfaces.

Lead the data work-stream in developing various mappings and process flows using SQL and other business intelligence tools to migrate data from the Legacy systems.

Develop Test plans, scripts and execution test cases for Systems End to End testing and UAT.

Work setup

Address where the work will take place
The Office is in Ilford, London but all staff are currently working remotely,

Going forward your time will likely be split between working in Ilford and working remotely.
Working arrangements
Working hours are generally office hours (mon - fri 9 - 5). Although the specialist is expected to work outside of these hours at critical times of the project e.g. cutover to go live, testing.
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
  • Housing
  • Data Cleansing
  • Data Migration
  • Interfaces
  • Full data lifecycle of project.
  • Excel for data cleansing and migration
Nice-to-have skills and experience
  • Experience of data migration from Northgate OHMS
  • Experience of Housing, Local Council, Repairs, Asset Management interfaces
  • Experience of Oracle and SQL Server
  • Experience of managing Junior Staff
  • Full understanding of data protection practice and GDPR
  • Database administration experience and understanding of data management

How suppliers will be evaluated

All suppliers will be asked to provide a work history.

How many specialists to evaluate
6
Cultural fit criteria
  • Highly developed oral and written communication skills, with an ability to explain complex information clearly to a range of audiences
  • Effective working practices within the team and with a range of service providers
  • Provides professional expertise at a range of meetings
Additional assessment methods
  • Reference
  • Interview
Evaluation weighting

Technical competence

55%

Cultural fit

5%

Price

40%

Questions asked by suppliers

1. What is ideal day rate? Including fees
Please quote as indicated.
2. Hi there, is there a current incumbent in this role?
No.
3. Is there an incumbent?
No.
4. Could you give an indication on you Budget?
Please quote for the work as indicated.
5. Would you consider a part-timer?
yes.
6. Would you consider a part-timer?
Yes.
7. Can you please advise on whether there is an incumbent and if the role is inside or outside IR35?
No incumbent.
Yes, outside of IR35 but to be verified.
8. Are you looking for an individual for this role or would you consider a consultancy who could put a team in place to reduce the dependency on a single individual? The team could be multiple people working at the same time or rotating the team members over the engagement such a 50% of the week each for 2 people.
Individual role only.
9. What is the required clearance for this role?
No security clearance required.
10. Do you have a maximum day rate for this role?
Please quote as indicated.
11. Can you clarify if the position an engineer role (in title) or a management role (in body of description)?
Both roles apply.
12. In essential skills, when Housing is mentioned is that relating to Data or the Housing/Homes sector?
Experience of working in the Social Housing space with related data expertise.
13. Are you looking for the specialist to have knowledge of any new technology? Do you know what system you are looking to migrate over to?
Experience of Cloud SAAS is helpful.
The target system has not been procured yet.