Support UNDP Kenya with Data Analysis

Volunteering

Overview

Support UNDP Kenya in data analysis and dashboard development.

You have:

• Currently pursuing or recently completed a degree in IT, Computer Science, Data Science or a related field.
• Familiarity with Power BI and basic understanding of DAX and Power Query (M language).
• Proficiency in Microsoft Excel and basic SQL.
• Excellent organizational and time-management skills.
• Strong attention to detail and ability to handle confidential information.
• Excellent interpersonal and communication skills.
• Knowledge of data cleaning and transformation tools (Power BI, Power Query, Excel, SQL, ETL Tools) is an advantage.
• Proactive and willing to learn and contribute.
• Strong analytical and problem-solving skills.

Contract

This is a UNV contract. More about UNV contracts.

In today’s digital environment, the ability to collect, manage, and analyse data is critical to ensuring efficiency, transparency, and strategic decision-making. As part of its digital transformation strategy, UNDP Kenya is investing in improving its ICT capabilities, with a focus on data-driven operations, reporting, and service delivery. The ICT Department plays a central role in supporting the organization's information systems, technology infrastructure, and data management frameworks. With the increasing volume and complexity of data generated from operational, programmatic, and administrative activities, there is a need for dedicated analytical capacity to support evidence-based planning and performance monitoring. UNDP Kenya seeks support with data analysis to enhance the extraction of meaningful insights from internal and external datasets, develop visual dashboards using tools like Power BI, and support data quality assurance and governance efforts. This support will help bridge the gap between technical data handling and decision-making, contributing directly to more informed strategy and operations across the organization.

Under the supervision of the Head of ICT and in close collaboration with the ICT/Finance/Procurement and HR team, the online volunteer will: • Support the design, development, and maintenance of interactive dashboards and reports. • Assist in cleaning, transforming, and analyzing data to generate actionable insights. • Contributes to the automation and optimization of reporting processes. • Connect to multiple data sources (Excel, SQL databases, APIs, cloud services, etc.). • Build interactive dashboards and reports using:(Charts (bar, line, pie, Tables and matrices, Slicers and filters, Maps and KPIs) • Design for user experience: consistent layout, intuitive navigation, color themes. • Schedule data refreshes via Power BI Service. • Provide general administrative and ICT support to the ICT unit as required.

Expected Outputs: • Functional and user-friendly Power BI dashboards and reports. • Cleaned and well-documented datasets. • Documentation of data sources, transformations, and business logic. • Weekly status updates and a final presentation/report summarizing work completed. • Share dashboards with stakeholders and manage access via workspaces and row-level security (RLS).

Education:

Applicants at the time of application, applicants must meet one of the following:

• Currently pursuing or recently completed a degree in IT, Computer Science, Data Science or a related field. (such as a master’s programme, or higher) • Currently pursuing or recently completed a degree in Software Engineering • Be enrolled in the final academic year of a first university degree programme (such as bachelor’s degree or equivalent) • Have recently graduated with a university degree (as defined in (a) and (b) above) and, if selected, must start the internship within one year of graduation. • Be enrolled in a postgraduate professional traineeship program and undertake the internship as part of this program.

Experience:

• Familiarity with Power BI and basic understanding of DAX and Power Query (M language). • Proficiency in Microsoft Excel and basic SQL.

Required Skills

• Demonstrated interest in Data Analysis using Microsoft Excel and Power BI. • Excellent organizational and time-management skills. • Strong attention to detail and ability to handle confidential information. • Excellent interpersonal and communication skills. • Proficiency in Microsoft Office Suite (Excel, Word, PowerPoint). • Knowledge of data cleaning and transformation tools (Power BI, Power Query, Excel, SQL ,ETL Tools) is an advantage. • Proactive and willing to learn and contribute • Strong analytical and problem-solving skills.

Apply now

Potential interview questions

Added 1 year ago - Updated 11 months ago - Source: unv.org