Description
Background:
Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, in hardship, in more than 40 countries around the world, we partner to put bold solutions into action โ helping people triumph over adversity and build stronger communities from within.
Over the past eight years, Mercy Corps has established a reputation for quality and timely data and analysis through its network of Crisis Analysis teams. Through Crisis Analysis, the agency has carved out a niche among information providers in the humanitarian and development space, owing to the granularity, reactivity and holistic approach of our products, which focus on some of the most hard-to-reach, data-poor and complex contexts requiring assistance. This is underpinned by Mercy Corpsโ status as an operational INGO, which ensures that analysis products are practicable and relevant for humanitarian actors.
Purpose / Project Description:
The Middle East Regional Data Analysis Hub (MERDAH) is a platform where quantitative indicators developed by ME Crisis Analysis teams can be accessed, analyzed, and downloaded. The dashboard aims to show MC's capacity to develop timely and relevant quantitative analysis in the ME region and for other peers and external stakeholders to use, and to eventually serve several key objectives/purposes as part of our evidence-driven commitment. Dashboard modules are regionally cross-cutting by theme or approach; for example, agriculture analysis (theme) or price predictions (approach). The MERDAH currently covers Syria, Iraq, Palestine, Lebanon, and Yemen. The MERDAH will also host the drought and flooding anticipatory action modules produced for the ECHO-funded MEACAM project.
The platform allows users to freely download quantitative indicators useful for targeting (Operational actors; Peer agencies) to identify the most vulnerable locations for interventions and advocacy & influence (donors; local/national Governments; media), which are not immediately operational but useful for understanding the context to improve decision-making. For example, Mercy Corps LCAT developed an economic vulnerability indicator using night lights satellite imagery the Lebanon country team used to target cadasters for a MPCA program. The CA-SYR team used satellite imagery to measure the effect of the second-consecutive drought in northeast Syria to highlight the scale and intensity of the repercussions on farmers, the results of which were featured in a NES Forum publication advocating for funding to alleviate the situation.
The continual enhancement of the MERDAH is necessary to obtain and maintain a high level of relevance and utility to the community, and serve as an attraction to donors. Further, timely additions to the MERDAH ensures that Mercy Corps is the โfirst to marketโ to deliver actionable spatial and quantitative analysis to the humanitarian community.
Consultant Objective:
A front-end developer, in collaboration with technical support and close coordination with the Regional Data Analysis Specialist and the CA-SYR Director, Yemen CA Team Lead, and Lebanon CA Team Lead will need to produce the following for the MERDAH:
Country/Project
Total Days
Syria
22.5 days
Yemen
23.5 days
Lebanon
13.5 days
MEACAM
42 days
Total
101.5
Syria
- SMEB/MEB with input cash gap (2 days)
- Add the historic and predicted price of the SMEB and MEB.
- Add a user-entered monthly transfer value to calculate the โcash gapโ between the hypothetical transfer value and (S)MEB price.
- \"Make a basket\" feature (2.5 days)
- Add a โmake a basketโ feature that allows users to select each available WFP item and define a quantity for each item.
- Add a line graph displaying the sum of all the selected item prices, multiplied by the selected quantity. This line graph will show the historic and predicted prices.
- Predicted basket prices are simply the sum of the existing predicted (selected) item prices.
- Pass-through effect (4 days)
- Develop a module that measures the pass-through effect of all WFP items, including wage rates.
- SYP/USD, TRY/SYP, and TRY/USD on item prices.
- Allow the user to select the date range to calculate the pass-through effect.
- Minimum 10 months.
- Allow up to three ranges to compare changes in the pass-through effect over time.
- Display the pass-through effects in a bar chart and mark their statistical significance.
- Side-by-side bar chart for multiple time periods.
- Add NLR time trends to subdistrict GDP estimate map (4 days)
- Make a line graph of monthly night lights reflectance (NLR) for subdistricts selected on the regional GDP map.
- If no subdistricts are selected, then the NLR for the whole of Syria will be displayed.
- Ability to select up to 5 different subdistricts, which creates 5 lines on the line chart.
- NLR images piped in from Google Earth Engine.
- Agriculture Module (10 days)
- Measure the NDVI and NDMI of agricultural areas in Syria using Sentinel-2 data.
- Calculate NDVI and NDMI in agricultural areas near canals, rivers, and in-land.
- Visualize changes in these indicators in a line graph akin to Figure 4 in a 2022 CA-Syria report.
- Map these changes on an interactive map akin to Figures 7 to 9 in a 2022 CA-Syria report.
- Relate changes in NDVI/NDMI to agriculture indicators recorded in REACHโs HSOS assessment.
- Community-level NDVI/NDMI changes to community-level REACH indicators.
Yemen
- SMEB/MEB with input cash gap (2 days)
- Add the historic and predicted price of the SMEB and MEB.
- Add a user-entered monthly transfer value to calculate the โcash gapโ between the hypothetical transfer value and (S)MEB price.
- \"Make a basket\" feature (2.5 days)
- Add a โmake a basketโ feature that allows users to select each available WFP item and define a quantity for each item.
- Add a line graph displaying the sum of all the selected item prices, multiplied by the selected quantity. This line graph will show the historic and predicted prices.
- Predicted basket prices are simply the sum of the existing predicted (selected) item prices.
- Pass-through effect (4 days)
- Develop a module that measures the pass-through effect of all WFP items, including wage rates.
- YER/USD on item prices.
- Allow the user to select the date range to calculate the pass-through effect.
- Minimum 10 months.
- Allow up to three ranges to compare changes in the pass-through effect over time.
- Display the pass-through effects in a bar chart and mark their statistical significance.
- Side-by-side bar chart for multiple time periods.
- Price forecasting: Part 1 (9 days)
- Add item and MEB projections using REACH Market Monitoring price data (JMMI)
- Develop USD projections for items and MEB.
- Add graph that shows past MERDAH MEB predictions compared to observed WFP/REACH MEB prices
- Starting from September 2022.
- Develop MEB affordability predictions for the WFP MEB price.
- Because WFP records wage rates.
- Develop individual market forecasts for the MEB.
- REACH and WFP prices.
- Price forecasting: Part 2 (6 days)
- Develop item forecasts for individual markets.
- Develop a now-casting model to predict prices in markets with incomplete data.
Lebanon
- Migrate LCAT dashboard to MERDAH (3 days)
- Replace the Lebanon module in the MERDAH with the LCAT dashboard.
- Ensure they are synced, so changes in the LCAT dashboard are reflected in the Lebanon MERDAH version simultaneously.
- In the Economic Vulnerability Index module:
- Change the default to โpopulation-weightedโ
- Add a filtering option to select the top 10 most vulnerable cadasters in a district, ranked by the EVS score. This would change depending on whether the user selected population weighted or not. Then allow users to export this top-10 selection to a CSV.
- Replace the Lebanon module in the MERDAH with the LCAT dashboard.
- Migrate LCAT dashboard to MERDAH (3 days)
- Develop a module that measures the pass-through effect of all WFP items, including wage rates.
- SMEB/MEB with input cash gap (2 days)
- Community-level NDVI/NDMI changes to community-level REACH indicators.
- Make a line graph of monthly night lights reflectance (NLR) for subdistricts selected on the regional GDP map.
- Develop a module that measures the pass-through effect of all WFP items, including wage rates.