Shelter/wash Database Consultant

1.         BACKGROUND NRC has been present in Lebanon since 2006 initially assisting Lebanese displaced persons and later Palestinian, Iraqi and Syrian refugees.  The programme started with Education and Shelter interventions and, since March 2012, NRC has also been conducting Information, Counselling and Legal Assistance (ICLA) and Community Capacity Building (CCB) activities with Palestinian refugees and, more recently, with Syrian refugees. In 2014, NRC launched its WASH programme in three of its five geographic areas of intervention (Akkar, Tripoli, Tyr, Bekaa and Mount Lebanon). In 2014, the Shelter programme created a bespoke Excel database using Microsoft OneDrive to store beneficiary and project information in a secure manner, which allowed for simultaneous editing across the four NRC field offices. Recently, the WASH outputs were integrated into the Shelter database and the Excel sheets have been migrated to Google Docs. As a result of this integration, extensive work is required to create and/or update the summary dashboards, as well as the tabs used to migrate data to other internal and external reporting tools. While a more robust system is envisioned in the future, for the moment the Excel database is the default data storage, analysis, and reporting tool for the Shelter and WASH programmes. 2.         OBJECTIVES The main objectives for the consultancy: Create and/or revise the required dashboards and reporting tools in the three existing Excel databases; Create additional analytical tools; and Identify other potential database solutions for the Shelter/WASH database. 3.         PROGRESS PLAN Progress plan with milestones and delivery dates Delivery dates: Milestones: Week 1 Review the current bespoke databases and agree required work plan for each database with Shelter Specialist. Discuss with NRC focal point whether to update the Excel databases, or whether to purse another solution Week 2 Make changes to North database Week 3 Make changes to Bekaa database Week 4 Make changes to South database Week 4 Handover, training and debrief with Shelter Specialist 4.         ADDITIONAL INFORMATION Highly proficient with Microsoft Excel, including Excel statements, such as: SUMIFS, COUNTIFS, IF, VLOOKUP, pivot table, filters, data validation, graphs, etc. Highly proficient in designing database systems and data migration, including Microsoft Access, MySQL, etc.