Witztum Lab - Junior Specialist

Position Overview 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. 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. The role involves preparing datasets for clinical and research initiatives and supporting the development of research-ready databases. This position 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. 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. 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 relational database concepts. Knowledge of secure software development. Demonstrated software repository skills. Demonstrated ability to follow software specifications. Effective communication and interpersonal skills. 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. Ability 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. Benefits & Salary Salary range: $55,000–$58,600. Location San Francisco, CA Equal Opportunity Employer The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law. UCSF is committed to welcoming and serving all people, honoring the dignity of every individual without preference or prejudice, in support of its public mission and in alignment with our PRIDE values and Principles of Community. As a condition of employment, the finalist will be required to disclose if they are subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct. Misconduct means any violation of the policies or laws governing conduct at the applicant's previous place of employment, including, but not limited to, violations of policies or laws prohibiting sexual harassment, sexual assault, or other forms of harassment, or discrimination, as defined by the employer. #J-18808-Ljbffr University of California - San Francisco