POSITION SUMMARY

ICAP at Columbia University’s Global Fund (GF) COVID-19 Response Mechanism C19RM) Technical Assistance aims to support host-country governments to strengthen COVID-19 responses, develop future pandemic preparedness and response capacity and mitigate the knock-on effects of COVID19 on HIV, TB and malaria clinical services. In the Philippines, the program provides technical assistance (TA) and capacity-building support to the Department of Health, in collaboration with key stakeholders and local partners. Under the direction of the Strategic Information (SI) Officer, the Surveillance Specialist will provide technical assistance and capacity building support to the Epidemiology Bureau of the Department of the Health of the Philippines to bolster priority disease surveillance activities, including HIV, TB, malaria and SARS-COV2.

RESPONSIBILITIES

• Data cleaning and data management (10%)
• Prepare data documentation including data dictionaries, codebooks, and data use manuals (10%)
• Write, update, validate, and run statistical programs for analyses (e.g., creation of datasets, tables, figures and listings) (45%)
• Summarize data and prepare routine and ad hoc reports and presentations to meet reporting requirements and requests for donors and stakeholders (e.g., SAPs, PowerPoint, dashboards) (10%)
• Provide statistical programming expertise to project teams by preparing analytic data files, writing code for macros, and utilizing macro libraries (5%)
• Develops and updates specifications for automated monitoring reports to be generated by project databases (5%)
• Provide support to the DOH-EB to improve data collection and use (eg. HIV, TB surveillance, SARS-Cov2) and participate in Technical Advisory Group (TAG) meetings (10%)
• Perform other related duties as assigned by the ICAP Supervisor (5%)

EDUCATION

• Demonstrated experience in data analysis (preferably using SAS and/or R) and statistical analysis with a high level of organization, autonomy, technical skill and team orientation
• 3-5 years of related experience designing, managing, and working directly with databases from research studies
• Demonstrated writing skills: reports, presentations, and/or protocols
• Demonstrated experience executing statistical programs for the creation of tables, figures, listings, and analysis databases
• Demonstrated expertise in project-specific dataset/database structures and related data cleaning and coding methods
• Excellent attention to detail and strong formatting skills using the Microsoft Office Suite
• Experience using geospatial analytic software, including QGIS, ArcGIS
• Data analysis experience using SAS, STATA or SPSS
• Experience using existing data systems (HARP, OHASIS) for the national HIV program in the Philippines
• Experience with data visualization software such as Tableau or PowerBI
• Excellent verbal and written communication skills required
• Fluent in English and Filipino

EXPERIENCE, SKILLS & PREFERRED QUALIFICATIONS

• Experience working with PEPFAR, U.S. Government or other bi-lateral donors preferable, with strong familiarity with PEPFAR reporting requirements
• Experience with large dataset related to health
• Understanding of public health, preferably including global HIV/AIDS
• Knowledge of R or other statistical language for making figures
• Knowledge of data cleaning methods

TRAVEL REQUIREMENTS: As needed.