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.
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It... seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.