Senior Database Assistant at International Organization for Migration (IOM)

Vacancy Number: IOMRONBO/VN/028/2023

Core Functions / Responsibilities:

The Senior Database Assistant will have the following duties and responsibilities:

1. Support the RDH IMO with the technical aspects of regional RDH IM initiatives for establishing and maintaining tools, workflows, and standards for the data sourcing, analysing, and sharing data within in the region and headquarters.
2. Support the RDH IMO to coordinate the development and enhancement of the integrated methodology for data collection and information packaging as required by regional mixed migration and mobility programming.
3. Coordinate the design, mapping, assessment, and monitoring of regional mixed migration data sources and make these available for internal and external reports and publications.
4. Assist in the design of databases and provide maintenance; ensure regular proper data collection for the RDH system.
5. Provide technical assistance with IT-related components of data collection processes and data management activities including encoding, storing, and transferring data as well as processing for data integration and quality control.
6. As part of the EU-OM JI, coordinate the design of software applications to support governmental counterparts to record information on returning migrants, referrals, and service provisions.
7. Provide technical support on the usage of the Migrant Management Operational Systems Application (MiMOSA), including customization of MiMOSA forms to capture project-specific data, and the creation of custom reports to extract data based on specific reporting requirements.
8. Support in the maintenance of a geographical information system (GIS), and GIS/ database integration.
9. Work closely with the DTM regional analysis team to collate regional data sources and contribute to produce regular statistical reports and queries.
10. Develop data sharing tools web-based applications and reporting tools under the guidance of RDH IMO.
11. Prepare and implement proper backup, restore, data validation, and security procedures to ensure data integrity and availability.
12. Support in the creation and maintenance concerning documentation of the RDH data environment.
13. Provide user support, guidelines, training materials and training sessions on the deployment, use, operation and maintenance of databases and data collection systems.
14. Identify and troubleshoot bottlenecks in the process.
15. Undertake duty travel when necessary.
16. Any other duties that might be assigned.

Required Qualifications and Experience

Education

1. University Degree in Computer Science or a related field with at least four years of relevant work experience; Or,
2. High school diploma with at least six years of relevant work experience.

Experience

1. Experience configuring and working with Microsoft Access, SQL Server, and Visual Studio, required.
2. Experience in the development and implementation of ODK or any other mobile data collection tools, required.
3. Working experience with GIS tools including ArcGIS Desktop, Server and Online is desirable.
4. Experience in designing, developing, and managing relational databases is essential.
5. Experience in managing data collection, entry, and maintenance.
6. Experience in the development and implementation of population database systems (e.g., migrant registration, censuses, household surveys);
7. Experience writing technical requirements documents, translating/planning specifications to technical briefs for data capture/analysis, and compiling diverse datasets.
8. Experience working in international organizations and the humanitarian community.
9. Experience in relevant issues such as migration, displacement, and humanitarian assistance would be an asset.

Skills

1. Strong communication, organizational and interpersonal relationship skills.
2. Hard working, good team player, dedicated, ability to monitor and follow up on pending matters.
3. Ability to meet deadlines and work under pressure with minimum supervision;

Languages

Required: For all applicants, fluency in English and Kiswahili is required (oral and written). Working knowledge of French; and/or any other UN Official language is advantageous

Submit cover letter indicating the Position Title & Vacancy Notice Number (VN No.), and CV with telephone and e-mail contacts including 3 Referees (Supervisors) to: IOM, RO Human Resources Department