TERMS OF REFERENCE – TELEPHONE DATABASE DEVELOPMENT CONSULTANCY Posted on December 8, 2020 (February 17, 2021) by lillian osano CAREERS GET INVOLVED // CAREERS TERMS OF REFERENCE – TELEPHONE DATABASE DEVELOPMENT CONSULTANCY DEADLINE: December 23, 2020 CLOSED JOB SHARE THIS JOB: Background Information The African Population and Health Research Center (APHRC) operates from its head office in Nairobi, Kenya but coordinates all its work across all countries in sub-Saharan Africa. It also has an office in Senegal which oversees projects and activities in West Africa. The Center’s vision is to transform lives in Africa through research. Its mission is to generate evidence, strengthen research capacity and engage policy to inform action on population health and wellbeing APHRC’s vision, mandate and mission are premised on tracking the activities, outputs and outcomes of various research projects. As such, APHRC collects primary data from various research participants mainly through face to face (F2F) interviews. With new advancements in mobile technology, and rapidly increasing internet connectivity and mobile phone penetration in Africa, it is now possible to conduct some types of studies using telephone interviews, Short Message Services (SMS) or mobile web all of which require mobile phone numbers mounted on an electronic communication device and/or access to internet connectivity. In addition to technology advancement, pandemics such as COVID-19 dictate that researchers minimize F2F interviews, something that has become the new normal. This has awoken the need to establish a telephone number database at APHRC to support data collection for existing and future research projects APHRC seeks the services of a consultant to support and advise in the development and establishment of a telephone number database which will be a hub for data collection and information management of the organization What is a telephone database and what is its purpose? A telephone database consists of telephone numbers stored in an institutionally controlled device, e.g. a server, standalone computer or cloud solution. The phone numbers, ideally mobile phone numbers, are part of an individual’s contact information. The contact information includes other selected details of the individual. The database can be connected to a calling system for purposes of contacting the individual when needed. The purpose of a telephone database is to: To conduct non-face to face research, trainings, communications and policy engagement To conduct targeted marketing, and monitoring of research activities including implementation of interventions To provided sampling frames that will allow efficient samples to be drawn To reduce the time, it takes to collect primary data with large samples To enhance the cost-effectiveness of APHRC field activities Description of the tasks of the consultant APHRC seeks to engage a consultant (individuals, or firms/institutions) to support in the design of the telephone number database for the Center. Specific tasks for the consultant will be: To produce a conceptual phone number data model that reflects the structure of the information to be held in the database. The conceptual data model should involve guidelines for utility of phone numbers database, collecting of the phone numbers, tools for Monitoring and Evaluation of usage of the phone numbers, access rights, security of phone owners, consent for storage of phone numbers, etc. Share the conceptual data model with the Center task force for phone number database development for review and improvement if need be Translate the conceptual data model into a phone number database Design the phone number database in a way that will ensure that security features are included Pre-test the database for data analyses and produce reports for immediate use Train APHRC staff on phone number database use, upgrading, and maintenance activities Timeframe The duration for the entire task will be 30 working days Deliverables Presentation of Conceptual model design Physical database design Presentation of model database to APHRC Pre-test run of database Presentation of final functional database to the task force Training of Staff on database utilization and management Roll out of the database Expertise and Experience The consultant should have the following expertise: A minimum of 5 years of experience in database design and roll out for health development projects Proven experience to lead in the structural design of a database according to various system requirements Education in Computer Science especially SQL server database development Experienced in SQL query design, execution and optimization Knowledge on reporting and charting, and data visualization frameworks Analytical and Documentation skills, presentation of reports Excellent command of English Proposal Submission Requirements Interested consultants (individuals/firms/institutions) to submit a proposal with 1) Cover letter explaining their eligibility for the assignment and interpretation of the tasks; 2) CV or profile including reverse chronological list of similar projects/assignments and contact details (name, email/phone) of supervisors/clients; and 3) and financial proposition with the expected remuneration to firstname.lastname@example.org copying email@example.com. The deadline for submission of proposals is December 23rd, 2020. APHRC is an equal opportunity employer and is committed to the protection of vulnerable persons.