United Nations Children's Fund (UNICEF)

Data Merging and Extraction Consultant (Low Value)

United Nations Children's Fund (UNICEF)

Job Description

To provide Technical Support to the Ministry of Social Development to perform data importing and extraction to enable enrolment of new beneficiaries.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. 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 Goal and ObjectiveTo 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. Outputs/Deliverables: Inception Report 2 Days 4th Day 25% MSSQL Script for importation of data collection form 4 days 2nd Week of July Script to archive the forms 2 weeks End of July 75% 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. Risks 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  https://www.unicef.org/about/employ/ 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. Remarks: 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.
Apply Now