Consultant - Data Engineer SSA8, NOA Equivalent

ABOUT WFP

The United Nations World Food Programme is the world's largest humanitarian agency fighting hunger worldwide.  The mission of WFP is to help the world achieve Zero Hunger in our lifetimes.  Every day, WFP works worldwide to ensure that no child goes to bed hungry and that the poorest and most vulnerable, particularly women and children, can access the nutritious food they need.

ORGANIZATIONAL CONTEXT

Background

Kenya Country Office (KECO) collects Monitoring and Evaluation (M&E) data frequently. The previous database that was used to store data is not functioning properly. As a result, it is difficult do real time data visualization to inform for internal use. Following the architecture for a Data Warehouse/Lake provided by our corporate IT unit, KECO M&E need to rebuild their database conforming to the guidelines and make the necessary connectors to allow easier use of analytical and visualization tools such as SPSS and Tableau. The M&E data will be part of a larger Kenya Country Office data warehouse solution.

JOB PURPOSE

This position will report to the Business Transformation Officer in Nairobi.

KEY ACCOUNTABILITIES (not all-inclusive)

Main Activities:

1. Develop data warehouse/data lake (following defined architecture and only as applicable for M&E data) for ease of use, organization, accessibility, security, compliance, performance, scalability, monitoring, and availability;
2. Under M&E guidance, clean, transform, aggregate and integrate M&E data into data warehouse;
3. Develop ETL system and data pipelines (following defined standards) that move data from a variety of sources into warehouse, monitor data quality, check for errors and conform data to standards; use the WFP corporate ETL/data-lineage tools;
4. Build Database objects (tables, views, stored procedures, functions, etc.) and data services that provide data in format most useful for analysis;
5. Maintain data pipelines, architecture and schemas to maximize the (re-)usability, accuracy, robustness, performance, and scalability;
6. Collaborate with KECO and IT HQ teams to ensure standards are maintained
7. Document technical specifications and work in appropriate tools.

Main Responsibilities:

• Build the Data Lake for M&E Data based on the RMT defined Architecture and using the WFP Corporate ETL/data lineage tools.
• Migrate data from old M&E database to Data Lake.
• Migrate data from ONA (online M to Data Lake
• Develop API (where required) to facilitate an easier process to maintain.
• Manage project deliverables and timelines

STANDARD MINIMUM QUALIFICATIONS

Education: Advanced university degree in Computer Science, engineering or other relevant field, or First University degree with additional years of related work experience or trainings/course.

• B.S. in CS, Engineering or other relevant field with additional years of related work experience or trainings/course.  Advanced university degree in Computer Science, Engineering
• 2+ years of ETL/data engineering work (e.g. ETL (Extract Transform Load (ETL), data lakes, data marts, data warehousing)
• 4+ years of professional software engineering
• Knowledge and experience working with Hadoop stack (Horton Works)
• Experience working with/constructing Relational and noSQL/MongoDB databases
• Experience working with engineers and business analysts to solve data needs
• Experience working with/building a data pipeline
• Experience building flexible data APIs
• Experience working with Tableau

Desirable:

• Ability to perform testing and regression testing and ensure high quality product work (e.g. ETL/ELT to the Data Lake, using the Data Lake for data analysis)
• Skilled at documenting data warehouses and hierarchies, process flows
• Experience in metadata management and data quality processes and tools
• Knowledge of Hadoop tools (e.g. Hive, Impala, Pig, Sqoop, Hue, Kafka, etc.)

FUNCTIONAL CAPABILITIES

DESIRED EXPERIENCES FOR ENTRY INTO THE ROLE

Skills and Competencies:

• Independent worker able to manage project timelines and priorities;
• Advanced analytical thinking and problem-solving skills;
• Strong communication skills with the ability to compile and present information;
• Good interpersonal skills and demonstrated ability to work within a team environment
• Experience working in an international organisation or multicultural environment will be an added advantage.
• Understanding of WFP’s Core mission and values.
• Language skills: Fluent English (spoken and written).

TERMS AND CONDITIONS

WFP is an equal opportunity employer and does not charge a fee at any stage of the recruitment process.  Only short listed applicants will be contacted.

FEMALE APPLICANTS ARE ESPECIALLY ENCOURAGED TO APPLY.

if you have any queries please write to Nairobi.queryhr@wfp.org.

DEADLINE FOR APPLICATIONS

Deadline for receiving applications: 3 April 2018.

Duration: 3 months with possibility of extension                                          

.

Female applicants and qualified applicants from developing countries are especially encouraged to apply

WFP has zero tolerance for discrimination and does not discriminate on the basis of HIV/AIDS status.

No appointment under any kind of contract will be offered to members of the UN Advisory Committee on Administrative and Budgetary Questions (ACABQ), International Civil Service Commission (ICSC), FAO Finance Committee, WFP External Auditor, WFP Audit Committee, Joint Inspection Unit (JIU) and other similar bodies within the United Nations system with oversight responsibilities over WFP, both during their service and within three years of ceasing that service.