| Summary Description: This position is grant funded.POSITION SUMMARY:Reporting directly to the Deputy Project Director, Technical Team, the GIS Analyst/Geodatabase Manager is responsible for the management and analyses of spatial data associated with implementation of nationally representative population-based surveys in sub-Saharan Africa designed to assess the impact of PEPFAR-supported HIV prevention, care and treatment programs. Works in conjunction with sub-contracted research corporations to design and maintain survey geodatabases and to conduct spatial analyses. Provides support in this area to CDC, Ministries of Health and ICAP country teams.MAJOR ACCOUNTABILITIES:- Designs and maintains geodatabases using field-acquired data, as well as data from third-party sources, including national governments, universities, open-access datasets, and commercial datasets- Conducts spatial analyses to facilitate survey implementation and to address research questions related to HIV outcomes- Supports GPS-enabled tablet-based collection of geospatial and ancillary data before, during, and after fieldwork implementation- Provides remote and in-country support to ICAP country teams on GIS data acquisition and data management; trains teams on the use of GIS, GPS-enabled tablets, and geospatial data; troubleshoots data collection and management challenges- Collaborates with GIS departments of national bureaus of statistics to reconcile discrepancies between master census file and GIS files- Works with Westat data management team to improve the map application used for PHIA surveys- Performs other related duties as directed- TRAVEL REQUIREMENTS:- Requires periodic international travel to sub-Saharan Africa to support data management and cleaning. Approximately seven (7) trips per year with each trip lasting approximately five (5) to ten (10) days each|
Minimum Qualifications: - Advanced proficiency using ESRI ArcGIS for Desktop- Demonstrated programming experience using Python and SQL- Proficiency in geospatial and statistical methods and analysis- Demonstrated knowledge regarding best practices for cartographic design, metadata documentation, and projected coordinate systems- Proficiency with Microsoft Office Suite (e.g., Excel, Word, Outlook, PowerPoint).- Excellent skills in critical thinking and analysis- Excellent organizational and oral/written communication skills
Preferred Qualifications: - Master's Degree in Geography, Geographic Information Science or related field.- Minimum four (4) years of relevant experience managing and analyzing large, population-based survey data- Proficiency using ESRI ArcGIS Online and ArcGIS for Server- Proficiency using SAS, STATA or R statistical software- Demonstrated experience providing training on GIS, GPS, geospatial data, and relational database management systems (RDBMS)- Experience working with issues relating to HIV/AIDS. Experience working in resource-limited environments in sub-Saharan Africa a plus
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.