"Witztum Lab - Junior Specialist"

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.

Position Overview: The Junior Specialist will assist in developing and automating data pipelines that integrate Epic, ARIA, and departmental databases into a unified informatics environment aligned with the O3 (Operational Ontology for Oncology) data model. We are looking for an organized, detail-oriented individual who can standardize heterogeneous clinical data, support real-time data requests, and contribute to multi-institutional data collaborations.

The position will involve preparing datasets for clinical and research initiatives and supporting the development of research-ready databases.

This role offers valuable experience at the intersection of clinical informatics, data science, and radiation oncology, preparing candidates for future growth in research, data engineering, or graduate/professional programs.

Required Qualifications:

• 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.

Key Responsibilities:

• Maintain detailed documentation of data pipelines, workflows, and results.
• Extract, clean, and organize clinical data from Epic and departmental databases.
• Assist 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.

Please apply online at https://aprecruit.ucsf.edu/JPF05901. Applicants' materials must list current and/or pending qualifications upon submission.

See Table 24B for the salary range for this position. A reasonable estimate for this position is $55,000-$58,600.

Document requirements

• Curriculum Vitae - CV must clearly list current and/or pending qualifications (e.g. board eligibility/certification, medical licensure, etc.).
• Cover Letter
• Statement of Research (Optional)
• Statement of Teaching (Optional)

Reference requirements

• 2-4 required (contact information only)