Reporting directly to the Senior Survey Analyst, the Staff Associate will provide analytic support in the areas of data management, documentation, and analysis to support the PHIA project. Responsibilities may include data cleaning, generating survey statistics, programming for ad hoc analyses, and preparing data documentation to support six or more nationally representative population-based surveys in sub-Saharan Africa designed to assess the impact of PEPFAR-supported HIV prevention, care and treatment programs.
Generate analytic outputs, including survey monitoring reports, report tables, and ad hoc analytic requests
Write and execute statistical programs for the creation of analysis datasets, tables, figures, and listings
Prepare data documentation including data dictionaries, codebooks, and data use manuals
Provide statistical programming expertise to project teams by preparing analytic data files, writing SAS code for Macros, and utilizing the SAS Macro library
Develops and updates specifications for automated monitoring reports (data visualizations) to be generated by cloud-based study databases (e.g. enrollment rates and completeness over time by study team and interviewer) and helps to review the reports against the specifications.
Develops additional ad hoc tables to be generated to monitor study progress and to validate the work of other analysts.
Ensure all programming activities and processes are conducted according to the PHIA project standard operating procedures and/or sponsor requirements
Performs other related duties, as directed
Internal Number: 4749
About Columbia University
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.