Data Merging and Extraction Consultant (Low Value)

This opening expired 2 years ago.

UNICEF - United Nations Children's Fund

Open positions at UNICEF
Logo of UNICEF

Application deadline 2 years ago: Monday 7 Sep 2020 at 21:55 UTC

Open application form


This is a Consultancy contract. More about Consultancy contracts.

UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential.

Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone.

And we never give up.

For every child,

Background and Justification

The Ministry of Social Development (MOSD) with the assistance of European Union (EU) and UNICEF has developed a Management Information System to manage its social assistance programmes. MIS was developed in November 2014 and completed in January 2016. The system is web-based and runs on a Microsoft platform. It works in conjunction with a mobile application that was developed to facilitate timely data collection and entry.

The system was custom made to meet the MoSD requirements and has had a support contract that expired in 2018. The Ministry requires short-term technical support to extract and merge the data due as the system.

Scope of Work

G*****oal and Objective*****: To provide technical support to the Ministry of Social Development to perform data importing and extraction to enable enrolment of new beneficiaries.

Provide details/reference to AWP areas covered: The assignment for the consultancy will contribute to the achievement of outcome 3 (output 3.1) of the rolling work plan that states by 2023, the GoL has an improved child and gender-sensitive, and shock responsive social protection.

Activities and Tasks: The consultant is expected to undertake the following key activities:

  • Scripting to activate forms for importing;
  • Form archiving to free up system resources;
  • Â Avail data and PMT extracts by exposing them on the system;
  • Configuration of urban PMT formula;
  • Configuration of system functionality to allow for selection between rural and urban PMT formula; and
  • Support generation of call for enrolment lists and loading of work packs on mobile devices to avoid mixing up of legacy dataset with the new dataset.
  • Prepare final report

*Work relationships*****: The consultant will be supervised by the Social Policy Specialist; however, the consultant will work closely with the Director Social Assistance and close technical collaboration with Statistician, IT Manager and MIS Administrator.




(Estimated # of days or months)


Schedule of payment

Inception Report

2 Days

4th Day


MSSQL Script for importation of data collection form

4 days

2nd Week of July

Script to archive the forms

2 weeks

End of July


Availability of data extract and PMT extracts.

3 weeks

3rd week of August

Urban PMT applied on all urban households

Submission of Progress Report

5 days

End of August

Script to segregate the urban EAs from the Rural EAs

5 days

1st week of Sept

Script to generate the following reports: Pre-Enrolment report(Projections tied to Payment levels)

Linakge of Household Ids to the Mobile numbers in the system

Post-Enrolment report (Forms disaggregated per program)

Progress Report

3rd week of Sept

Final Report

End of Sept

Additional guidance

All the deliverables will be electronically submitted to UNICEF and MOSD, they should be prepared in consultations with the Ministry and UNICEF.

The content of the report should be endorsed by the Social Policy Specialist in UNICEF and designated authority in the Ministry of Social Development.

Desired profile

Experience: Minimum of ten (10) years of working experience in development of Management Information Systems for Social Protection

**Competencies****: Programming languages: Microsoft Visual C#, Microsoft Visual Basic.Net ,Webforms, Windows forms ,Model View Controller*; Database servers: MSSQL, MySQL*

  • Other skills: XML, CSS, JSON, Javascript, JQuery, AJAX, AngularJS, Azure, Cordova, REST and SOAP services, Agile and Scrum software development methodolgies, WebAPI, Knowldege in GIT and TFS, Unified Modeling Language(UML) , Domain Driven Design, Service Oriented Architecture

  • Communicates effectively, both orally and in writing, to varied audiences;

  • Able to work effectively in a multi-cultural environment and experience of working in a developing country; and

Language: Fluency in English.

Administrative issues

  1. The selection of consultant will be governed by and subject to UNICEF General Terms and Conditions for individual contracts;
  2. The consultant job is part-time and remotely supporting MOSD; 20 working days over a period of three months;
  3. The consultant will perform the work using own computer;
  4. The fees must be all inclusive of all administrative costs;
  5. Entitlements and conditions of service are governed by UNICEF policies;
  6. Consultant will not be entitled to leave; and

As per UNICEF DFAM policy, payment is made against satisfactory completion of deliverables as of the approved workplan. No advance payment is allowed unless in exceptional circumstances against bank guarantee, subject to a maximum of 30 per cent of the total contract value in cases where advance purchases, for example for supplies or travel, may be necessary.

The candidate selected will be governed by and subject to UNICEF General Terms and Conditions for individual contracts.


COVID 19 may affect effective management and implementation of the assignment.

How to Apply

Qualified candidates are requested to complete an application including profile to the respective advertisement on Please indicate your ability, availability and financial proposal/quote to complete the terms of reference above.

Rates must include all expenses related to the assignment (e.g. consultancy fee, administrative costs

Applications submitted without a fee/ rate will not be considered.

If you have not been contacted within 2 months of the closing date please accept that your application was unsuccessful. Regret emails will be sent only to shortlisted/contacted candidates.

UNICEF is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of the organization.

UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UNICEF, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. UNICEF also adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo rigorous reference and background checks. Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check.


Mobility is a condition of international professional employment with UNICEF and an underlying premise of the international civil service.

Only shortlisted candidates will be contacted and advance to the next stage of the selection process.

Individuals engaged under a consultancy or individual contract will not be considered “staff members” under the Staff Regulations and Rules of the United Nations and UNICEF’s policies and procedures, and will not be entitled to benefits provided therein (such as leave entitlements and medical insurance coverage). Their conditions of service will be governed by their contract and the General Conditions of Contracts for the Services of Consultants and Individual Contractors. Consultants and individual contractors are responsible for determining their tax liabilities and for the payment of any taxes and/or duties, in accordance with local or other applicable laws.

Added 2 years ago - Updated 11 months ago - Source: