Witztum Lab - Junior Specialist

About the role

The Department of Radiation Oncology at UCSF, in the laboratory of Dr. Alon Witztum (Clinical Automation and Data Driven Insights - CADDI Lab), is seeking a highly motivated scientist/programmer for a Junior Specialist position focused on building the next generation of radiation oncology data infrastructure.

Responsibilities

• Maintain detailed documentation of data pipelines, workflows, and results.
• Extract, clean, and organize clinical data from Epic and departmental databases.
• Aid in developing automated scripts and ETL processes aligned with the O3 data model.
• Generate descriptive analyses, visualizations, and summary reports for clinical and research teams.
• Collaborate effectively with faculty, staff, and trainees to support project progress and data needs.
• Contribute to the development of self-service analytics tools.
• Ensure adherence to data governance, HIPAA requirements, and UCSF security standards.

Requirements

• Minimum of a Bachelor's degree in Data Science, Computer Science, Biomedical Engineering, Physics, or a related quantitative field and / or equivalent experience / training.
• Proficiency in SQL, including table design, joins, stored procedures, and optimization.
• Working knowledge of Python for data manipulation, transformation, and visualization.
• Understanding of the concepts underlying relational databases.
• Knowledge of secure software development.
• Demonstrated software repository skills.
• Demonstrated ability to follow software specifications.
• Demonstrated effective communication and interpersonal skills.
• Demonstrated problem-solving skills.
• Strong communication skills, with the ability to translate technical concepts for non-technical users.
• Self-motivated, detail-oriented, and capable of working both independently and collaboratively.
• Able to learn effectively and meet deadlines.

Preferred Qualifications

• Minimum of 1 year of related experience.
• Advanced SQL knowledge.
• Experience with Health Care related data.
• Experience with Epic, Cogito, and/or Clarity.
• Familiarity with HL7-FHIR.
• Experience with Streamlit, Shiny, or similar front-end tools.
• Experience with Tableau or similar self-service analytics tools.