Data Migration Specialist for Local Authority Housing Service

Tender description

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). Specialist role Data engineer Expected Contract Length twelve months Latest start date Monday 10 August 2020 Maximum Day Rate Please quote Fixed Term Contract or Day Rate. Tasks to be broken down to work packages. Who Speclialist 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 Specialists 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. Skills & Experience • Housing • Data Cleansing • Data Migration • Interfaces • Full data lifecycle of project. • Excel for data cleansing and migration Nice to Haves • 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 Work Location 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 Arrangments 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. No. of 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 Assessment Method • Reference • Interview Evaluation Weighting Technical competence 55% Cultural fit 5% Price 40% Questions from 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.