MIS Advisor

Overview

Jhpiego is a global non-profit health organization affiliated with The Johns Hopkins University. For more than five decades, and across more than 155 countries, the organization has supported efforts to prevent avoidable deaths among women and their families. Its technical assistance spans HIV/AIDS, maternal and newborn health, family planning, health workforce strengthening, cervical cancer prevention, malaria, and infection prevention and control / water, sanitation and hygiene. In Eswatini, Jhpiego is delivering the Reaching Impact Saturation and Epidemic Control (RISE) project, a U.S. Government-funded initiative designed to save lives and improve health through integrated, evidence-based interventions. The project supports all levels of the health system to strengthen HIV/TB epidemic response, reduce the spread of outbreaks through Global Health Security programming, and lower preventable illness and death through integrated maternal, newborn, and child health, nutrition, tuberculosis, and malaria services. Since 2019, RISE has been active in more than 25 countries across Africa, Asia, and Latin America.

Role summary

The MIS Advisor will lead the technical side of data movement and warehousing for the RISE Eswatini project. Reporting to the Senior Advisor, this position is responsible for moving data from source systems into analytical environments, including ETL workflows, database administration, and API-based integrations. The role ensures that data remains secure, reliable, and available on time for analytics, business intelligence, and evidence-based HIV epidemic control work.

Key responsibilities

The role covers end-to-end support for data engineering, database operations, integration, monitoring, and team collaboration.

• Design, implement, schedule, and track ETL processes that pull data from multiple inputs such as the National Data Store, mobile applications, cloud APIs, and operational databases.
• Clean, reshape, and transform raw data so it is ready for analysis and reporting.
• Improve ETL efficiency and investigate and resolve failed pipeline executions.
• Administer analytics databases such as PostgreSQL, SQL Server, and MySQL.
• Manage backup routines, recovery steps, and access permissions to protect project data.
• Watch database performance, improve query efficiency, and keep storage usage under control.
• Apply data retention and archiving practices.
• Create and maintain automated data flows using orchestration platforms such as Airflow, dbt, Prefect, or custom scripts.
• Develop and support API connections with external platforms, including SaaS tools, government systems, and partner databases.
• Set up authentication, handle rate limits, and build error handling and retry mechanisms for API work.
• Document pipeline dependencies, schedules, and recovery procedures for outages or failures.
• Put monitoring and alerting in place for failed runs, stale data, and schema changes.
• Maintain logs of pipeline runs, including success and failure rates as well as execution times.
• Take part in an on-call arrangement for after-hours pipeline issues, if needed.
• Coordinate with the MIS Officer so transformed data aligns with dashboard needs.
• Work with the Senior M&E Advisor to add data quality checks at the entry stage of pipelines.
• Support disaster recovery planning and IT security measures with the IT Office so data protection requirements are met.
• Provide technical assistance to the MOH SID, working with Data.Fi, on DHIS2 facility dashboard optimization, national SQL scripts for standard datasets, data mining from national EMRs, and warehousing support for M&E unit analytics.
• Advise regional teams on data management, digital tools, and troubleshooting for field-level issues.
• Review new information technologies and determine how they can improve efficiency and support Jhpiego’s digital health direction.
• Mentor the MIS Officer to strengthen technical skills and ensure high-quality delivery of MIS responsibilities.

Qualifications and experience

A suitable candidate should hold a bachelor’s or master’s degree in Computer Science, Information Systems, Software Engineering, or have equivalent practical experience. The role calls for at least 6 years of work experience in data engineering, ETL development, database administration, or a closely related field. Strong command of SQL is essential, including complex joins, window functions, and query tuning. Experience with ETL or orchestration tools such as SQL Server, SSIS, or custom Python-based ETL frameworks is required. The candidate should also be comfortable with analytical tools such as SSAS and Power BI Report Server, and must have solid experience integrating REST APIs, including authentication, pagination, error handling, and similar mechanisms. Database administration skills should include backup management, user access control, and performance tuning. Applicants should also be able to convert complex programme requirements into practical MIS solutions, troubleshoot effectively, communicate clearly, and work well under pressure. Experience in USG-funded health programmes is considered an advantage.

Additional information

Jhpiego states that it offers competitive salaries and a comprehensive benefits package. Candidates must submit one combined document that includes a cover letter, resume, and references. Applications will be reviewed on a rolling basis, and the closing date is 9 July 2026. The selected candidate will be required to complete a pre-employment background check. Jhpiego is an affirmative action and equal opportunity employer, and it does not discriminate based on gender, marital status, pregnancy, race, color, ethnicity, national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other legally protected or irrelevant characteristic. The organization also encourages affirmative action for minorities, women, people with disabilities, and veterans. Jhpiego warns applicants to beware of recruitment scams: recruiters will never request payment at any stage, legitimate jobs are posted only on its careers page, official emails come from a @Jhpiego.org address, and suspicious messages should be reported to Info@jhpiego.org.