Education Development Center Database Officer – Kenya Primary Literacy Programme Jobs in Kenya
Project Description
The Kenya Primary Literacy Programme (KPLP) is a five-year initiative that supports the Kenyan Ministry of Education to deliver interventions at scale as well as pilot and expand innovations that address the language and literacy needs of primary grade learners while building more inclusive, accountable, and resilient education institutions and systems.
KPLP has three broad objectives:
Improving education services and student learning outcomes, including for vulnerable populations;
Strengthening education institutions and systems to become more accountable, self-sustaining, and resilient; and
Empowering local youth organizations to strengthen and sustain community and family support for student learning and wellbeing.
Position Description
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;
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
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;
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.
How to Apply
For more information and job application details, see; Education Development Center Database Officer – Kenya Primary Literacy Programme Jobs in Kenya
Find jobs in Kenya. Jobs – Kenya jobs. Search our career portal & find the latest Kenyan job positions, career opportunities & jobs in Kenya.
Jobs in Kenya – banking jobs, IT jobs, accounting jobs, NGO jobs, business administration, ICT, UN jobs, procurement jobs, education jobs, hospital jobs, human resources jobs, engineering, teaching jobs, and other careers in Kenya.
Find your dream job from 1000s of vacancies in Kenya posted and updated daily – click here!
