Skip to main content

International Labour Organization (ILO.. To develop Simplified Database for KSA Returnees (project beneficiaries

International Labour Organization (ILO)

Country Office for Djibouti, Ethiopia, Sudan, South Sudan & Somalia

Terms of Reference

 To develop Simplified Database for KSA Returnees (project beneficiaries)

Background & Justification

The challenge of absorbing an increasing number of Ethiopians in the job market is taking an increased prominence, with up to 3 million young Ethiopians joining the labor market every year. With the perceived limited economic opportunities within their localities and the low labor absorption capacity in the local economies, most young Ethiopians have been trekking to overseas employment to eke a living. However, this seemingly unchecked migration was disrupted by the sudden repatriation of up to 163,018 (100,688 male, 53,732 female and 8,598 children) Ethiopian migrants from the Kingdom of Saudi Arabia (KSA) in 2013/2014 and around 190,000 migrants in 2017/2018. The KSA is a major destination for a majority of Ethiopian migrant workers for the past three decades. Given the sudden and unprepared nature of this forced repatriation and with little or no fallback position, the seamless reintegration of these returnees has been painfully slow and largely unaddressed. KSA returnees face severe difficulties, particularly in terms of decent livelihood opportunities and reintegration into the Ethiopian labour market. As a consequence, a large proportion chooses to re-migrate, putting them at risk of trafficking and exploitation.

The package of challenges experienced by the returnees has since been documented by the International Labour Organization (ILO), and accordingly have been providing through its EU funded technical cooperation project “Support to the reintegration of returnees in Ethiopia” program, a number of support to address some of these challenges through tailored financial and non-financial services that respond to the returnees needs.

The project is being implemented in Tigray, Amhara and Oromia regional states in partnership with MOLSA/BOLSA, TVET, Micro finances and other key stakeholders. So far the project has reached more than 18,000 returnees through comprehensive support that include financial services as well as skills development interventions (life skills, psycho-social, financial literacy, entrepreneurship skills and vocational skills training). . The project has been also built the capacities of government and other stakeholders; strengthen systems to provide effective reintegration and return support to returnees through trainings and other structured capacity building initiative. To effectively capture these interventions and follow up on beneficiaries the ILO is seeking to hire a qualified consultant or consulting firm to modify, update and simplify the current data base system and finalize the data entry of the returnees (beneficiaries) profile collected from the three regions (Tigray, Amhara and Oromia).

Objective of the assignment

The overall objective of the assignment will be to simplify and redesign existing reintegration project database to enable the provision of regular data entry, analysis and reports of the project and to systematise the data collection and reporting system of the project.

The support will specifically aim at

  • Modifying the existing database  and ensure user-friendly interface compatible to low-bandwidth internet facilities from remote corners, region and woredas of the country where the project is being implemented
  • Ensure a secure password protected login system to allow safe authentication. Different level of access to the web-database needs to be ensured e.g. Project management, Database administrator, implementing, partner NGO/CSO, donor’s representative and field personnel, etc.
  • Ensure the provision and capability for automated backup of database each month, downloadable by administrator and project staff
  • Provide additional updates and data analysis as required.
  • Ensure that all project beneficiaries around 18,000 data/profile are entered in the system

The system should be capable to:

  • To capture, archive, retrieve of information of up to 30,000 project beneficiaries disaggregated by sex,intervention type, and implementing partners and project areas including  woredas, Keble, household profile,supports received;
  • Capable to perform synchronization of offline data collected from the field 

Scope of the assignment

  • Review existing data collection and management system of the project, including existing web based database 
  • Virtually support regional partners and ILO staffs on data collection, analysis, report generation, and data quality assurance,
  • Development/ modification of existing database that is user-friendly interface compatible to low-bandwidth internet facilities from remote corners
  • Deploy and train data encoder.  The consultant or consulting firm will provide training to the data collectors,  partner staffs on how to operate the  data base, collect additional data as needed 
  • Encode/enter all the data in to the system and assure the quality of data
  • Produce real time report (both graphics, tabulated, pivot ) that shows project beneficiaries disaggregated by sex, service provision, address, intervention type, and


  • An Inception Report complete with methodology for undertaking the assignment; key resources/materials employed and detailed work plan within one week following the signing of the agreement
  • Simplified web based data base contextualized for the project context and stakeholders
  • A technical report covering all aspects of the database development process and definitions of codes, variables and copies of any software programme written.
  • Training materials to be used in training staff members and a manual on the use of the database
  • Final clean data set with the profile  of returnees (beneficiaries) supported by the project including service provision 

Time Frame

The duration of the consultancy is 1months after the signing of the agreement between the two parties. The task will be projected to commence as shortly as possible after the signing of the agreement.

Key Qualifications and Competencies

  • The lead researcher or leader of the team will need to have a post graduate Degree in Computer Science or another relevant field.
  • More than 5 years’ experience in in Database development & maintenance.
  •  Good drafting skills, ability to communicate effectively both orally and in writing, ability to clarify information, good computer application skills, good organizational skills
  • Good analytical and trouble shooting skills.
  • Good oral and written skills in English and local language
  • Strong data entry and analysis skills
  • Have proven knowledge of the UN in general and the ILO in particular and their objectives


Interested applicants should submit their letter of application, copy of credentials and a detailed technical and financial proposal (in a separate envelop) including applicants profile, proof of legal registration, copies of relevant credentials, last 3 years audit report and other supporting documents that show previous and similar work experience. Application should be hand delivery or regular post-mail to the below address.

The Administrative Assistant (Migration)
Congo Building, Room No. 516

ILO Country Office for Ethiopia, Djibouti, Somalia, Sudan and South Sudan
PO Box 2788

UNECA Compound- Addis Ababa

Please note that we do not accept application through expert postal service such as DHL or EMS.

Only shortlisted candidates will be notified. Deadline for submitting applications: 1 October 2018.