Jobs at Education Development Center

• The Database Officer will assist in the design and development of a data collection and management system for the project team. S/he will manage and troubleshoot the Monitoring & Evaluation database and be responsible for generating project reports, as well as supervising periodic data quality audits. S/he will be responsible for development of appropriate dashboards, as required. The Database Officer will take the lead in the development of tools for collecting, assuring quality, entering, storing, retrieving and organizing project data.
• S/he will also support the MEL Specialist and collaborate with the MEL Manager and Dashboard Specialist in the development of training and providing support for data collection, analysis, dissemination, and use at all levels of service delivery.  This position reports to the MEL Specialist. This is a full-time position based in Nairobi.

The Database Officer’s responsibilities will include, but are not limited to:

• Develops standard operating procedures and systems for data collection, storage and analysis of data;
• Designs and manages upkeep of project database, including regular data security and quality assurance activities, such as storage and backups, testing of data integrity, periodic recovery testing, and logical consistency checks;
• Analyzes data for dashboards, reports and presentations;
• Troubleshoots issues with participants’ use of paper forms and tablets for data entry into Performance Tracking System and provides technical assistance, as needed;
• Builds the capacity of project staff on basic and advanced data management skills, data processing protocols and assisting with statistical analysis;
• Develops and enforces project-wide data processing protocols, including manuals and reference guides, for proper use of the project database and related functions;
• Assists in planning and implementing data reconstruction exercises;
• Supervises the implementation of routine data quality audits;
• Provides technical guidance to other staff in data management;
• Maintains updated data collection and reporting tools;
• Works with project staff to find and implement technological solutions to data-related challenges;
• Produces regular reports according to the guidelines determined by project management;
• Works with project team members and partners throughout the country to ensure the database functionality meets their needs;
• Supports the development and conduct of presentations related to data and dashboards as needed;

Other duties, as assigned.

Qualifications

The candidate for the position of Database Officer shall have at a minimum the following qualifications:

Education:

• Bachelor’s degree in computer science or other related degree required.

Skills and Experience:

• 5 to 6 years experience developing, managing and troubleshooting M&E databases required;
• Minimum 3 to 5 years’ experience working with international NGOs, preferably in the education sector; experience with USAID-funded projects desirable;
• Experience with data collection software such as SurveyToGo and KoBo Toolbox, including programming software onto tablets for data collection purposes; 
• Experience in training and mentoring others in electronic data collection, especially using tablets, preferred;
• Experience conducting statistical analysis of data and proficiency in Microsoft Office suite;
• Strong organizational, communication, computer, and interpersonal skills; 
• Experience creating data visualizations, including charts, graphs, and maps;
• Demonstrated ability to work independently with minimal supervision, as well as within a team setting;
• Must be able to negotiate diplomatically and function well under pressure and meet strict deadlines.

Candidates must also demonstrate knowledge of the following computer languages and systems.

• Excel – ability to use advanced formulas, functions, and calculations to analyze data. Create and update database through connected worksheets. Should be able to clean, transform, and relate data from multiple sources.
• Excel + Power Query – ability to create Excel connected to SQL database report templates. Should be capable of using Power Query to clean, merge, pivot/un-pivot, and transform data.
• Structured Query Language (SQL) – Understands T-SQL to build complex queries and sub-queries as well as how to filter, group, join, and sort the results. Uses SQL Server Management Studio (SSMS) and other query tools to connect, query, and manage databases. Familiar with SQL database structures (not Access), can build SQL queries using SELECT statements from one or many different related tables to output data from SQL databases. Understands database fields and properties, database relationships, primary and foreign keys, can read a database ER Diagram.
• SQL Databases – Can create relational database structures, tables, fields and properties, primary and foreign keys, and indexes. Creates complex SQL queries, Store Procedures, and Functions. Preferable experience in Microsoft SQL Server databases. Imports and Exports data to and from databases or different sources in multiple formats. Can backup or restore databases between work environments.
• Power BI – Ability to create basic Power BI dashboards and data visualizations connecting to external data sources like Excel to analyze data. Understands the different types of Charts, Graphs, and tables to visualize data. Creates filters, measures, and columns using DAX formulas. Can publish, update, and share dashboards and reports

Language:

• Fluency in English is required.

Other:

• Applicants must be Kenyan nationals or hold current work authorization.

go to method of application »

• The KPLP Monitoring, Evaluation, and Learning (MEL) Manager will work closely with the MEL Specialist to develop and deploy a program monitoring system. Additionally, they will collaborate with technical staff and the MEL Assistants at the regional level to collect monitoring data. They will support the work of the MEL Specialist and will support the preparation of quarterly and annual reports, as well as the development and preparation of evaluations and learning activities. This position will report to the MEL Specialist, and will be based in Nairobi, Kenya.

The MEL Manager responsibilities will include, but are not limited to:

• Support the design of the monitoring and evaluation tools and instruments;
• Assist in the development of the evaluation design, tools, protocols and procedures;
• Participate in monitoring and evaluation data collection activities, including logistics of form distribution and collection;
• Oversee data processing, including data transfer, entry, verification and cleaning;
• Ensure forms are filed according to compliance protocols;
• Oversee and provide support to MEL activities of subpartners and grantees;
• Build the MEL capacity of subpartners and grantees, if needed;
• Train data collection and other MEL staff as needed;
• Support disaggregation of data as required for programme indicators. Ensure that all data is disaggregated by gender and other required disaggregation where appropriate.
• Conduct data quality assurance checks;
• Oversee MEL database setup and management;
• Conduct qualitative and quantitative data analyses;
• Generate data reports in compliance with USAID procedures and agreements in the award;
• Participate in preparation of evaluation reports;
• Contribute to and lead when requested in the development of the quarterly, annual and other technical reports as required and in alignment with USAID requirements.
• Ensure effective communication and collaboration between M&E team, GoK counterparts, project staff, partner teams and home office;
• Prepare communications for stakeholders based on M&E data;
• Mentor and build the capacity of junior M&E staff;
• Provide other management and support as needed.

Qualifications

The candidate for the position of MEL Manager shall have at a minimum the following qualifications:

Education:

• Master’s degree in statistics, monitoring and evaluation, social sciences, or a related field.

Skills and Experience:

• 7 to 8 years of progressively responsible and directly relevant experience in supporting MEL in developing countries, especially aspects of performance management and reporting.
• Experience in successfully supporting the MEL of large-scale national reading programs in a developing country, preferably in Kenya or East Africa, is highly desired.
• Proficient in data management and reporting systems.
• Experience in designing and maintaining databases ensuring data quality and integrity.
• Demonstrated exemplary technical, communication, and interpersonal skills to ensure internal coherence among diverse team members.
• Ability to write, communicate, and prepare reports clearly in English.
• Excellent verbal and writing skills in Kiswahili.

Language:

• Fluency in oral and written English and Kiswahili is required.

Other:

• Applicants must be Kenyan nationals or hold current work authorization.