CALL FOR DATABASE SPECIALIST

• Background of the Organization

CARE  is  an international humanitarian and development organization without  religious,  political  or government affiliation. CARE is committed to protecting and promoting the rights of vulnerable girls and boys, women and men and improving the lives of refugees and host communities alike.

CARE works at national, municipality and at the community level to develop customized solutions and ensure long-term sustainability as well as respond to basic needs. We design projects that fall into alignment with national priorities and be owned by communities. Our interventions range across clean water, affordable sanitation and community healthcare and sexual and reproductive health rights programs, economic opportunities, and protection.  Across program areas, CARE’s activities are guided by a rights-based, holistic, gender-sensitive/transformative, and inclusive approach.

CARE International has been operational in Lebanon since 2013 and works across the country.

• Terms of Reference

CARE International in Lebanon is seeking a senior-level database specialist (or consultancy firm) to design a programme database that manages beneficiary information and services, performs some data analysis, and create reports. It will include demographic information, project information, services received, scores on various tests, and other related information. The database is to be designed based on a discussion with the CARE Project Manager and MEAL team, along with a 2-3 hour brainstorming workshop will all CARE programme team (10-12 individuals). This workshop will be led by the consultant who will also be responsible for training relevant members of CARE’s team (10-12 indviduals) on how to manage and update the database. Developed material will be the property of CARE International in Lebanon.
 

• Database functions and specifications

• Import data in xls format and from online servers of beneficiary lists
• Provides layouts/formatting enabling English-only speakers to use the database for review and analysis purposes
• Employs unique identifiers per individual clients/beneficiaries
• Multi-level password protection to assure anonymity of PLHIV clients and confidential information
• Data validation
• User-friendly format (drop down lists, checkboxes, auto populating fields…)
• Data exportable to other software such as Excel
• Usable offline

Other functions may be identified as part of the conceptualization and consultation process.

• Deliverables

• Study sources of information, tracking tools, and individual program information needs 
• One 2-3 hour brainstorming session with CARE programme team
• One database designed and ready to use
• Develop, test and validate a database system that will act as an online internal reporting system
• Two training sessions (4 hours each) on how to use, manage and update the database

• Qualifications

• Extensive professional experience in database design for international NGO and/or private sector with at least 5 successful, complex databases designed and in current utilization by current or former clients
• Strong skills in database systems (PostgreSQL, SQL server, MySQL) as well in designing and using FileMaker Developer- certified (or equivalent in on job experience) in Microsoft Access 2010 (and/or other proposed software)
• Basic understanding of data security and encryption tools
• Experience producing user guideline manuals and training staff in the use of databases
• Able to design extremely user friendly databases that can be used by individuals with only basic computer literacy

• Timeframe

The total process should take 5-6 weeks.