Data Analyst, SAS Experience Required, Public Health Surveillance Knowledge Preferred

Job Description: • Develop SAS programs for validating surveillance study data. • Verify that all variables that should be included in the resulting dataset are present in the dataset and extraneous variables are excluded. • Identify data discrepancies and other inconsistencies in the resulting dataset. • Run duplicate procedures and comparison of results to ensure validity with applicable standard of the resulting final data sets, indicators, questionnaire coding, metadata set, SAS programming, and output files. • Determine that variables calculated during data processing were calculated correctly (e.g. variable combining Race/Hispanic ethnicity). • Ensure that lost interviews have been added to the resulting dataset. • Generate data tables reflecting aggregate numbers for key indicators of data quality and aggregate recruitment numbers for study areas. • Review the output from the SAS programs generated above, and identify problems in the output that need to be reported. • Review online data error logs from each study area to ensure that requested data modifications are in keeping with the rules outlined by the study. • Identify errors/omissions of variable formats or labels. Document problems and proposed corrections needed to be made by the team before finalizing the data. • Review the data files containing raw interviews (i.e., QDS data warehouses) to ensure that study areas have not deleted interviews and that the exported number of interviews is the same as the number in the resulting dataset. Document problems and proposed corrections needed to be made by the team to finalize the data. • Review the quality of the weights generated for venue-based sampling cycles. Requirements: • Bachelor’s degree in public health or related field • Demonstrated ability to work with multiple data sources to monitor and assess data to ensure data quality, including accuracy and completeness. • Strong demonstrated SAS experience. • Clear communication (written and verbal). • Must have demonstrated SAS experience • Master’s degree in public health (preferred). • 2 years of experience in generating SAS-based reports using a variety of methods (e.g., PROC REPORT, PROC TABULATE) and exporting those reports to other formats such as Microsoft Excel, PDF, and HTML (preferred). • Knowledge of HIV data and public health surveillance systems (preferred). • Experience with large (>500,000 observations), document-based datasets (preferred). • Detail-oriented and able to create meticulous documentation of variables, datasets, and data attributes with a commitment to generating accurate data and products (preferred). • Strong organizational and interpersonal skills (preferred). • Proficient SAS coding experience (SAS MACROS, PROC SQL, FORMATS, etc.) (preferred). • Manipulating and cleaning data using a variety of SAS functions, formats/informats, and procedures (preferred). • Generating SAS-based reports using a variety of methods (e.g., PROC REPORT, PROC TABULATE) and exporting those reports to other formats such as Microsoft Excel, PDF, and HTML (preferred). • Experience with behavioral surveillance data (preferred). • Experience with Respondent Driven Sampling (RDS) methodology and data (preferred). Benefits: • Personal Time Off (PTO) • medical • dental • vision • supplemental life with AD&D • short and long-term disability • flexible spending accounts • parental leave • legal services • 401(k) Retirement Plan with a matching component • training for career development • access to best-in-class e-learning suite for formal and informal learning • professional and technical certification preparation • education assistance at accredited institutions Apply tot his job