Job Purpose

The Programmer manages and maintains a comprehensive USAID Jamii Tekelezi Program (UJTP) database, leads programming of scripts for all new clinical reports requested by program team, creates and maintains data validation rules, queries/scripts bank. Serves as the primary point of contact for all IT programming-related inquiries and troubleshooting in the program. This position reports to MEL Manager/Director.

Key Responsibilities and Duties

• Analyses/designs system flows and develops/codes program specification to ensure the agreed upon requirements are met.
• Writes, tests, and implements efficient computer programs. Codes straight-forward to moderately complex programs and ensures that the programs conform to CHAK standards.
• Resolves problems that arise with existing data systems to ensure the efficiency and proper functioning of programs and systems. Manage bugs on designated platforms. The programmer will track, document, evaluate and remedy all issues.
• Perform moderately complex data analyses using systems such as R, SSRS and SQL to interpret program and/or research data, present findings and prepare data for use in various capacities including but not limited to program and research and grant writing.
• Deploy, maintain, and administer the DHIS2 implementations including assigning rights users, maintaining backups and functionality of the systems.
• Based on agreed specifications, design, develop and maintain the DHIS2 data entry modules reports, dashboards and visualizations.
• Create and maintain data validation rules, queries/scripts and other data quality checks to improve data quality .
• Programming of scripts for all new clinical reports requested by the Clinical lead team and local partners.
• Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata).
• Serves as the primary point of contact for all IT programming-related inquiries and troubleshooting.

Requirements

Certification/Skills: Knowledge of computer hardware, software, and programming.

Preferred:

• Experience with SQL statistical analysis programs such as SAS, R or STATA
• Any programming language PL/SQL, python is a plus.
• Skills in the use of web analytics tools (Google Analytics, Web trends, etc.) is highly desirable.
• Familiarity with relational databases (schemas, design) and XML is a highly desirable.

Minimum Education: Bachelor’s degree in computer science, Software Engineering or related field or relevant experience in lieu of education

Minimum Experience:

• At least two years demonstrated experience including developing and designing data sets, indicators, data elements and designing custom data entry screens for DHIS2.
• Experience in developing health information systems, databases, and reports.
• An understanding of popular tools currently in the health sector such as ODK, REDcap, KenyaEMR, an advantage.