Data analysis and Monitoring

United Nations Children's Fund

Mogadishu, Somalia

Experience: 5 to 10 Years

Skill Required: Monitoring and Evaluation

UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential. Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone.

Somalia has been in a protracted conflict complicated by multitude of other problems such as recurrent bouts of drought, disease outbreaks, high youth unemployment rate and ever-increasing number of people in the IDP camps. The health risks for children in emergencies are higher.

Life-saving health services are often unobtainable or unreachable, making newborns, children, young people, and mothers especially vulnerable to harm. Too often, simple cost-effective interventions are out of reach of the mothers and babies who need them most.

Objective of the consultancy:

The purpose of the consultancy is to provide technical assistance to UNICEF Somalia on monitoring of its development and emergency programme. This includes support in monitoring, data management, data analysis and visualization for key programmatic reports, presentations, meetings, and donor proposals as per UNICEF and donor requirements.

The specific objectives to achieve in the scope of the consultancy are as follows:

Support to Health Program Development & Planning:

  • Contribute to the development, review and updating of the section goals, strategies, and framework to guide implementation of upcoming programme/ projects. This includes review of proposed log-frame, provide data and analysis on the indicators set.
  • Conduct situational analysis for results-based planning through analysis of health needs and areas for intervention and submission of recommendations for priority and goal setting.
  • Participate in strategic program discussions on the planning of health programs. Formulate, design, and prepare sections of health program proposals, reports ensuring alignment with UNICEF’s Strategic Plan, the Country Program.
  • Conduct and update the situation analysis for the development, design of new health programmes and the writing of upcoming key reports.
  • Research and report on development trends (e.g., health, political social, economic) for higher management use to enhance program management, efficiency, and delivery of results.

Data management and Analysis:

  • Plan and/or collaborate with internal and external partners to establish monitoring benchmarks, performance indicators, and other system indicators and measurements to assess and strengthen performance accountability.
  • Prepare and assess monitoring and evaluation reports to identify gaps, strengths and/or weaknesses in program implementation and identify lessons learned and use knowledge gained to guide decision making and action.
  • Support planning of programme monitoring activities especially related to the emergency response. Develop monitoring checklist as per implementation plans, field visit plans for the section and review monitoring reports identifying key findings and develop a follow up action plan or refer/ escalate for timely resolution.
  • Prepare regular and mandated data and analysis for section updates and reports.
  • Support the evaluation and analysis of location specific datasets through meaningful statistical techniques; participate in the development and revision of data standards; understand, document, and ensure the quality of high value humanitarian data for accuracy, consistency, and comparability.
  • Manage the 3Ws matrix for the health section integrating with other sections- WASH, Nutrition, and protection (WHO does WHAT, WHERE).
  • Support assessment and needs analysis activities, including humanitarian needs overviews, secondary data reviews, preliminary scenario definitions and multi-sectoral rapid assessments.
  • Support the management of platforms and tools that support data collection and analysis.


  • Assist in the production and updating of information products such as reports, charts and infographics by turning data into graphical products to convey messages and a storyline; develop advocacy materials including posters, presentations and other visual materials using Adobe tools, etc.
  • Creating interactive dashboards using Power BI.

Geographic Information System (GIS) & Mapping:

  • Provide GIS support to the health section and assist in the development of appropriate maps and infographic products to support health section (development and humanitarian) decision-making and reflect humanitarian response.
  • Support the maintenance of an inventory of produced maps and, where possible, those available from other humanitarian partners.

To qualify as an advocate for every child you will have… 

  • Master’s degree in Public Health (MPH) / medical statistics / epidemiology or an equivalent degree from a recognized University or College including any equivalent experience.
  • At least 5 years of work experience with health management information systems in large organizations or at country level.
  • Experience in Somalia or other conflict / post-conflict countries is an added advantage.
  • Demonstrated experience in data collection, data analysis as well as preparing reports and presentations. Sound knowledge of DHIS, data analysis and management.
  • Good interpersonal and communication skills and good analytical skills.
  • Solid experience with common Microsoft Office packages and advanced MS Excel skills and experience working with large datasets required. Good working knowledge of PowerBI is an advantage.
  • Software Skills: Data capture and analysis: MS Excel (Essential), ability to create macros, strong knowledge of statistical, conditional, and text-based functions, knowledge of MS Access, visual basic and other database applications (eg: SQL, MySQL, Oracle) is an advantage.
  • Mapping: Capacity of map making process is essential, Knowledge of tools such as ArcGIS, MapInfo, QGIS, Adobe creative suite for mapping and graphic design is an advantage.
  • Knowledge and understanding of the UN system and capacity to promote consensus and establish positive working relationships and work in a team. Integrity, tact, discretion and demonstrated sensitivity to cultural differences.
  • Fluency in English (written and spoken)