- Work closely with researchers, data scientists, and other stakeholders to understand their data requirements and translate them into efficient ETL solutions.
- Develop, implement, and maintain ETL processes using SSIS and t-SQL stored procedures to extract, transform, and load data from Epic EHR and other sources into common data models like PCORnet CDM and OHDSI's OMOP.
- Ensure data quality and integrity throughout the ETL process by performing data mapping, transformation, and validation.
- Optimize ETL processes for performance, scalability, and reliability, identifying and resolving bottlenecks as needed.
- Collaborate with team members to integrate data from disparate sources and ensure seamless data flow for research purposes.
- Maintain up-to-date knowledge of healthcare domain, including clinical terminologies, workflows, data standards, and regulations.
- Adhere to data security best practices and ensure compliance with privacy regulations like HIPAA.
- Provide (and request) technical support and guidance to (and from) other team members as needed.
- Contribute to project management, setting priorities, and meeting deadlines.
Research Programmer Analyst - SanFrancisco, United States - University of California San Francisco
Found in: beBee S2 US - 3 weeks ago
Description
Details
Posted: 23-Oct-23
Location: San Francisco, California
Type: Full-time
Salary: Open
Categories:
Staff/Administrative
Internal Number: 74901BR
Work as a Research Programmer Analyst (RPA) on a small team to develop, operate, and maintain ETL processes, clinical data warehouses, and associated data products for health research.
The RPA's role is multi-faceted, involving domain knowledge (clinical data, research informatics), technical expertise, and communication skills. The RPA will operate, monitor, and enhance existing ETL processes and infrastructure, develop data profiles, perform quality assessments, investigate data anomalies, and create/maintain related documentation and annotated data dictionaries. The RPA will routinely communicate with researchers, clinicians, data scientists, and other stakeholders to stay aligned with needs to understand data requirements and translate them into efficient, well-documented ETL solutions.
The RPA will support multiple projects and data assets, including the PCORnet CDM (and related research projects), the UC Health Data Warehouse (UC HDW Operational OMOP), and the "All of Us" Research Program.
Responsibilities include, but are not limited to the following:
To see the salary range for this position (we recommend that you make a note of the job code and use that to look up): TCS Non-Academic Titles Search )
Please note: The compensation ranges listed online for roles not covered by a bargaining unit agreement are very wide, however a job offer will typically fall in the range of 80% – 120% of the established mid-point. An offer will take into consideration the experience of the final candidate AND the current salary level of individuals working at UCSF in a similar role.
For roles covered by a bargaining unit agreement, there will be specific rules about where a new hire would be placed on the range.
To learn more about the benefits of working at UCSF, including total compensation, please visit:
View or Apply
To help us track our recruitment effort, please indicate in your email – cover/motivation letter where ) you saw this job posting.