Data Cleaning and Dashboard Development
Support data cleaning and visualization for training initiatives in the African region.
Overview
Support data cleaning and visualization for training initiatives in the African region.
You have:
- Background in data analytics, statistics, informatics, or related data-driven fields (some familiarity with public health is a plus)
- Proficiency in Excel and at least one data visualization platform (Power BI, Tableau, or Google Data Studio)
- Experience with data cleaning tools or scripting languages (e.g., R, Python, OpenRefine)
- Ability to work independently and under supervision, with strong attention to detail.
- Strong communication and documentation skills
Contract
This is a UNV contract. More about UNV contracts.
As part of efforts to enhance data-driven decision-making in regional training and learning initiatives, the WHO AFRO team is seeking an Online Volunteer to support the cleaning, structuring, and visualization of training data. This role will contribute to improving the monitoring, planning, and strategic alignment of emergency workforce development efforts across the African region.
Under the supervision of the Training Officer and in collaboration with the M&E team, the Online Volunteer will:
• Clean and structure existing training datasets (2023–2025) • Build a functional, interactive dashboard to visualize training data across countries and technical areas. • Ensure dashboard compatibility with other WHO data systems and dashboards. • Assist in streamlining and organizing training indicators and KPIs for effective visual representation. • Support both basic and advanced analysis of training reach, completion, and engagement metrics. • Provide recommendations and documentation on how to maintain and update the dashboard regularly
Expected results
- A functional interactive dashboard visualizing regional training data and designed to integrate with WHO’s internal platforms.
- A cleaned and structured dataset with standardized formatting, covering activities from 2023 to 2025.
- A short guide with recommendations for dashboard maintenance and sustainability.
- Improved organization and visualization of training indicators and KPIs for data use in strategic planning and reporting.
• Background in data analytics, statistics, informatics, or related data-driven fields (some familiarity with public health is a plus) • Proficiency in Excel and at least one data visualization platform (Power BI, Tableau, or Google Data Studio) • Experience with data cleaning tools or scripting languages (e.g., R, Python, OpenRefine) • Ability to work independently and under supervision, with strong attention to detail. • Strong communication and documentation skills
Potential interview questions
| Describe a time when you had to clean a large dataset. What approach did you take? | The interviewer wants to assess your experience and methodology in data cleaning. | Provide a specific example focusing on your process and tools used. |
| What data visualization platforms are you familiar with, and how have you used them in the past? | This question evaluates your technical skills in data visualization. | Pro members can see the explanation. |
| Can you give an example of a complex dataset you have structured and the tools you used? | Pro members can see the explanation. | Pro members can see the explanation. |
| How do you ensure the accuracy and quality of your visualizations? | Pro members can see the explanation. | Pro members can see the explanation. |
| What has been your experience in collaborating with teams for data projects? | Pro members can see the explanation. | Pro members can see the explanation. |
| Explain how you would maintain an interactive dashboard over time. What tasks do you see as essential? | Pro members can see the explanation. | Pro members can see the explanation. |
| Discuss how you prioritize when managing multiple data tasks. | Pro members can see the explanation. | Pro members can see the explanation. |
| What metrics do you find most valuable when assessing training reach and engagement? | Pro members can see the explanation. | Pro members can see the explanation. |