RFP for Consultant to Conduct Data Analysis and Report Writing Shelter & Latrine Census in Dadaab Refugee Camp in Kenya

1. Background

   Peace Winds is a Japanese Non-Governmental Organization established in 1996. Peace Winds has been providing humanitarian and development assistance for people affected by forced displacement and natural disasters in more than 20 countries in the world. Peace Winds launched its mission in Kenya in 2012 and has been implementing projects funded by UN agencies and the government of Japan. PWJ works in Garissa, Turkana, and West Pokot Counties where we implement projects on livelihoods (food security, and skills development for women and youth empowerment), WASH (water, sanitation, and hygiene), shelter and infrastructure, and supply chain management.

Peace Winds is currently implementing a WASH, Shelter and Logistics project in Dadaab refugee camp funded by UNHCR, that seeks to improve shelter, sanitation and hygiene for refugees and host communities and as well water supply to the refugees, host communities, and institutions such as health facilities and schools.

The purpose of the shelter and latrine census is to provide data on the number, types of shelter and latrine, and their conditions. The census data can help to serve as a baseline for further assessments. Peace Winds will be conducting a shelter / latrine census in March 2024. The census will be conducted to all households (approximately 74,783) in the Dadaab refugee camp (Dagahaley, Ifo, Ifo2 and Hagadera). Peace Winds therefore is seeking to engage a consultant to document the census findings and submit a final report.

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.

1. 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

1. 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

1. Assignment Duration

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

1. 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.

1. 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

7. How to apply

Interested bidders shall prepare and submit technical and financial proposal as indicated in the guidelines below:

Technical Proposal

The consultant’s technical proposal shall contain the following:

• Clear understanding of the terms of reference including any relevant comments
• A clear methodology on how the consultant will undertake the assignment
• Work Plan with clear duties and responsibilities
• Summary of Consultant’s experience in undertaking assignments of similar scope and/or complexity (last 8 years)
• Consultants qualifications (include CVs of proposed consultant)
• Written commitment by the consultant affirming availability to conduct the entire assignment. (No substitution of interviewed consultants will be allowed once selected). The lead consultant will be expected to undertake the exercise in person.
• 2 sample reports from similar assignments
• Contact details of a minimum of 3 references from reputable organizations that the consultant has worked with over the past 5 years clearly indicating description of assignment, date/s of execution, name of organization and details of contact person (e-mail and telephone contact)

Note: The consultant’s technical proposal shall not exceed 20 pages. This excludes any annexes.

Financial Proposal

The consultant’s financial costing to undertake the assignment will be provided separately and should cover all costs associated with execution of the planned activities excluding travel expenses, and accommodation. The financial proposal shall be in Kenya Shillings.

The consultant will utilize the following budget template for their financial proposal:

Description

Unit

Qty

Rate (KSh)

Amount (KSh)

Consultants professional Fees

man-days

Communication costs

Other costs (indicate)

Taxes (indicate relevant tax) %

Total

Validity of Bid

Bidders shall clearly indicate that their bid is valid for a period of not less than 30 days from the date of submission.

Proposal Submission

The Technical Proposal shall be submitted comprising (a) Letter of submission duly signed by authorized bidder representative, (b) Main Technical Proposal document in PDF format, (c) Attachments to Technical Proposal in PDF (statutory requirements, CVs)

The Financial Proposal shall be submitted comprising (a) Financial Proposal Document duly signed by authorized bidder in PDF format and (b) Detailed calculations sheet in MS Excel format.

Interested candidates or organizations should submit electronic copies of technical and financial proposals with the e-mail clearly headed “Proposal for Consultancy to Conduct Data Analysis and Report Writing for Shelter & Latrine Census in Dadaab Refugee Camp in Kenya” with the technical and financial proposal documents clearly labeled as ‘TECHNICAL PROPOSAL’ and ‘FINANCIAL PROPOSAL’ respectively.