Chemonics International seeks experienced professionals for the USAID-funded Global Health Supply Chain - Procurement and Supply Management (GHSC-PSM) project. GHSC-PSM Ethiopia will serve as the primary vehicle through which USAID will procure and furnish health commodities, provide technical assistance to improve the country’s management of the supply chain, and collaborate with key international stakeholders to support global and local health initiatives.
The Short-term Database Administrator will be 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.
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 short-term 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.
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.
Develop and maintain scalable data models to handle large, complex data sets effectively.
Create interactive and visually appealing reports and dashboards using Microsoft Power BI, leveraging best practices in data modeling, DAX, and visualization
Develop and maintain ETL processes to extract data from various sources, transform, and load into Microsoft PowerBI.
Regular communication with the field team and technical staff on the progress of data entry and verification 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.
Collaborate with M&E team members to conduct requirement analysis and integrate survey data into data analysis and reporting workflows.
Design and build a robust internal database as appropriate. Manage and maintain database systems, including backups, recovery, performance tuning, and security.
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 andsupportive supervision database.
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.
Implement comprehensive data validation and testing procedures to ensure data quality and integrity.
Ensure data integrity, consistency, and security through appropriate access controls and data governance practices.
Perform advanced data analysis using SQL for extraction and transformation, as well as to optimize database performance and identify and resolve bottlenecks.
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.
Annex 1 – Scope of Work (SOW)
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.
Expertise in database design and development, ensuring efficient and scalable data management.
Experience working with database technologies such as MySQL, MS SQL Server (2014, 2016, 2017, 2019, or 2022).
Proven expertise in Microsoft Power BI, including data modeling, DAX, and visualization techniques.
Extensive experience in implementing data validation and testing procedures to ensure data quality and integrity.
Familiarity with survey design, programming, and testingbest practicesusing platformslike SurveyCTO, Kobo, ODK, and CommCare.
Strong understanding of ETL processes and the ability to integrate survey data collection tools with data visualization platforms.
Proficient in SQL for data extraction, transformation, and optimization of database performance.
Solid experience in developing and maintaining robust data models that can handle large, complex data sets.
Expertise in the usage of GIS equipment and data collection tools for seamless data integration.
Strong understanding of data architecture, and databases concepts.
Excellent skills in web programming languages, including PHP, javaScript and Laravel.
Proficiency in using Microsoft Office 365 tools (Outlook, Teams, Excel, SharePoint, OneDrive).
Familiarity with graphic design tools (Adobe Illustrator, Photoshop, InDesign) to enhance data visualization.
Excellent problem-solving and critical thinking abilities
Excellent interpersonal communication skills, with the ability to work effectively in a team setting.
Fluency in English with strong written and verbal communication skills
Ability to work under pressure and meet deadlines.
How to Apply
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 an employee organization, or other non-merit.
