General functions:

1. Directly support the Database Expert in enhancing data management systems across the mission:

• to design and code XLSForm standards (ODKForm) surveys, contributing to data visualization through Power BI dashboards.
• to support the development of Excel-based project management and activity tracking tools.
• to assist in database creation for improved tracking of project implementation, beneficiary reach, PDM results, and FCRM feedback.
• to play a key role in training MEAL and project teams in ODK coding, Excel, Power Bi, Data protection and overall information management best practices.

1. Ensure compliance with procedures linked to proper data management by the MEAL and programme teams:

• Support each programme in creating tailored tools for the collection, processing, analysis, visualization and archiving of data.
• Support the centralization and harmonization of tools and data specific to each programme and MEAL.
• In collaboration with the Database Expert, help to ensure the quality and relevance of the monitoring tools, data processing and analyses produced by the team (questionnaires, databases, maps, etc.).
• Provide technical support and trainings of staff on data management tools and ensure their proper use by MEAL and programme teams.
• Ensure the quality of data collected in the field.
• Produce visuals following data processing, in support of MEAL and programme teams.

Key Functions:

Survey Design and Data Collection

• Design and code digital survey forms using XLSForm standards (ODKForm).
• Support CommCare app development and form customization.
• Provide quality assurance on form logic, constraints, and translations.

Data Management and Analysis

• Assist in creating and managing project-specific databases to support data cleaning, management, and analysis.
• Provide support on Red Rose platform where applicable.
• Contribute to improving existing Excel trackers (formulas, data validation, structure optimization).

Data Visualization

• Support the design and automation of dashboards in Power BI & Excel for (among others):
• MEAL Post-Distribution Monitoring (PDM) data;
• Beneficiary reach visualizations;
• Feedback and Complaint Response Mechanism (FCRM) trends;
• Project monitoring and indicator tracking;

Capacity Building and Technical Support

• Contribute to the development of a training plan & training materials for MEAL and programme teams in:

• XLS-ODK coding;

• Excel-based data tools;

• Basic Power BI usage;

• CommCare launch and use;

• Data protection;

• Any other relevant topics based on data management capacity building plan;

• Deliver trainings and provide one-on-one coaching where needed.

• Support in transferring this knowledge to WHH partners through sustainable training materials & delivery.

• Ensure the security of digital data relating to all MEAL and programme activities.

  Innovation and System Development

• Support the Database Expert in developing integrated, user-friendly data systems across departments.

• Propose database solutions for tracking, reporting, and visualization needs.

• Where applicable, support exploration and integration of additional tools such as SQL databases, Python scripts, and GIS applications (e.g. ArcGIS, QGIS).

• Support Database Expert, MEAL and Programme team in strengthening WHH Learning and Capitalization systems.

• Perform any other related activities as assigned by immediate supervisor.

• Promote safety awareness and environmental consciousness and comply with all applicable safety and environmental procedures and regulations.

• Promote and take an active part in quality improvement processes.

• Comply with labor discipline, labor protection and safety rules, fire-prevention requirements, industrial sanitation and labor hygiene rules, Safety, and Environmental regulations and guidelines.

Specific Knowledge:

• Proficient in XLS form design and logic.
• Experience using CommCare: app development, form design.
• Excellent knowledge of Excel, Power Query, and Power BI.
• Familiarity with Red Rose platform.
• Intermediate to fluent level of verbal and written English
• Strong training and facilitation skills.
• Knowledge of SQL, R, Python or any BI system (Zoho, Tableau, Qlik) is an asset.
• Knowledge of labor discipline, labor protection and safety rules, fire-prevention requirements, industrial sanitation and labor hygiene rules.