HIAS Refugee Trust of Kenya Data Migration Cleaning Consultant Jobs in Kenya

HIAS Refugee Trust of Kenya Data Migration Cleaning Consultant Jobs in Kenya

Position Summary:

HIAS Kenya is in the process of implementing a global electronic data/client management system (CMS) and operating model for managing client's information.

The project will have significant impact on ways of working for HIAS staff, which will require a degree of organizational change or re-alignment in the planning and implementation. The project objective is to enhance the efficiency in service delivery and meet organizational needs and timelines by:

Coordinating client statistical and data collection activities to avoid duplication of efforts in the production of statistics, ensuring optimal utilization of available resources, and reducing the burden on respondents in providing data

Promoting collaborating among different programs at HIAS in the collection, compilation and generation of reports and statistical information, including statistics derived from the activities of different programs at HIAS.

Allowing for uploading of documents to individual client files in the CMS database

Allowing service planning

The third function lags behind in execution due to historical data which is stored in different data bases and in formats not compatible to CMS database. A large part of the HIAS Kenya office data is currently out of HIAS CMS in formats such as MS Excel, MS Word and physical files.

Objectives & Deliverables:

While HIAS has provided the general scope of work for the consultancy detailed below, the consultant is expected to propose a plausible approach to perform the necessary tasks, covering the general data cleanup required (missing information, elimination of duplicates, etc.), data consistency review and final compilation of all records.

The overall objective of the consultancy is to provide technical expertise for HIAS Kenya in converting data in physical files to a format that can be migrated to the CMS database. This will be done based on a thorough analysis of the current state of many years of data in physical files.

The task will involve cleaning the data, editing and capturing existing data in various sources external to the CMS, and converting them into formats to be uploaded to the CMS. The consultant will propose the scope of data cleaning and compilation and validate these procedures with each program.

The consultant, in close collaboration with the HIAS Keya team, is expected to define the protocol that the collected data must comply with, prior to data migration.

Also, this consultancy will involve defining how to match the values from the HIAS Kenya historical data collection with the new model in the HIAS CMS database, to produce a single database that must be moved to the data migration template assigned by the CMS HQ team. In summary this consultancy includes the following specific tasks and deliverables:

Tasks and Deliverables

Work plan and schedule of tasks,
Detailed review of the existing databases and systems, including excel databases, physical files and CMS.

Organize at least four consultation meeting with HIAS HQ and county staff to

prepare and finalize the digitization structure and protocol

Develop a written plan to compile and clean up procedures for all databases listed in this consultancy for HIAS Kenya, as well as translation to HIAS CMS Data Model procedures.

Develop a flowchart of steps needed to migrate the data in the existing datasets into the
HIAS CMS database. Final compiled and clean data in formats ready to be migrated to the CMS database

All procedures to be performed shall be accompanied by documentation of the tasks, notes and decision process.

All deliverables are worked on in concert with the assigned HIAS Kenya office focal point and will be communicated periodically to both the country team and the HQ CMS team.

Additionally, database cleansing will be worked online, within an internal SharePoint library provided by HIAS HQ, in order to ensure access to information and progress to the country team on an ongoing basis.

Issues to be determined include the following.

Which databases and datasets will be migrated?

What standards should be reviewed in the data cleansing process?

How should the historical databases be matched to the new data model (CDM) in the HIAS CMS template for loading information?

What will be the process for validating records with case managers?

Duty Station

It is preferred that the consultant be based in Kenya, but applicants working in other locations will be considered as long as they are able to maintain regular contact with the Monitoring and Evaluation team and the CMS focal point at the HIAS Kenya office, as well as perform tasks that require direct contact with the team, such as consultations, reviews of the database cleaning process, and resolution of issues relevant to the objectives of this consultancy.

Qualifications & Requirements:

At least a degree (Undergraduate Level) in a relevant field (Computer Science, Data/Information Management, Advanced Statistical Analysis, Information Technology, and Software Engineering)

At least 3 years’ experience related to data management, and data migration processes including the use of common statistical analysis tools such as Power BI.

Prior experience with data management of data sets from the humanitarian sector is an added advantage.

Excellent documentation skills.

Excellent communication and writing skills.

How to Apply

We welcome applications from individuals, partnerships, and firms. The Applications should be submitted to the following email: recruitment.kenya@hias.org indicating the code HRTK/DMC/11/2022 on the subject line by 5.00 PM on 28th November 2022. Applications not bearing the requirements highlighted in this advert will not be considered.

Find jobs in Kenya. Jobs - Kenya jobs. Search our career portal & find the latest Kenyan job positions, career opportunities & jobs in Kenya.

Jobs in Kenya - banking jobs, IT jobs, accounting jobs, NGO jobs, business administration, ICT, UN jobs, procurement jobs, education jobs, hospital jobs, human resources jobs, engineering, teaching jobs, and other careers in Kenya.

Find your dream job from 1000s of vacancies in Kenya posted and updated daily - click here!