Research Data Analyst

University of California, San Francisco•San Francisco, CA
•Onsite

About The Position

The UCSF Department of Anesthesia & Perioperative Care seeks a part-time Research Data Analyst to support the Transplant Anesthesia Research Group (TARG) and the SATA Liver Transplant Outcomes Database, a multicenter observational research database integrating REDCap clinical forms, registry data, and anesthesia data from more than 16 contributing transplant centers. This is a limited appointment that ends 12 months after the start date and requires 40% effort (16 hours per week). The role is based at the UCSF Parnassus campus and requires in-person work. The analyst works under the direct supervision of Dr. Dieter Adelmann, co-principal investigator of TARG and the database. The position supports site onboarding and data coordination, database ETL, and the creation of research datasets. The analyst helps sites establish local REDCap projects, execute Data Use Agreements (DUAs), link local data to Scientific Registry of Transplant Recipients (SRTR) data, de-identify records, and securely share data with UCSF. The analyst also operates and maintains an existing R/Shiny upload tool that loads site data into PostgreSQL, and builds research datasets using SATA and the institutional Transplant Outcomes and Anesthesia Database (TOAD). The role involves ingesting, validating, and reconciling site submissions; conducting REDCap–registry concordance checks; applying and documenting corrections; and producing SQL and R extracts, QA queries, tables, and figures. The analyst maintains the existing application using institution-approved AI coding tools (Claude Code), reviews generated changes, tests them against a synthetic non-PHI database, and commits approved changes through Git. All data products must be accompanied by written validation checks covering items such as variable types, missingness, and reconciled counts. The analyst coordinates follow-up with participating institutions, tracks open items in the CRM system, supports site onboarding and local data management, and maintains SOPs and data dictionaries. DUA-bound data transfers must use the approved secure file-sharing system. The position also includes preparing IRB personnel and external-collaborator modifications for PI submission and completing UCSF-mandated compliance and privacy training. The role offers close exposure to clinical data and physician-researchers and may suit someone seeking hands-on clinical research experience, including preparation for a career in medicine or public health.

Requirements

  • Bachelor's degree in a quantitative, informatics, or related area, and/or equivalent experience or training.
  • At least one year of related experience.
  • Working proficiency in R, including tidyverse, for importing, cleaning, merging, recoding, and summarizing tabular data.
  • Ability to write SQL joins and aggregations against a relational PostgreSQL database.
  • Experience using Git for version control, including branches, commits, merges, and maintaining a readable history.
  • Ability to verify outputs before sharing by checking variable types, quantifying missingness, reconciling counts across tables, checking plausibility, and writing a concise validation note.
  • Experience using an AI coding assistant, such as Claude Code, to modify an existing codebase, including reading, testing, and correcting generated changes before adoption.
  • Ability to set up a development environment from written documentation, including SSH keys, credentials, environment variables, and package restoration, without a walkthrough.
  • Organizational skills to track open items across external institutions and meet concurrent deadlines without prompting.
  • Ability to handle protected health information responsibly and complete UCSF-mandated compliance and privacy training.
  • Ability to establish cooperative working relationships with coworkers, physicians, and staff at collaborating institutions.

Nice To Haves

  • REDCap experience, including project design, data dictionaries, or API exports.
  • Experience preparing IRB submissions or modifications.

Responsibilities

  • Ingest, validate, and reconcile site submissions to the SATA Liver Transplant Outcomes Database using the upload and validation application.
  • Review validation reports for missingness, outliers, out-of-codebook values, and ID-label errors; run REDCap–SRTR concordance and mislink checks; prepare audit sheets for sites; and apply and document corrections.
  • Write SQL and R code to extract cohorts, run QA queries, and produce summary tables and figures for research datasets, investigators, and grant reports.
  • Maintain version-controlled code in the shared GitHub Enterprise repository; avoid hard-coded paths and overwriting source variables, and document the provenance of derived variables.
  • Maintain and extend the existing R/Shiny and PostgreSQL data application using institution-approved AI coding tools; review generated code, test changes against a synthetic database, and commit changes with clear descriptions.
  • Escalate regressions in the upload application to the PI the same day.
  • Coordinate follow-up with more than 16 participating centers and track data deliveries, audit-sheet returns, DUA status, REDCap questions, and IRB letters in the CRM system.
  • Support site onboarding, local data merges, de-identification, and site REDCap data management; consult the PI before contacting a site about missing or implausible data.
  • Handle DUA-bound data transfers only through the approved secure file-sharing system, delete transfer copies after moving them, and prepare IRB personnel and external-collaborator modifications for PI submission.
  • Complete UCSF compliance and privacy training and keep site-onboarding and data-handling SOPs and per-file data dictionaries current.
  • Post planned tasks at the start of each workday and provide a written end-of-day status covering changes, blockers, and next steps.
  • Deliver every table, dataset, or figure with a written validation check that addresses variable types, missingness, and reconciled counts.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service