Informatics / Geospatial / Data Management Officer

The Elizabeth Glaser Paediatric AIDS Foundation (EGPAF) is a recognized global leader in the fight against HIV/AIDS.  In its work to eliminate paediatric AIDS through research, advocacy, and prevention and treatment programs, EGPAF currently supports national, district, and local governments, facilities, communities, and non-governmental partners. In 2020, EGPAF’s global footprint spans 17 countries.  EGPAF supports service provision for comprehensive HIV care, treatment and prevention programs, and health systems strengthening. To date, EGPAF has supported over 15,000 sites to offer HIV counselling, prevention, diagnosis, and treatment services alongside high-quality family health care.

EGPAF has worked in Malawi since 2001. Today, EGPAF Malawi implements evidence?based HIV prevention, care and treatment interventions in 151 health facilities in nine districts through EGPAF’s U.S. President’s Emergency Plan for AIDS Relief/U.S. Centers for Disease Control and Prevention (PEPFAR/CDC) ?funded Achieving HIV Epidemic Control through Scaling Up Quality Testing, Care and Treatment in Malawi.

EGPAF seeks to fill the following open positions:

Position                                  : Informatics/Geospatial/Data Management Officers (IDMO) (6)

Reports to                              : Informatics Geospatial Manager (IGM)

Location                                 : Lilongwe

Post type                                : National

Position Summary:

The Informatics/Geospatial/Data Management officer is a proactive and self-motivated individual who under the direct supervision and guidance of the 


 will assist in utilizing data to provide a wide variety of information and solutions for better understanding of program performance. He or she will also assist the IM in the development of functional databases and business intelligence solutions for the organization and supported institutions and lead data audits, data quality and analytics strategies across the organization. He/she will be responsible for the development and maintenance of functional databases with dashboards and GIS systems for the purposes of translating various EGPAF program M&E data/indicators into actionable decision-making practices. He/she will assist in building capacity of SI&E team on the informatics applications and geospatial analysis. He/she will aggregate, organize, manage and synthesize data on various programmatic areas, show trends of programming impact; identify anomalies, produce cutting-edge data visualizations to enhance data use.

Essential duties and responsibilities include, but are not limited to the following:

  • Databases and Business Intelligence
  • Assist the IGM in working with cross-functional teams to gather, document, and approve business requirements for data analysis and reporting projects. Translate these business requirements into specifications that will be used to drive data storage/ data warehouse/ data mart design and configuration.
  • Lead data quality audit and assist in the development of a data quality tool.
  • Use BI and database tools to develop reporting solutions to meet business needs for both external and internal users.
  • Assist in ensuring that the use of business intelligence applications enhances business decision making
  • Assist in creating and maintain data repositories, dashboards, and analytical solutions using software tools within our data environment.
  • Assist in the development of web and mobile applications using modern technologies
  • Assist in the implementation, management and support of mission-critical enterprise BI reporting and Extract, Transform, Load (ETL) processes.
  • Create and maintain databases, reports and queries using MS SQL, MySQL, SSAS, SSIS or other solutions as needed (knowledge of SQL and T-SQL is imperative and not an added advantage)
  • Work with IGL to develop Data Management SOPs for all data management processes.
  • Perform data quality assurance functions as related to reporting and data validation across different levels where electronic systems are used.

  • Other

    • Maintain a pulse and knowledge to new technology that may enhance organizational goals and performance.
    • Prepare monthly and quarterly reports and assist in the preparation of the annual work plans and reports.
    • Provide TA to facility, national and regional stakeholders on various data needs.
    • Perform other duties as assigned by the supervisor

Required Qualifications, Knowledge, skills and abilities

  • Degree in Information technology, Management Information Systems, Computer Science, Health Information Systems, Statistics, Mathematics, Demography or Social Science Degree.
  • Ability to work in a fast-paced environment under tight deadlines while producing quality content.
  • Working experience/Knowledge in the following is added advantage

    • Power BI (Data modelling in power BI, M Language)
    • Database development (Relational & Non-Relational)
    • Experience in geo-spatial analytic tools (Arc GIS, QGIS etc.)
    • MS Power tools (Power query, Power pivot, Power view)
    • MS Analysis services (Data model creation, DAX language, working with Tabular data models, Working with multi-dimensional data models)
    • Demonstrated experience in the use of Modern JavaScript Frameworks
  • Experience with meta-data standards and database best practices.
  • Dataset preparation, Data cleaning (using R, Python, SQL Scripts e.t.c)
  • Strong organizational, interpersonal, oral and written communication skills.
  • Strong analytical skills, data lover, ability to think big picture strategy and navigate details to ensure accuracy.
  • Experience working effectively in a multidisciplinary environment.
  • Experience building data products for DHIS2
  • Ability to work independently as well as within a team setting.
  • Highly organized, meticulous and reliable
  • Comfortable working independently and developing new procedures and systems
  • Good interpersonal skills

Elizabeth Glaser Pediatric AIDS Foundation is an equal opportunity employer. All qualified individuals are welcome to apply. Interested qualified candidates should send their expressions of interest enclosing copies of their certificates and a detailed current Curriculum Vitae including names and contacts of at least three traceable referees, and indicating their availability to take up the position.

Closing date: 30 November 2020

To apply for this job please visit


Partagez et envoyez cette annonce à vos amis !