About this role
This is a limited appointment position will end 12-months after the start date.
Involves gathering, analyzing, and interpreting a wide variety of research data. Designs and conducts research including selecting data samples, developing research instruments, analyzing collected information according to established statistical methods, and developing recommendations based on research findings. Prepares reports, charts, tables, and other visual aids to interpret and communicate data and results.
The UCSF Department of Anesthesia & Perioperative Care seeks a part-time (40%, 16 hours/week) Research Data Analyst to support the Transplant Anesthesia Research Group and the SATA Liver Transplant Outcomes Database (https://liverdatabase.com), a multicenter research database integrating REDCap clinical forms, registry data, and anesthesia data from 16+ contributing transplant centers.
Under the supervision of the Principal Investigator (PI), the incumbent performs defined duties supporting the Transplant Anesthesia Research Group and the SATA Liver Transplant Outcomes Database, a multicenter observational research database. The position involves direct participation in data ingestion and validation, SQL and R programming, maintenance of an existing data application, and coordination of data with participating institutions.
- Ingest, validate, and reconcile site data submissions to the SATA Liver Transplant Outcomes Database using the group's upload and validation application; review validation reports (missingness, outliers, out-of-codebook values, ID-label errors) and return audit sheets to sites.
- Run REDCap–registry data concordance checks; apply and document data corrections; and confirm the successful rebuild of the combined tables after each upload.
- Write SQL (PostgreSQL) and R code to extract cohorts, run QA queries, and produce summary tables and figures for research datasets, following the database's documented conventions.
- Maintain and extend the existing SATA data application (R/Shiny, PostgreSQL) using institution-approved AI coding tools (Claude Code): direct the tool, review generated changes, run the test suite against the local synthetic database, and commit through Git.
- Coordinate data follow-up with 16+ participating centers: track open items (data deliveries, audit-sheet returns, DUA status, IRB letters) in our CRM system and chase without prompting; support site onboarding and local merge and de-identification steps.
- Assist participating institutions with REDCap questions and local data management for the SATA Liver Transplant Outcomes Database; consult the PI before contacting a site regarding missing or implausible data.
- Handle DUA-bound data 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 a written end-of-day status (what changed, what is blocked, what is next); keep site-onboarding and data-handling SOPs and per-file data dictionaries current.
Works on research data reporting assignments that are of moderate diversity in scope. Exercises judgment within generally defined practices and policies in selecting methods and techniques for obtaining solutions.
Applies working proficiency in R and SQL to defined segments of an established multicenter observational database. Ingests, validates, and reconciles site data submissions; writes and maintains version-controlled extracts and reports; and maintains an existing data application using AI-assisted development tools, reviewing and testing generated changes before adoption. Coordinates data-related follow-up with participating institutions and keeps project documentation up to date. Every table, dataset, or figure is delivered to the research team with a written validation check (variable types, missingness, reconciled counts).
The Research Data Analyst works under the direct supervision of Dr. Dieter Adelmann, co-principal investigator of the UCSF Transplant Anesthesia Research Group (TARG) and the SATA Liver Transplant Outcomes Database.
The position will comprise three main tasks
- 1. To manage the onboarding of new sites: help each site set up its local REDCap project, execute a Data Use Agreement (DUA) with UCSF, link its local data to registry data, de-identify the data, and share it securely with UCSF. Working with the sites on data cleaning and outlier review, the analyst ensures that each dataset is complete, correctly linked, and consistent with the national registry (the Scientific Registry of Transplant Recipients, SRTR).
- 2. To help manage the ETL process for the SATA Liver Transplant Outcomes Database: as part of the data coordinating center, the analyst will help maintain an existing R/Shiny upload tool that ingests data submitted by participating sites and loads it into a PostgreSQL database. The tool itself is maintained using Claude Code, which runs on AWS Bedrock for PHI compliance.
- 3. To build research datasets based on data from the SATA Liver Transplant Outcomes Database and our institutional data warehouse, the Transplant Outcomes and Anesthesia Database (TOAD).
This role bridges data science and medicine and is well-suited to anyone seeking hands-on clinical research experience, including those preparing for a career in medicine or public health. We are looking for someone comfortable navigating databases, experienced with using AI coding agents responsibly, and fundamentally committed to strict compliance and data security when handling protected health information (PHI). Above all, you should bring a genuine curiosity for real-world clinical data. In addition to the technical work, the position offers close exposure to clinical data and to the clinical reasoning of our physician-researchers.
How to apply
Submit a resume and a cover letter of no more than one page. Your cover letter must be written as exactly four numbered paragraphs in the order below, with a strict maximum of four sentences per paragraph. At the end of your letter, after paragraph (4), please explicitly acknowledge your understanding that this is a limited-time, 40% effort position requiring in-person work at the UCSF Parnassus campus; this acknowledgment does not count toward the four-paragraph or sentence limits.
The four paragraphs
- Summarize how your education and training so far make you the ideal candidate for this position, and how the experience gained in this position will help you reach your professional goals.
- Describe your practical experience working with large datasets, including the scale of the data and the tools you utilized.
- Detail your experience working/observing/volunteering in the medical field, or if you lack direct clinical experience, explain how your background prepares you to handle healthcare data.
- Describe a specific data or coding project you have worked on and explain exactly how that work applies to the responsibilities of this role. Within this paragraph, include a link to a Git repository (public or shared on request) that showcases your relevant work and commit history.
Cover letters that do not follow this structure will not be reviewed.
Department Overview
The Department of Anesthesia and Perioperative Care at UCSF provides outstanding patient care, promotes cutting-edge basic and clinical science research, and educates the next generation of healthcare providers while focusing on the UCSF Principles of Community.
The Department of Anesthesia and Perioperative Care ranks as one of the largest departments in the School of Medicine, with an annual budget of $207 million. The three largest components of the annual revenue budget are Funds Flow Revenue, the affiliation agreement with the city and county of San Francisco, and Extramural Funds, which together represent 85.2% or $171 million. As of 2026, the department has over 200 Faculty members, 61 Staff Physicians, 200 Staff Employees, 20 Fellows, 90 Residents, 17 Non-Faculty Academics, 13 Postdocs, and 8 Nurse Practitioners. The department also works closely with 87 Certified Registered Nurse Anesthetists (CRNAs).
In addition to the Moffitt-Long Hospital, very active units of the department exist at the Zuckerberg San Francisco General Hospital (ZSFG) (inpatient and outpatient, including an active trauma service); San Francisco Veterans Affairs Medical Center (inpatient and outpatient); Mount Zion Medical Center (outpatient, including 23 hour stays); Benioff Children's Hospital Oakland; the UCSF Orthopedic Institute; the Benioff Children's, Betty Irene Moore Women's and Bakar Cancer (NIH-designated Cancer Center) Hospitals; and the Bayfront Medical Building (outpatient, Center for Pain Medicine) in the Mission Bay neighborhood.
The Department now has essential roles in patient care outside of the operating rooms, with active participation in Ambulatory Care, Acute and Chronic Pain, and in the Preoperative Clinic. Since 1958, the department has been at the heart of modern anesthesia’s explosive growth, and to this day continues to have an enormous impact on surgical practice and the management of pain. The department’s research, education, and clinical care earned and have maintained reputations equal to or better than that of any institution in the world.
Individual members of our faculty have had a major influence on our specialty both nationally and internationally, including NIH study sections, NIH funding, and FDA and Editorial Boards. Research activities within the department are integrated with and inform clinical practice. For many years, ours has been among the top departments in the United States for NIH research funding in anesthesia.
The Department of Anesthesia provides considerable support and structure for research and research training programs, highlighted by the innovative Pathway to Scientific Independence (PSI). This program begins at the residency level, incorporating the Research Scholars Track of the Anesthesia Residency, moving through the post-residency NIH-funded T32 training grant, and culminating in faculty positions with mentored research support, ultimately achieving extramurally funded, independent researcher status.
% of time
Essential Function (Yes/No)
Key Responsibilities
(To be completed by Supervisor)
20
YesIngest, validate, and reconcile site data submissions to the SATA Liver Transplant Outcomes Database. Run the upload and validation application for each center's REDCap and SRTR data; review validation reports (missingness, outliers, out-of-codebook values, ID-label errors); run REDCap–SRTR concordance and mislink checks; generate and return audit sheets to sites; apply and document data corrections.
30
YesWrite SQL and R against the group's PostgreSQL research databases and PI-supplied extracts. Build cohort extracts, QA queries, summary tables, and figures for investigators and grant reports, following the database's documented conventions. Keep all code in the shared GitHub Enterprise repository under version control with no hard-coded paths; never overwrite a source variable; document the provenance of every derived variable.
20
YesMaintain and extend the existing SATA data application (R/Shiny, PostgreSQL) using institution-approved AI coding tools. Direct Claude Code to implement bug fixes, new validation or exception rules, new SQL extracts, and small dashboard features; review generated code changes; run the existing tests against a synthetic (non-PHI) test database; commit changes with clear descriptions; escalate regressions in the upload app to the PI the same day. Development is done only on the approved endpoint and never with case-level data in the repository.
20
YesCoordinate data follow-up with 16+ participating centers. Own the open-items list per site (data deliveries, audit-sheet returns, DUA status, REDCap questions, IRB letters) in our CRM system; chase without prompting; support site onboarding and local merge and de-identification steps by Zoom; answer site REDCap questions; discuss with the PI before contacting a site about missing data.
10
YesRegulatory and data-governance support. Receive and send DUA-bound data only through the approved secure file-sharing system, never email or Slack; delete transfer copies once moved; prepare personnel and external-collaborator IRB modifications for PI submission and act on IRB coordinator letters; complete UCSF compliance and privacy training.
100%
(To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)
Required Qualifications
- Bachelor's degree in a quantitative, informatics, or related area and / or equivalent experience / 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 keeping analysis code under version control with Git: branches, commits, merges, and a readable history.
- Ability to verify an output before sharing it: confirm variable types, quantify missingness, reconcile counts across tables, and check plausibility; and to write 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 adopting them.
- Ability to set up a working development environment (SSH keys, credentials, environment variables, package restore) from written documentation without a walkthrough.
- Organizational skills to track open items across many external institutions and meet deadlines on concurrent threads without prompting.
- Ability to handle protected health information responsibly and to complete UCSF-mandated compliance and privacy training.
- Ability to establish cooperative working relationships with co-workers, physicians, and staff at collaborating institutions.
Preferred Qualifications
- REDCap experience (project design, data dictionary, API export).
- Experience preparing IRB submissions or modifications.