RFP for Consultant to Conduct Data Analysis and Report Writing Shelter & Latrine Census in Dadaab Refugee Camp at Peace Winds Japan

Objective of the assignment

The consultancy task is to analyze the census data and document the findings in a comprehensive report. The consultant shall analyze data in table formats, and submit the final report. The analyst should understand the desired goal of the project driving the findings towards it. The objectives of the census are driven under:

• Assessing Shelter/latrine Conditions: The primary objective is to gather comprehensive data on the current state of shelters within the refugee population. This includes assessing the type of shelters, their conditions, and any vulnerabilities or deficiencies.
• Identifying Shelter/latrine-related Needs: Understand the specific needs and challenges related to housing in the refugee camps. This involves identifying issues such as overcrowding, inadequate infrastructure, lack of basic amenities, and other factors affecting the quality of shelter/latrine.
• Quantifying the Population: Enumerate and categorize the population living in different types of shelters. This information is crucial for resource allocation, as it helps in estimating the scale of interventions required to address the housing needs of the refugees.
• Creating Baseline Data: Establish a baseline for monitoring and evaluation purposes. This baseline data serves as a reference point for future assessments, allowing for the measurement of changes and the impact of interventions over time.
• Enhancing Resource Allocation: Enable efficient allocation of resources by identifying priority areas and populations with the greatest housing needs. This ensures that interventions are targeted and resources are utilized effectively.
• Supporting Advocacy Efforts: Generate evidence for advocacy initiatives aimed at raising awareness and garnering support for policies and funding related to shelter/latrine issues. The data collected can be used to build a compelling case for improved living conditions.
• Ensuring Accountability: Establish accountability mechanisms by providing transparent and evidence-based information to stakeholders, including donors, governmental agencies, and the community itself.

Scope of the work

• Data Cleaning and Validation: Review and clean the collected shelter/latrine/livestock census data to ensure accuracy and consistency. Validate the data for completeness, identifying and addressing any missing or inconsistent information.
• Data Analysis: Conduct statistical analysis of shelter/latrine/livestock census data to derive meaningful insights and trends.
• Utilize appropriate statistical tools and methods to analyze demographic information, shelter conditions, and other relevant variables.
• Descriptive Analysis: Generate descriptive statistics to provide a comprehensive overview of the shelter-related characteristics within the surveyed population. Summarize key findings, including averages, distributions, and patterns.
• Mapping and Visualization: Create maps and visual representations of the census data to facilitate a better understanding of spatial patterns and distribution of shelter-related indicators. Use Geographic Information System (GIS) tools if applicable.
• Identifying Key Challenges and Opportunities: Highlight key challenges and opportunities based on the analysis, providing actionable insights for program planning and improvement.
• Report Writing: Prepare comprehensive and clear reports summarizing the findings of the census data analysis.
• Present the results in a format suitable for diverse audiences, including policymakers, donors, and the community.
• Recommendations: Provide evidence-based recommendations for programmatic interventions based on the data analysis. Suggest improvements and strategies to address identified challenges and enhance the impact of shelter/latrine-related interventions.

Deliverables

• Deliverable 1: Inception report containing detailed methodology for data analysis
• Deliverable 2 : Census analyzed data in readable format (The graphics should entail right scaling and informative graphic headings.Note:(Poorly located and labeled axes, insufficient use of color, shape and size that can obscure the relationship in data or make the data hard to read and interpret should be avoided)
• Deliverable 3 : Census report in MS word and PDF versions and Cleaned dataset

Reporting Modalities

The consultant will work with Peace Winds Shelter Engineer and Spatial planer in Dadaab, with overall guidance of the Project Manager. The M&E team will work closely with the consultant by:

• Providing the raw data collected from the census.
• Validation of the analysis ensuring it meets the standard of Peace Winds.
• Review of the report done by the Consultant

Assignment Duration

• The consultant is expected to carry the assignment in 7 working days in March, 2024.

Qualification, required skills

The consultant to be engaged in this assignment must have;

• A degree in Social Sciences, Statistics, BSc. degree in Public Health or Water Engineering from a recognized university with experience of at least 8 years in a similar discipline.
• Master degree in Development Studies, Monitoring and Evaluation, Social Sciences, Project Management, Public Health or WASH discipline is an added advantage.
• Experience of having conducted 3 similar assignments over the past 5 years .
• Strong background in statistics and data analysis of qualitative and quantitative methodology and use of mobile data collection tools (Kobo).
• Good communication and inter-personal skills.
• Previous work experience with NGOs in WASH and shelter interventions, especially in a humanitarian context.
• Excellent report writing in English and presentation skills.

Competencies

• Strong research and excellent writing skills in English
• High proficiency in the use of MS Word, SPSS, Excel and other analysis applications
• Excellent organizational skills
• Ability to meet deadlines and work under pressure
• Strong interpersonal skills