Project Management Support - Analyst (Database)

The United Nations Office for Project Services (UNOPS) is an operational arm of the United Nations, supporting the successful implementation of its partners' peacebuilding, humanitarian and development projects around the world.  Mandated as a central resource of the United Nations, UNOPS provides sustainable project management, procurement and infrastructure services to a wide range of governments, donors and United Nations organizations.  With over 6,000 personnel spread across 80 countries, UNOPS offers its partners the logistical, technical and management knowledge they need, where they need it.  By implementing around 1,000 projects for our partners at any given time, UNOPS makes significant contributions to results on the ground, often in the most challenging environments.

Project Information:

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 and to a lesser extent in late 2020. 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 increase access to the establishment of social safety nets to communities affected by forced displacement. The project will be implemented through UNOPS including but not limited to the following towns: Bangui, Bossangoa and Bria

The project adopts a multifaceted approach in support of communities affected by displacement in CAR and it entails 1) financial support to the most vulnerable households among displaced populations and the communities affected by COVID19 and the recent floods, 2) Supporting the government of CAR in the training and capacity development of relevant ministerial bodies and entities on social safety nets and Cash transfer mechanisms.

Based in Kinshasa in the Democratic Republic of Congo (DRC), since 1991, the UNOPS Central Africa Hub (CDOH) covers eleven countries: Angola, Burundi, Cameroon, Central Africa, Comoros, Gabon, Equatorial Guinea, Democratic Republic of Congo (DRC), Republic of Congo, Madagascar, Rwanda. The Hub has forged strong working relationships with international partners, United Nations agencies, including United Nations missions, and governments of Central African countries.

I. Database Implementation:

• Provide a professional implementation of data architecture standards and services including: Implement Store Procedures, Functions and Views using SQL Server Transact-SQL or MySQL;

• Support the creation of databases and data warehouse ETL process:

  • Registration of the beneficiaries of the project, generation of list of beneficiaries, various analysis and reports on the registration process;

  • Develop data entry format and reporting designs through reviewing the documentation process and file repository of the the project;

• Develop, implement and optimize stored procedures and functions using T-SQL

• Develop procedures and scripts for data migration;

• Participate in design reviews of solutions with structured and unstructured data covering data integration, data flow, data warehouse, and business intelligence;

• Conduct interviews with application stakeholders, facilitate data-modeling sessions, write business and technical requirements, and apply standards and best practices.

• Manage business and product owner relationships and enable their understanding and appreciation of technical possibilities and constraints.

• Analyze existing databases and identify opportunities for data consolidation and design improvement. Analyze existing SQL queries for performance improvements;

• Take responsibility for the overall integrity, quality, accessibility, and accuracy of information across multiple database applications;

II. Project Support and Knowledge Management:

• Provide technical and business support to the project activities;

• Advise the project management team for the required information format, data entry, report format, etc., relating to operations and performances of a registration database. Advise on the software and hardware to be used for the registration process;

• Develop, maintain and share database design documentation and operating manuals on how to use the Database;

• Take part in field missions and support field operations in remote areas with the project teams;

• Perform data analysis and prepare reports with assistance from the project staff;

• Provide training and coordinate knowledge sharing sessions to selected staff members of the project and its stakeholders;

• Maintain strict data confidentiality for sensitive data;

• Perform other duties as required and assigned by the supervisor.

• A Bachelor’s degree in Computer Science, Statistics, Information Systems or related fields is required

• 2 years’ experience, in Computer Science, Information Systems, or Statistics comfortable working, developing and managing databases for several types of data and information is required

• A minimum 2 years of experience in programming and use of Microsoft Excel and databases, SQL and VBA, 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 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 desired. Good knowledge of HTML and JavaScript is desirable.

• Experience in analyzing data and producing reports is an advantage.

• Any experience with mobile payments/mobile money transfers would be an asset.

• Any experience with field coordination with participation in the assessment of community needs and resources would also be an asset.

• 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.
• UNOPS seeks to reasonably accommodate candidates with special needs, upon request.
• 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
• For retainer contracts, you must complete a few Mandatory Courses (around 4 hours) in your own time, before providing services to UNOPS.
• The incumbent is responsible to abide by security policies, administrative instructions, plans and procedures of the UN Security Management System and that of UNOPS.  
• CANDIDATES WITH NO UN  EXPERIENCE ARE STRONGLY ENCOURAGED TO APPLY
• CENTRAL AFRICAN REPUBLIC IS NON DUTY FAMILY MISSION

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.

Équilibre entre le travail et la vie personnelle:  L'UNOPS accorde de la valeur à son personnel et reconnaît l'importance de maintenir un équilibre entre les responsabilités professionnelles et personnelles. Nous avons une politique progressiste en la matière et offrons plusieurs possibilités d'horaires flexibles. Cette politique s'applique au personnel de l'UNOPS et pour tout type de contrats. 

L'UNOPS cherche à accommoder raisonnablement les candidats ayant des besoins particuliers, sur demande. 

UNOPS is an operational arm of the United Nations, supporting the successful implementation of its partners’ peacebuilding, humanitarian and development projects around the world. Our mission is to help people build better lives and countries achieve sustainable development.

UNOPS areas of expertise cover infrastructure, procurement, project management, financial management and human resources.

Working with us

UNOPS offers short- and long-term work opportunities in diverse and challenging environments across the globe. We are looking for creative, results-focused professionals with skills in a range of disciplines.

Diversity

With over 4,000 UNOPS personnel and approximately 7,000 personnel recruited on behalf of UNOPS partners spread across 80 countries, our workforce represents a wide range of nationalities and cultures. We promote a balanced, diverse workforce — a strength that helps us better understand and address our partners’ needs, and continually strive to improve our gender balance through initiatives and policies that encourage recruitment of qualified female candidates.

Work life harmonization

UNOPS values its people and recognizes the importance of balancing professional and personal demands.