Regional Database Officer at International Organization for Migration

CALL FOR APPLICATION – CFARO2021-02

Organization: International Organization for Migration

Department: Research

Consultant specialization: Regional Database Officer

Duty Station: Pretoria, South Africa

Duration of Consultancy: 3 months with a possibility of an extension.

Deadline: 8 June 2021

Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.

BACKGROUND INFORMATION

The Flow Monitoring (FM) activities are part of the IOM’s Displacement Tracking Matrix (DTM) activities in the Southern African region as part of IOM’s research on populations on the move to Southern Africa region. FM is analysed to provide information on profiles, transit routes and vulnerabilities of respondents.

In view of the above, IOM Regional Office based in Pretoria is supporting the SADC Member States to collect data on cross-border mobility through flow monitoring activities and strengthen the institutional mechanisms to respond to cross-border data in the region in a more sustainable manner.

SUPERVISION, DUTIES AND RESPONSIBILITIES

The Consultant is expected to work under the overall supervision of the Regional Director for Southern Africa, the direct supervision of the Southern Africa Migration Management (SAMM) Regional Project Coordinator and in close coordination with the Regional Displacement Tracking Matrix Officer and the staff of the Regional Migration Data Hub (RMDHub) for Southern Africa, the incumbent will support the coordination and implementation of the Flow Monitoring activities under the SAMM project, RMDHub and data management initiatives.. The Consultant is responsible for the following tasks:

1. Support RMDHub and Flow Monitoring (FM) activities with IT-related aspects of Information Management initiatives by developing design and maintain databases to facilitate data collection and and integration of information management across RMDHub and regional FM activities.
2. Ensure the harmonization of data cleaning, consolidation and harmonization process within RMDHub and FM country, regional and global databases is in line with HQ’s DTM methodological framework.
3. Propose the designing of and application of methodologies and data collection tools for regional thematic surveys and assessments.
4. Prepare and implement proper backup, restore, data validation, and security procedures to ensure data integrity and availability.
5. Maintain geographical information system (GIS), and GIS/ database integration.
6. Create and maintain documentation concerning the Database environment.
7. Develop web-based applications and reporting tools, including the RMDHub online portal.
8. Provide training to IT staff and RMDHub team on database management.
9. Undertake duty travel in support of Country Offices when necessary.
10. Any other duties that might be assigned.

EXPECTED DELIVERABLES

· Capacity building support to RMDHub team on database management

· Fully operational Regional Database on DTM and FM related data integrating FM and DTM related from the region.

· Fully operational RMDHub online web-portal.

PAYMENT SCHEDULES AND TIMELINES

· 20% of the total consultancy fee after the delivery of capacity building activity for the RMDHub team on database management within 1 month of the assignment.

· 50% of the total consultancy fee after the development of a Regional Database on DTM and FM within 2 months of the assignment.

· 30% of the total consultancy fee after operational RMDHub online web-portal within 3 months of the assignment.

EDUCATION

· University Degree in Computer Science, Information Technology, Database Management, Software Development or related field of study with at least five years of relevant work experience or

· College Diploma with the aforementioned field of studies with seven years of relevant work experience

EXPERIENCE

· Proficiency in Microsoft Office Suite applications (i.e. Word, Excel, PowerPoint), required;

· Experience configuring and working with Microsoft Access, SQL Server and Visual Studio, required;

· Experience in the development and implementation of KoBo Toolbox or any other mobile data collection tools, required;

· Working experience with GIS tools including ArcGIS Desktop, Server and Online is desirable;

· Experience in designing, developing and managing relational databases is essential;

· Experience in managing data collection, entry, and maintenance;

· Experience in the development and implementation of population database systems (e.g. migrant registration, censuses, household surveys);

· Experience writing technical requirements documents, translating/planning specifications to technical briefs for data capture/analysis, and compiling diverse datasets;

· Experience working in international organizations and the humanitarian community;

· Experience in relevant issues such as migration, displacement, and humanitarian assistance would be an asset.

SKILLS

· Strong communication, organizational and interpersonal relationship skills.

· Hard working, good team player, dedicated, ability to monitor and follow up on pending matters.

· Ability to meet deadlines and work under pressure with minimum supervision;

LANGUAGES

Fluency in English (oral and written). Knowledge of French and/or Portuguese, or other

regional language is considered an asset