Health Information Systems (HIS) Officer

Database Management:

Develop, maintain, and optimize secure databases to support PEPFAR-funded initiatives.

Ensure data quality, integrity, and accessibility by implementing robust database policies and standards.

Oversee database backups, recovery plans, and regular performance tuning.

Data Processing and Programming:

Design and develop custom scripts and applications using Python and Java to streamline data workflows.

Automate data extraction, transformation, and loading (ETL) processes to ensure efficient handling of large datasets.

Develop algorithms and tools for data validation and quality assurance.

Data Visualization and Reporting:

Create dynamic dashboards and reports in Power BI to provide actionable insights to stakeholders.

Utilize SQL and R for advanced data analysis, including statistical modelling, trend analysis, and forecasting.

Collaborate with the monitoring and evaluation (M&E) team to design reporting templates that align with PEPFAR indicators.

Technical Support and Capacity Building:

Provide technical guidance to program staff and partners on database use and data management best practices.

Conduct training sessions for end-users on tools like Power BI, R, and SQL to enhance data literacy within the organization.

Troubleshoot and resolve database or programming-related issues in a timely manner. Provide technical support for configuration, maintenance, implementation and expansion of systems

Collaboration and Compliance:

Work closely with the M&E team, program managers, and other stakeholders to identify and address data needs.

Review and approve Standard Operating Procedures related to the use, maintenance and security of all systems in the organization or that are requested to collaborate;

Ensure all data management practices comply with PEPFAR guidelines, ICAP standards, and Angolan government regulations.

Contribute to data-driven decision-making processes to enhance program performance and outcomes.

Bachelor’s degree in health informatics or related discipline (information technology, computer science, statistics, health informatics, public health, etc.)

At least 3 years experience related to design and implementation of high-quality SI systems for HIV/AIDS and/or health programs in low-resource settings

Proficiency in Python, Java, SQL, Power BI, and R.

Strong knowledge of database design and management, including relational databases (e.g., MySQL, PostgreSQL) and cloud-based systems.

Experience in data visualization and statistical analysis.

Familiarity with PEPFAR reporting tools and indicators is a significant advantage.

Ability to engage proactively with stakeholders, (government and donor stakeholders; INGOs) at national and provincial level. including leaders, technical professionals, and government and non-government representatives

Native Portuguese fluency; strong oral communications skills in English

Ability to work with minimal supervision and maximum accountability; attention to detail
Visit ICAP at Columbia University website to learn more about ICAP in Angola. Follow ICAP on linkedin to be notified when the link for applications becomes active. Only applications from ICAP site will be considered.

A global health leader since 2003, ICAP was founded at Columbia University with one overarching goal: to improve the health of families and communities. Together with our partners, we strive for a world where health is available to all. Our roots are in comprehensive, family-focused HIV services and high-performing health system strengthening initiatives that provide quality and affordable health care. ICAP in Angola has been working in partnership with the Angola Ministry of Health since 2016 to implement diverse HIV care and treatment programs in four provinces. ICAP Angola partnerships include INLS, National Public Health Directorate. Also, ICAP in Angola collaborate with Provincial and Municipal Health Directorates in Benguela, Cunene, Huambo and Lunda Sul provinces in the implementation of diverse evidence-based interventions to support the country in its aim to reach HIV epidemic control.