OBJECTIVE OF CONSULTORY.
- Carry out an analysis of the socioeconomic and political context of Venezuela in the states Zulia, Falcón, Táchira, Apure, Capital District, Lara, Sucre Bolívar, Delta Amacuro and Anzoátegui, which allows us to understand reality, the contextual determinants, the actors, the causes and effects of the crisis, as well as the different vulnerabilities and needs of people.
- Perform a data analysis that includes creating a Dashboard of graphics / visualizations in Power BI from the primary CIR data, with the aim of generating solid evidence that allows characterizing the CIR client profile, including demographic, vulnerability, comprehensive care, among others, for each programmatic sector and implementing partner. The variables of analysis of interest will be shared by the CIR, as well as the databases of the clients served by CIR Venezuela.
GENERAL ACTIVITIES.
Under the supervision of the MEAL Coordinator and in coordination with the Senior MEAL Officer of CIR Venezuela, the consultant must complete the following processes:
Analysis of the CIR primary data – Clients served Venezuela Program.
- Prepare and validate a work plan agreed with the CIR in order to meet the obligations and compliance of the products under the technical and administrative conditions of the contract.
- Review and transform ( ETL process – Extraction, Transformation and Load ) the consolidated databases of clients served for later loading in Power BI for analysis, based on the variables of interest in each of the program areas ( that will be shared by the CIR ).
- Validate the feasibility of analyzing the variables proposed by the CIR based on the existing information available in the consolidated databases of clients served.
- Prepare a Power BI dashboard that consolidates the graphs / visualizations of the processed data and that allows the reading, interpretation and analysis in a clear and summarized way by management level: by state and at the national level, at the program level ( Health, Education, CP, and WPE ) and by implementing partner. A minimum of two drafts of this dashboard must be presented for review and incorporation of CIR recommendations.
- Train the people delegated by the CIR in Power BI to update and generate the automated report of the findings generated by management level: by state and at the national level, at the program level ( Health, Education, CP, and WPE ) and by implementing partner.
- Design a User Manual, as a technical document to guide the Programs and MEAL team in the use of data analysis tools to extract information of interest for each level of management.
- Training for the coordination and management of MEAL Programs and equipment in the use of data analysis tools for the extraction of information of interest by each level of management.
- Preparation and presentation of the final report of the analysis of the CIR primary data, including the main findings and recommendations by management level of maximum 8 pages
Analysis of the socioeconomic and political context of Venezuela:
- Propose a structure or skeleton for the document Analysis of the socioeconomic and political context of Venezuela, for the prioritized territories and agree or adjust it according to the CIR feedback
- Prepare a document Analysis of the socioeconomic and political context of Venezuela, Zulia, Falcón, Táchira, Apure, Capital District, Lara, Sucre Bolívar, Delta Amacuro and Anzoátegui, based on secondary information and primary information from CIR and with bibliographic sources
- Present at least two drafts of the document Analysis of the Socioeconomic and Political Context of Venezuela, and incorporate the recommendations of CIR
- Prepare a bank of documents consulted and referenced as secondary sources, to carry out the context analysis
INSUMES.
To fulfill the objectives of this consultancy, the CIR will provide the consulting person or team with the following inputs:
- Documents from secondary sources to support the analysis of the socio-economic and political context. These documents will not be the only sources, the consulting person or team must complement with additional sources.
- Historical databases of clients served through the CIR project portfolio.
- Document with the variables of analysis of interest of each of the programmatic areas of CIR Venezuela.
PERIOD OF PERIOD.
The consulting period is 45 calendar days, from the signing of the contract. The deliverable products are prepared by the consulting team according to the deadlines and development of the process, each deliverable is subject to changes and approvals by the CIR team.
How to apply
Applications will be received by mail: calls.Irc@rescue.org until February 4, 2024 at 11:59:00 p.m. In the case indicate: MEAL Consulting
Include in the mail:
- Leaves of life of the person or people who will make up the consulting team.
- Documents or training resources made, as an example of the experience you have and that demonstrate the minimum required skills (consolidated in a single PDF file).
- Economic expectation for the execution of the consultancy.