Job Title: Data Analyst and Learning Officer- DRIP FUNDI

The Millennium Water Alliance (MWA) www.mwawater.orgis a permanent global alliance of leading humanitarian, research, and business organizations that convene a trusted network and serve as a hub for collective impact, accelerate learning, and influence priorities and funding to scale sustained WASH services and resilience globally. MWA and its members collectively serve over 50 million people in over 100 countries and are leading advocates for greater water and sanitation commitments by governments and the private sector.

Program description

MWA is seeking an experienced Data Analyst and Learning Officer to support the USAID funded DRIP FUNDI (Fixing Uptime Now and Decision Improvement) program in Kenya. The program, which is set to be implemented in the five counties of Marsabit, Garissa, Wajir, Isiolo and Turkana seeks to increase the borehole uptime across 200 boreholes in the five counties. The underpinning goal of the program is to address the challenge of borehole non-functionality that is prevalent in the Arid and Semi-Arid Lands (ASALs) of northern Kenya and rural areas of Kenya at large. Non-functional water systems make it particularly difficult for communities to cope with the recurrent droughts that the region experiences. The program will partner with respective county government borehole repair teams and private sector partners to facilitate the rapid repair of the boreholes. Further, it will also engage selected private sector partners for the provision of the spare parts required for borehole repair. Finally, the program aims to set up a carbon financing system to support the continued repair of the 200 boreholes beyond the program’s life.

Job Summary

The Data Analyst and Learning Officer will oversee a system for collecting, analyzing, and managing DRIP FUNDI data within the program’s life (18 months). The Officer will work closely with Virridy to disseminate information to the relevant stakeholders including Borehole Rapid and Response Teams (BRRTs) and Private sector partners. The position holder will also be tasked with simplifying complex information for users, documenting lessons learned and managing the program M&E system. The Officer will report to the Monitoring, Evaluation, Reporting and Learning Manager and will work closely with the Program Manager – DRIP FUNDI. The position will be based in Nairobi, Kenya with frequent travel to program sites.

Roles and Key Responsibilities

The Data Analyst and Learning Officer will provide the planning, decision making and implementation of the following functions:

• Establish processes and methods through which data is regularly accessed and analyzed for rapid decision-making on borehole repairs.
• Prepare a data analysis plan in collaboration with the program team.
• Carry out data cleaning including but not limited to merging data whenever necessary.
• Work with Virridy and the program team in data extraction, analysis, and interpretation from Virridy dashboard for use by program teams, private sector, and borehole rapid response teams.
• Support the development and set up of data quality assurance processes, testing and rollout.
• Management of data reporting cycle by generating internal data reporting calendar, data collection process, data analysis and data sharing/dissemination.
• Managing the M&E system includes completing the indicator reference sheet, updating of the log frame against the indicator targets and capacity building of staff on the system.
• Produce regular quality assurance reports for identification of gaps.
• Support in developing training material and delivering training for county staff assigned to the program on data and analytics and other related topics.
• Create visualizations and automated reports to measure, monitor and report on key metrics.
• Help to identify, analyze, and synthesize lessons learned from program implementation and facilitate the incorporation of those lessons into the activity development cycle.
• Identify learning and data collection for the purpose of producing learning products such as articles, research papers and other products.
• Organize learning sessions for internal and external audiences by organizing reflection meetings, webinars, and dissemination workshops.
• Attending relevant internal/external meetings where required.
• Any other duties assigned.

Qualifications

• A minimum of a Bachelors degree in Statistics, Computer science, Public Health, Social sciences, or any other equivalent and relevant qualification from a recognized institution.
• A minimum of five (5) years’ experience in data analysis and database management functions in private or development sector settings; at least 2-3 years of field/in-country experience in any Monitoring, Evaluation and Learning function.
• Experience in quantitative and/or qualitative analysis for evaluations is desirable.
• Knowledge/experience in at least two databases and/or analysis tools (Advanced Excel, R, STATA etc.)
• Experience with data visualization is desirable.
• Experience or knowledge of water supply systems in ASALs will be an added advantage.
• Knowledge of carbon markets and the requisite certifications will be an added advantage.

Knowledge, Skills, and Abilities

• Ability to listen, communicate and work in a team.
• Ability to work independently and be self-motivated.
• Attention to detail is a must.
• Strong and concise report-writing skills are required.
• Solid understanding of Microsoft 365.
• Strong analytical skills: ability to create simple to complex analytical solutions.
• Ability to adjust to changing work environments, priorities, and goals.
• Fast learner: We are looking for someone who thrives on learning new technologies.