Informatics Programmer Analyst

University of California, San Francisco; San Francisco (CA); On-site; USD 100,000 - 160,000; Full time

Job summary

University of California, San Francisco (UCSF) seeks a Programmer Analyst to translate complex specifications into actionable data extraction plans and to prepare data for in-depth analysis. You will work with researchers to configure cohorts and validate results using Python, SQL, SAS, R, or Stata on electronic medical records and claims data.

You will collaborate with researchers and PhD statisticians to produce robust analyses, generate reports, and ensure findings are ready for publication,

Qualifications

• Bachelor’s degree or equivalent experience in a relevant field.
• 3+ years of experience with data manipulation and data quality control.
• 3+ years of experience in statistical analysis and modeling.
• Proficiency with SAS, Python, R, or SQL.
• Experience working with large (>50Gb) datasets.
• Experience with electronic medical/health services data (e.g., SEER/EPIC/claims data).
• Research environment experience.
• Knowledge of bioinformatics methods, programming design, and data structures.
• Understanding of relational databases, web interfaces, and operating systems.
• Solid communication to work cross-functionally and manage projects.

Responsibilities

• Interpret complex requirements to identify correct data extraction fields.
• Apply analytical techniques for validation and cleaning; prepare data for analysis.
• Select patient cohorts and configure data to researchers’ specifications.
• Ensure data values meet researchers’ expectations.
• Manage and interpret large data volumes to derive insights.
• Support researchers using Python, SQL, SAS, R, or Stata with EMR and claims data.
• Produce detailed reports, charts, tables, and figures to convey findings.
• Apply complex statistical analysis with PhD statisticians to interpret results.
• Refine data analysis based on feedback; ensure results are ready for publication.

Skills

SAS

Python

SQL

R

Data manipulation

Data quality

Statistical analysis

Communication

Project management

Education

Bachelor's degree in biological science, computational or programming, or related area

Tools

SAS

Python

SQL

R

EPIC/claims data

Job description

Job Description

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 values 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

• Interpret complex requirements from detailed specifications to identify correct fields for data extraction.
• Apply analytical techniques for validation and cleaning, and prepare data for in-depth analysis.
• Select appropriate patient cohorts and configure data to researchers’ specifications.
• Confirm data values meet researchers’ expectations.
• Manage and interpret large volumes of data to derive meaningful insights.
• Support researchers and Principal Investigators using analytical tools such as python, SQL, SAS, R, or Stata with electronic medical records and claims data.
• Produce detailed reports, charts, tables, and figures that clearly convey findings.
• Apply complex statistical analysis with PhD Statisticians to support interpretation of results.
• Refine data analysis based on feedback and ensure results are 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, and a federated data steward program to support compliance and set best practice standards for analysts who access health system data outside of central IT.

Qualifications

Required Qualifications

• Bachelor's degree in biological science, computational or 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, application 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.