Department Overview

The Oregon Clinical Translational Research Institute (OCTRI) at OHSU is a catalyst for scientific collaboration, translation of biomedical advances into the community, innovation, and research growth in Oregon and beyond. OCTRI's mission is to enhance the efficiency and quality of rigorously translating research ideas into impact. To accomplish our mission, our 80-90 employees spread across 13 teams provide a broad expanse of clinical and translational services that include training, funding, research support, and community engagement. OCTRI is part of the National Center for Translational Sciences (NCATS)-funded CTSA consortium that encompasses 60+ hubs around the country. Visit our website to learn more: octri.org.

The Research Data Warehouse (RDW) team is expanding to design and construct the next generation of the Research Data Warehouse at OHSU. The next generation RDW will support OHSU and the broader community to develop technologies for data retrieval, and enable applications in research data analysis such as machine learning, and artificial intelligence applications for clinical research.

Function/Duties of Position

We are currently hiring for a Research Data Warehouse Analytics Team Lead who will be critical for advancing both data discovery for translational research and the overall research capability at OHSU. We are actively seeking a candidate with experience in healthcare data (such as: electronic health records, wearables, social determinants of health, among others) to fulfill the role of Team Lead/Lead Analyst.

For this critical role on the team, we are looking for a Lead Analyst with experience in the following areas, but not limited to: data quality, SQL, electronic health record data, relational data structures, and data analytics tools in the cloud. Experience in a cloud computing environment such as AWS, Azure, distributed computing/high performance computing is preferred.

The RDW Analytics Team Lead role will be the key personnel interacting with clinician scientists and translational researchers to determine data requirements needed to fulfill scientific research needs and ensure that data requests are in compliance with all applicable regulatory requirements. The successful candidate will have the ability to effectively communicate and collaborate with clinical researchers and data warehousing staff to translate scientific questions into database queries and result sets. In addition to supervising the analyst team and creating new processes for efficient data delivery systems, this role will also be responsible for implementation of new data sources (e.g., wearables, social determinants of health) and structures into RDW, training clinicians in proper research data handling procedures and collaboratively interacting with researchers and staff. The successful candidate will also have experience and the knowledge of extracting, transforming, and loading (ETL) as well as experience working within an Oracle or MS SQL Server environment. Candidates who have obtained a certification from Epic for Clarity, Caboodle, or other data oriented Epic certification are preferred.

The schedule for this position is Monday-Friday with occasional evening and weekend work. This position is eligible for remote work with the understanding that there will the occasional need to come into the office for critical in-person meetings which are arranged in advance.

Required Qualifications

• PhD in relevant field AND 3 years of relevant experience; OR
• Master's Degree in relevant field AND 5 years of relevant experience; OR
• Bachelor's Degree in relevant field AND 7 years of relevant experience.

Preferred Qualifications

• EPIC Clarity Certification
• Experience with research design and data analysis
• Experience with Oracle, MS SQL Server
• Experience with BI tools
• Knowledge and/or application of national health information standards
• Experience Epic Clarity and or Epic Caboodle Data Warehouse
• Experience in on-premise and cloud technologies (e.g., Apache Spark, Hadoop, Tensorflow)
• Epic Clarity Proficiency or Certification in a specific subject area (Inpatient, Ambulatory, HB, PB, etc.)
• Epic Caboodle Data Model Proficiency or Certification

Additional Details

Apply online here.

Generous Benefits Package Including:

• Comprehensive health care plans. Covered 100% for full-time employees and 88% for dependents
• $25K of term life insurance provided at no cost to the employee
• Two separate above market pension plans to choose from
• Paid time off- 208 hours per year (full-time), prorated for part-time
• Extended illness bank- 64 hours per year, prorated for part-time
• 9 paid holidays per year
• Three weeks of paid parental leave
• Adoption assistance program (up to 5k)
• Substantial Tri-met and C-Tran discounts
• Tuition Reimbursement
• Innovative Employee Assistance Program (EAP)

All are welcome