Database Specialist 67 views

Vacancy Announcement 

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 Database Specialist 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.

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 Agency (EPSA) 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 Database Specialist will report directly to the GHSC-PSM Ethiopia’s 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%)
• In collaboration with M&E team members and other technical staff, conduct requirement analysis.
• Design and build a robust internal database. Monitor and tune database performance.
• Design and develop custom software to automate the current manual systems using the latest software development tools including ASP .Net, MVC core, Laravel, Node, React and angular.
• Undertake routine follow-up, provide remote technical assistance for GSHC-PSM field teams and technical staff on the data entry and data quality.
• 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.
• Manage and maintain database centrally.
• Assist teams in the preparation for and production of attractive graphs, maps, and other data visualization tools.
• Work closely with EPSA/ partners to link data from health commodity management information system (HCMIS) and related 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, mosquito bed net distribution tracking tool and supportive 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.
• Work with teams to collect, clean, aggregate, analyze and report survey data using web-based data collection tools (Such as SurveyCTO, power apps, 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.

Level of Effort and Location

This long-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 Database Specialist will report directly to the M&E Manager.

Qualifications:

• 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, JSON, PHP, React, Laravel, MySQL, MS SQL Server (2008,2012, 2014 or 2016) and RESTful services.
• Ability to design and develop using Object Oriented design principles and software design patterns to attain high reusability and maintainability.
• Excellent skill and knowledge in programing languages: Java, C#.net, VB.net, power query, DAX
• Skill in use of framework: MVC, Spring, Maven, Laravel or others
• Must have strong debugging and troubleshooting skills.
• Skills on SurveyCTO, ODK, Kobo or other data collection/management tools
• Excellent skills on the usage of GPS/ GIS equipment and data collection tools
• Skill in data analysis software’s like SPSS, PowerBI or other data visualization and modelling tools (desirable)
• Excellent skill in the use of Excel spreadsheet and populate tables, charts
• Experience in use of office 365 tools (Outlook, Team, Excel, SharePoint etc.)
• Experience in Azure Development environment (Microsoft Azure integrated visual studio IDE).
• Graphic design skill and ability to use graphic designing tools (Adobe illustrator, Photoshop, InDesign and others).
• 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.