Database Analyst

The Central African Republic (CAR) is a highly fragile country with a history of recurrent conflict, the most recent of which took place in 2013 between multiple armed groups. The violence that followed the 2013 crisis greatly damaged public assets and infrastructure, disrupted service delivery, and further weakened the social fabric, and exacerbated people’s poverty and vulnerability to shocks. As a result, roughly one-quarter of the population was internally displaced or had to flee as refugees to neighboring countries. Forced displacement has disrupted livelihoods, depleted the assets of the poor, and put an additional strain on service delivery in areas of displacement.

Improvements in the security situation have resulted in the voluntary return of displaced populations, primarily in the northwest and southwest of the country. It is estimated that about 15 to 20 percent of the displaced population has returned spontaneously. However, the return of the displaced to the areas of origin remains fragile and dependent on the overall security situation. The reintegration of displaced populations and provision of social safety nets is a short term priority and essential to the stabilization and economic revitalization of the country.

To this end, the World Bank is supporting the Government of CAR to implement a project to increase access to basic services, infrastructure and social safety needs by communities affected by forced displacement. Among several deliverables in this implementation phase, the project through UNOPS will be constructing/rehabilitating several infrastructure’s project; conducting several socioeconomics’ activities such as conducting the selection of most vulnerable household among the displaced population and conducting also the distribution of funds to the selected population in the following regions: Kaga-bandoro, Batafongo, Bria and Bambari.

The project adopts a multifaceted approach in support of communities affected by displacement in CAR and it entails:

1) support to enhance the delivery of local services and availability of local infrastructure to benefit communities impacted by displacement;

2) financial support to the most vulnerable households among displaced populations and local communities;

3) working with local communities and displaced populations to enhance their capacity to address the impact of displacement and promote peaceful coexistence of different groups; and

4) to enable local authorities (territorial administration and communes) to participate in planning and overseeing the execution of all activities executed under this project

The incumbent will be working under the direct supervision of Project Manager and under the management of the Head of Office and will be responsible for following tasks: 

• Design and construct a database system by using SQL Server or MySql which covers the following operations
• Registration of the beneficiaries of the project, generation of list of beneficiaries, various analysis and reports on the registration process
• Advise on the software and hardware to be used for the registration process
• Develop data entry format and reporting designs through reviewing the following documentation process and file repository of the the project
• Advise the senior management of the project, for the required information
• format, data entry, report format, etc.,  relating to operations and performances of a registration database
• Provide on the job training to selected staff members of the project covering the following modules: 
• Data entry, importing and exporting data 
• Designing database reports
• Report preparation including data analysis and presentation
• Basic computer hardware maintenance and software configuration of the existing computer and information technology network within the project
• Data entry with assistance from the project staff. 
• Perform data analysis and prepare reports with assistance from the project, staff. Further
• Develop the structure or format of the database as required, incorporating ideas according to the knowledge and experience of the incumbent and other stakeholders including Project
• Develop and maintain database design documentation and operating manuals on how to use the Database.
• Maintain strict data confidentiality for sensitive data.
• Other duties as assigned by the supervisor.

• Advanced University degree (Master’s or equivalent) in Computer Science, Statistics or related field such as geographic information science, geography, computer science, surveying or urban planning is required;
• First level University degree (Bachelor’s or equivalent) in Computer Science, Statistics or related field such as geographic information science, geography, computer science, surveying or urban planning in combination with 2 additional years of relevant professional experience may be accepted in lieu of the advanced university degree.
• GIS certifications is desired.

• 2 years of relevant experience working, developing and managing databases for several types of data and information is required;
• 2 years of experience in programming and use of Microsoft Excel and GIS databases, SQL including design of database structures and development of appropriate interfaces for data entry, ensuring data quality and security, update records and fields, modification of database structure, and generation of customized reports is required.
• Experience in performing web and mobile application development using JavaScript, HTML5, CSS, AJAX for the Esri ArcGIS platform;
• Experience in training project personnel in the use of database management and different software applications is desired;
• Excellent computer skills including Microsoft Excel, Access, SQL Express, VBA, hardware and software installation and maintenance, and networking is preferable.
•  Significant experience in analyzing data and producing reports is an advantage;
• Experience in writing and maintaining GIS database design documentation and operating manuals is required.

• Fluency written and oral in French is required
• Intermediate English is required

1. Contract type : Contrat de Prestataire Individuel International 
2. Contract level : I-ICA 1
3. Contract duration : Open-ended, subject to Organizational requirements, availability of funds and satisfactory performance.

• Please note that the closing date is midnight Copenhagen time
• Applications received after the closing date will not be considered.
• Only those candidates that are short-listed for interviews will be notified.
• Qualified female candidates are strongly encouraged to apply.
• Work life harmonization - UNOPS values its people and recognizes the importance of balancing professional and personal demands. We have a progressive policy on work-life harmonization and offer several flexible working options. This policy applies to UNOPS personnel on all contract types
• For staff positions only, UNOPS reserves the right to appoint a candidate at a lower level than the advertised level of the post
• The incumbent is responsible to abide by security policies, administrative instructions, plans and procedures of the UN Security Management System and that of UNOPS.  

It is the policy of UNOPS to conduct background checks on all potential recruits/interns.
Recruitment/internship in UNOPS is contingent on the results of such checks.

UNOPS supports the successful implementation of its partners’ peacebuilding, humanitarian and development projects around the world. Our mission is to serve people in need by expanding the ability of the United Nations, governments and other partners to manage projects, infrastructure and procurement in a sustainable and efficient manner.

Working in some of the world’s most challenging environments, our vision is to advance sustainable implementation practices, always satisfying or surpassing our partners’ expectations.

With over 7,000 personnel spread across 80 countries, UNOPS offers its partners the logistical, technical and management knowledge they need, wherever they need it.

A flexible structure and global reach means that we can quickly respond to our partners' needs, while offering the benefits of economies of scale.