Data Manager (Vulnerability Assessment Mapping) SC8 - Lebanon, Beirut Country Office

Accountabilities:

With delegated authority and under direct supervision of Head of Monitoring & Evaluation/ Vulnerability Analysis Mapping (M&E/VAM), the Data Manager (Vulnerability Assessment Mapping) will be responsible for the below:

Management of Beneficiary Data

1. Contribute to the development of local systems as needed to upscale the current database and facilitate the implementation of corporate vision to manage beneficiary lists
2. Follow and where applicable manage data gathering and management systems;
3. Ensure that rigorous quality standards are reviewed (and if necessary re-defined) and maintained for data collection and management information systems;
4. Prepare reports related to the beneficiary data, beneficiary targeting, beneficiary selection System and analyses the outputs using WFP corporate analysis and visualization tools;
5. Manage the inclusion and exclusions related to the targeting and validation exercises.
6. Work closely with all relevant units and various stakeholders on the management of accurate and consistent beneficiary information for the distribution and uploading of funds on the prepaid card for both the voucher and cash assistance;
7. Support the Field Offices in the management and enhancement of their beneficiary, VAM and M&E databases; and
8. Support M&E or VAM analysis activities using internal or external databases.

Creation and management of the monthly Beneficiary List

1. Enter and process all data provided by WFP’s partners, including UNHCR, for all registered refugees and vulnerable Lebanese into WFP’s beneficiary management system;
2. Monitor and follow up the activation/deactivation of cases on monthly basis with UNHCR and accordingly generate the needed reports.
3. Manage the monthly entries on the UNHCR Refugee Assistance Information System (RAIS) and the ability of conducting the needed checks prior to the selection of beneficiaries for the WFP assistance.
4. Manage the monthly enrollment of beneficiaries for different programmes on the WFP system (SCOPE).
5. Ensure data is entered into the beneficiary management system/database in a timely, accurate and efficient manner;
6. Work closely with WFP IT Unit to develop secure methods according to WFP' protocol for sending, receiving and storing beneficiary data;
7. Coordinate with WFP Field Offices, Accountability to the Affected Population (AAP) and Cash Based Transfers (CBT) teams and apply beneficiary data updates for all registered refugees after each additional list provided by UNHCR;
8. Import the monthly beneficiary list from other sources (e.g. Presidency of the Council of Ministers (PCM) for the vulnerable Lebanese, VARON);
9. Organize beneficiary data according to project and programme activities, geographic areas or partner operations, etc.;
10. Submit final beneficiary list to the Head of Programme and M&E/VAM and reports for each cycle which contains the beneficiaries (case numbers) that were selected to receive entitlements (transfer modality) and the reasons for inclusion/exclusion for each case;
11. Report data quality issues back to partners;
12. Ensure complete records of all relevant data are stored securely and with redundancy in case of unexpected loss or damage of the data; and
13. Performs other related duties as required.

Experience: At least four (4) years of progressively responsible work experience including at least two (2) years of experience in database management, statistics or other related field. Strong experience utilizing Database platforms such as MS Access or SQL Server, data visualization tools such as Tableau as well as ETL tools and data warehouse applications. Good experience utilizing statistical processing tools such as SPSS, “R” and/or STATA.

Knowledge and skills:

• Very good command of Microsoft Excel (pivot tables, macro functions, advanced functions…);
• Knowledge of SQL; MS SQL Server is a plus;
• Analytical, interpretation and system documentation skills
• Ability to analyze big data;
• Experience using data visualization tools. Knowledge of Tableau is a plus
• Ability to adapt to new requirements when needed
• Ability to adapt to various stakeholder’s requests
• Ability to demonstrate a client-oriented approach, high sense of responsibility, and courtesy
• Mature judgment with good communication and interpersonal skills