Senior Database Assistant at International Organization for Migration (IOM)

Core Functions / Responsibilities:

In particular he/she will:

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. Manage data (cleansing, migration, integration, and quality control) by implementing extract, transform and load (ETL) process in the Regional Data Warehouse (RDW).
5. Design and maintain databases and ensure regular proper data collection for the RDH system set up.
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. Collate regional data sources and contribute to produce regular statistical reports and queries.
9. Work closely with the DTM regional analysis team.
10. Conduct data validation by cross checking reliable data extraction from within existing databases.
11. Develop data sharing tools web-based applications and reporting tools under the guidance of RDH IMO.
12. Manage training and skills development support to database and IM RDH portfolio.
13. Identify and troubleshoot bottlenecks in the process.
14. Undertake duty travel when necessary.
15. Perform any other duties as may be required.

Required Qualifications and Experience

Education

• University degree in Computer Science or any related field with at least four years of relevant professional experience; or,
• High school degree with at least six years of relevant professional experience.

Experience

• Experience managing or developing databases is essential.
• Experience managing data collection, entry, and maintenance.
• Experience in cloud data analytics services and tools for data integration, data warehousing, data analysis is an advantage.

Skills

• Proficient in computer software: Microsoft Office (Outlook, Words, Excel, and Internet Explorer). In particular, strong command of Excel is required.
• Ability to work effectively and harmoniously with colleagues from varied cultures and professional backgrounds.
• 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). Working knowledge of French is advantageous.

Required Competencies

Values

• Inclusion and respect for diversity: respects and promotes individual and cultural differences; encourages diversity and inclusion wherever possible.
• Integrity and transparency: maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.
• Professionalism: demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.

Core Competencies – behavioural indicators level 2*

• Teamwork: develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.
• Delivering results: produces and delivers quality results in a service-oriented and timely manner; is action oriented and committed to achieving agreed outcomes.
• Managing and sharing knowledge: continuously seeks to learn, share knowledge and innovate.
• Accountability: takes ownership for achieving the Organization’s priorities and assumes responsibility for own action and delegated work.
• Communication: encourages and contributes to clear and open communication; explains complex matters in an informative, inspiring and motivational way.