The programmer analyst role includes the interpretation of complex requirements from detailed specifications to identify the correct fields for data extraction, applying analytical techniques for validation and cleaning, and preparation of data for in-depth analysis. This involves selecting appropriate patient cohorts, applying sophisticated programming strategies to configure data to researchers’ specification, and confirming value meet researchers’ expectations. The focus is on effectively managing and interpreting large volumes of data to derive meaningful insights. The programmer analyst will play a pivotal role in supporting researchers and Principal Investigators by employing analytical tools such as python, SQL, SAS, R, or Stata to work with electronic medical records and claims data. The ultimate aim is to provide a robust analytical foundation that supports research projects.

Key responsibilities include the meticulous organization and curation of data sets; executing sophisticated statistical analyses; and producing detailed reports, charts, tables, and figures that clearly convey the findings. The role might involve working closely with PhD Statisticians to apply complex statistical analysis to support the interpretation of results.

The programmer analyst will work closely with the lead investigators to refine data analysis based on feedback and ensure that the results are presented in a form that is ready for publication and dissemination.

Department Overview

The University of California, San Francisco (UCSF) Department of Information Technology Academic Research Services (ARS) is chartered to provide data services and infrastructure that support clinical researchers computing and analytic needs. The Clinical Data Research Consultants group’s services include the administration of Data Use Agreements for the reuse of CMS and Medicaid data, customized data extractions from UCSF health systems, a federated data steward program to support compliance and set best practice standards for analysts who access health system data outside of central IT.

REQUIRED QUALIFICATIONS

• Bachelor's degree in biological science, computational / programming, or related area and/or equivalent experience/training.
• Three + years of experience with data manipulation and data quality control
• Three + years of experience in statistical analysis and modeling
• Proficiency and programming experience in SAS, Python, R, or SQL
• Experience working with large (>50Gb) datasets
• Experience working with electronic medical/health services data (e.g, SEER/EPIC/claims data)
• Experience in a research environment
• Thorough knowledge of bioinformatics methods, applications programming, web development, and data structures.
• Thorough knowledge of bioinformatics programming design, modification, and implementation.
• Understanding of relational databases, web interfaces, and operating systems.
• Thorough knowledge of web, application, and data security concepts and methods.
• Research skills at a level to evaluate alternative solutions and develop recommendations
• Strong project management skills.
• Communication skills to work with both technical and non-technical personnel in multiple fields of expertise and at various levels in the organization.
• Ability to communicate technical information in a clear and concise manner.
• Ability to interface with management on a regular basis.
Self-motivated, work independently or as part of a team, able to learn quickly, meet deadlines, and demonstrate problem-solving skills.

PREFERRED QUALIFICATIONS

• Thorough knowledge of modern biology and the applicable field of research.
• Advanced degree in quantitative discipline and/or equivalent experience/training