Database Analyst

Bangui, Central African Republic
Apply by 12 August 2018
Entry-level , Full-time staff position
Posted on 31 July 2018

Job Description

Background Information - Job-specific

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

Background information - DR Congo

Located in Kinshasa, DRC the UNOPS office in Central Africa covers the DRC, CAR, RC, Gabon and Equatorial Guinea.

The office has developed strong working relations with the international partners, UN agencies including UN Missions and Governments of Central Africa over the years. It provides technical support and capacity building in strategic development areas including infrastructure rehabilitation and development across health, education, public works, governance/public administration sectors; procurement, project management and sectoral advisory services; peace and security, environmental preservation and protection among others.

Functional Responsibilities

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.

Education

  • 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.

Experience

  • 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.

Languages

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

CompetenciesView content

Treats all individuals with respect; responds sensitively to differences and encourages others to do the same. Upholds organizational and ethical norms. Maintains high standards of trustworthiness. Role model for diversity and inclusion.

Acts as a positive role model contributing to the team spirit. Collaborates and supports the development of others. For people managers only: Acts as positive leadership role model, motivates, directs and inspires others to succeed, utilizing appropriate leadership styles. Demonstrates understanding of the impact of own role on all partners and always puts the end beneficiary first. Builds and maintains strong external relationships and is a competent partner for others (if relevant to the role). Efficiently establishes an appropriate course of action for self and/or others to accomplish a goal. Actions lead to total task accomplishment through concern for quality in all areas. Sees opportunities and takes the initiative to act on them. Understands that responsible use of resources maximizes our impact on our beneficiaries. Open to change and flexible in a fast paced environment. Effectively adapts own approach to suit changing circumstances or requirements. Reflects on experiences and modifies own behavior. Performance is consistent, even under pressure. Always pursues continuous improvements. Evaluates data and courses of action to reach logical, pragmatic decisions. Takes an unbiased, rational approach with calculated risks. Applies innovation and creativity to problem-solving. Expresses ideas or facts in a clear, concise and open manner. Communication indicates a consideration for the feelings and needs of others. Actively listens and proactively shares knowledge. Handles conflict effectively, by overcoming differences of opinion and finding common ground.

Contract type, level and duration

  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.

For more details about the ICA contractual modality, please follow this link:
https://www.unops.org/english/Opportunities/job-opportunities/what-we-offer/Pages/Individual-Contractor-Agreements.aspx

Additional Considerations

  • 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.

About the Organization

Background Information - UNOPS

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.

Similar Jobs