Chemonics International seeks experienced professionals for the USAID Global Health Supply Chain Program - Procurement and Supply Management (GHSC-PSM) project. GHSC-PSM in Ethiopia will serve as vehicle through which USAID will procure and furnish health commodities, provide technical assistance to improve the country’s management of health supply chain and pharmacy service activities, and collaborate with key international stakeholders to support global and local health initiatives.

The Short-term Senior Database Administrator is responsible for the implementation of M&E and Knowledge Management systems with the aim of ensuring complete data availability and improvements in supply chain performance

 Level of Effort and Location

This short-term position will be based in Addis Ababa, Ethiopia, with intermittent travel throughout the program’s target regions as needed.

Supervision

The USAID GHSC-PSM short-term Senior Database Administrator will report directly to the M&E Manager.

Annex 1 – Scope of Work (SOW) Short-term Senior Database Administrator

The Global Health Supply Chain – Procurement and Supply Management Ethiopia

Background

The purpose of the Global Health Supply Chain– Procurement and Supply Management (GHSC-PSM) Ethiopia Program is to ensure uninterrupted supplies of health commodities in support of United States Government (USG)-funded public health initiatives in Ethiopia. The project provides direct procurement and supply chain management support to the President’s Emergency Plan for AIDS Relief (PEPFAR), President’s Malaria Initiative (PMI), Population and Reproductive Health, and the USAID Office of Maternal and Child Health and Nutrition. In supporting USG-funded global health activities, GHSC-PSM will develop and manage a wide array of services for health commodity procurement and related systems strengthening technical assistance encompassing different elements of a comprehensive supply chain management initiatives in collaboration with Ministry of Health (MOH), Ethiopian Pharmaceuticals Supply Service (EPSS) and other partner organizations.

GHSC-PSM Ethiopia supports country strategies and priorities that fall under the following three project objectives:

• Health commodity procurement and logistics,

• Systems strengthening technical assistance, and

Global and local collaboration to improve long-term availability of health commodities.

Purpose

The Senior Database Administrator will report directly to the GHSC-PSM Ethiopia’s Monitoring and Evaluation (M&E) Manager and is responsible for the implementation of M&E and Knowledge Management systems with the aim of ensuring complete data availability and improvements in supply chain performance.

Principal Duties and Responsibilities

Strengthen Monitoring and Evaluation (M&E) and Knowledge Management Systems (50%)

• Manage and maintain the project database centrally.

• Undertake routine follow-up, provide remote technical assistance for GSHC-PSM field teams and technical staff on the data entry and data quality.

• Monitor the dynamic data analysis and visualization with Power BI and provide technical support and training to staff and partners.

• Regular communication with the field team and technical staff on the progress of data entry process.

• Provide orientation to GHSC-PSM staff on the usage of the project databases.

• Assist teams in the preparation for and production of graphs, maps, and other data visualization tools.

• In collaboration with M&E team members and other technical staff, conduct requirement analysis.

• Design and build a robust internal database as appropriate. Monitor and tune database performance.

• Work closely with Ethiopian Pharmaceuticals Supply Services, Ministry of Health, and partners to link data from health commodity management information system and health management information system.

• Provide orientation and build capacity of teams on data management.

Data Management and Reporting (50%)

• Manage the project databases such as internal M&E database, supportive supervision database and route optimization tool.

•      Clearly replicate M&E and Knowledge Management indicator tables into the Database system to easily append data into the system.

• Timely upload data to GHSC-PSM databases, store indicator data as per data management guide.

• Work with teams to collect, clean, aggregate, analyze and report survey data using web- based data collection tools (Such as SurveyCTO, ODK, SurveyMonkey).

• Link data from different sources of the supply chain to create a relationship within indicators.

• Monitor accuracy of data collected and ensure data quality by performing data validation.

• Perform database maintenance and administer access and security.

• Implement backup and recovery plan and procedure.

Job Requirements

• MSc or BSc. degree in Health Informatics, statistics, IT, computer science, software engineering or related fields with five and more years of experience in the specified area.

• Strong experience in database design and development.

• Advanced skills and experience in web-based application development with a focus on JavaScript, Python, JSON, PHP, Laravel, MySQL, MS SQL Server (2008,2012, 2014 or 2016) and RESTful services.

• Ability to design and develop using Object Oriented design principles, relational database systems and software design patterns to attain high reusability and maintainability.

• Excellent skill and knowledge in programing languages: PHP, and Python.

• Must have strong debugging and troubleshooting skills.

• Excellent skill in Power Query, DAX, and SQL languages.

• Skill in data analysis software such as Power BI, Python, Tableau, QGIS, and other data cleaning, visualization, and modelling tools (desirable).

• Skills on Survey CTO, ODK, Kobo or other data collection/management tools.

• Excellent skills on the usage of GPS/GIS equipment and data collection tools.

• Experience in use of office 365 tools (Outlook, Team, Excel, SharePoint, OneDrive, etc.)

• Ability to use graphic designing tools (Adobe illustrator, Photoshop, InDesign, and others) is an added advantage.

• Excellent interpersonal communication skills.

• Ability to work in a team setting.

• Ability to work under pressure.

• Fluent in English with excellent writing, analysis, and communication skills.

How to Apply

To apply, please reply to this e-mail PSMEthiopiaRecruit@ghsc-psm.org. Please specify the position title as the subject line in your application or your application will not be considered. Please submit no later than February 13, 2024. No telephone inquiries, please. Finalists will be contacted.

Chemonics is an equal opportunity employer and does not discriminate in its selection and employment practices on the basis of race, color, religion, sex, national origin, political affiliation, sexual orientation, gender identity, marital status, disability, genetic information, age, membership in