Research Data Analyst
Job Description
Support transplant research data operations for the SATA Liver Transplant Outcomes Database and the Transplant Anesthesia Research Group at UCSF Campus BU.
Responsibilities
- Ingest, validate, and reconcile multicenter transplant site submissions for the SATA Liver Transplant Outcomes Database using the group upload and validation application
- Review validation reports covering missingness, outliers, out-of-codebook values, and ID-label errors, then return audit sheets to participating sites
- Run REDCap to registry concordance checks, apply and document data corrections, and confirm successful rebuild of combined tables after each upload
- Develop SQL (PostgreSQL) and R code to extract cohorts, run QA queries, and generate summary tables and figures for research datasets using documented database conventions
- Maintain and extend the existing SATA data application (R/Shiny, PostgreSQL) with institution-approved AI coding tools (Claude Code)
- Direct AI-generated changes, review modifications, run the test suite against a local synthetic database, and commit updates via Git
- Coordinate data follow-up with 16+ participating centers by tracking open items (data deliveries, audit-sheet returns, DUA status, IRB letters) in a CRM system and chasing without prompting
- Support site onboarding, including local merge and de-identification steps
- Assist institutions with REDCap questions and local data management for the SATA Liver Transplant Outcomes Database; consult the PI before contacting sites about missing or implausible data
- Manage DUA-bound transfers only through the approved secure file-sharing system
- Prepare IRB personnel and external-collaborator modifications for PI submission
- Complete UCSF-mandated compliance and privacy training
- Post planned tasks at the start of each work day and provide a written end-of-day status describing changes, blockers, and next steps
- Keep site-onboarding and data-handling SOPs and per-file data dictionaries current
Requirements
- Bachelor’s degree in a quantitative, informatics, or related area and/or equivalent experience or training
- Minimum one (1) year of related experience
- Working proficiency in R (tidyverse) for importing, cleaning, merging, recoding, and summarising tabular data
- Ability to write SQL joins and aggregations against a relational database (PostgreSQL)
- Experience maintaining analysis code under Git version control (branches, commits, merges, readable history)
- Ability to verify outputs before sharing by checking variable types, missingness, table count reconciliation, and plausibility, plus writing a concise note of what was checked
- Experience using an AI coding assistant (e.g., Claude Code) to modify an existing codebase, including reading, testing, and correcting generated changes before adoption
- Ability to set up a working development environment from written documentation (SSH keys, credentials, environment variables, package restore) without a walkthrough
- Organizational skills to track open items across multiple external institutions and meet deadlines on concurrent threads without prompting
- Ability to handle protected health information responsibly and complete UCSF-mandated compliance and privacy training
- Ability to establish cooperative working relationships with co-workers, physicians, and staff at collaborating institutions
- REDCap experience (project design, data dictionary, API export)
- Experience preparing IRB submissions or modifications
Technology Stack
- R, tidyverse
- SQL, PostgreSQL
- Git
- REDCap
- R/Shiny
- Claude Code
- AWS Bedrock
- SSH
- CRM system
- Secure file-sharing system
Location: San Francisco, CA (onsite)
Job type: Part time (40%, 16 hours/week)
Salary: USD 33 - 70 per hourly