DataJobs.io
← Back to all jobs

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

Similar Jobs