UCSF Office of Population Health (OPH) is looking for an experienced analyst to support Occupational Health Services (OHS) as it relates to employee COVID testing and vaccine compliance. Since the start of the pandemic in March 2020, the analytic team in the Office of Population Health has worked collaboratively with OHS, Student Health Services, and Human Resources to support the analytic and reporting needs related to testing, contact tracing, as well as vaccination and booster compliance for the UCSF employee and student communities. The incumbent will play a key role in ensuring that accurate and actionable data is reported to both internal and external stakeholders.
Reporting directly to the Director of Analytics for Population Health and a matrixed reporting relationship to Occupational Health leadership, the incumbent will be expected to work collaboratively with clinical, operational, and technical teams across the UCSF enterprise to manage existing data sources, establish new data sources, develop consistent metrics across a variety of reporting entities, and build new or maintain existing Tableau dashboards. The incumbent will be expected to work closely with both technical and non-technical stakeholders to assess report specifications, determine data source requirements, and establish plans for efficient and effective collection and presentation of data. He or she will be required to ensure the accuracy and quality of reports through careful review of results and clearly document report specs. When necessary, the incumbent will work directly with requestors to clarify desired outcomes and develop adjustments to report specs accordingly. The incumbent will also be expected to develop ad hoc reports for outside parties (e.g., federal or state regulatory agencies) or internal organizations.
The successful candidate will be an experienced SQL report writer who is competent in working in a Microsoft SQL environment. The incumbent will be required to develop queries or use database programs to combine disparate data sources, so in addition to SQL, the successful candidate will have additional programming skills such as SAS, R, or Python needed to wrangle data from these disparate data systems. He or she will use quantitative methods and statistical tools to generate analytics, complex reports, and recommendations that support and enhance business processes.
The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and high-quality patient care. It is the only UC campus in the 10-campus system dedicated exclusively to the health sciences.