Principal Clinical Datawarehouse Programmer

Scorpion Therapeutics; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Scorpion Therapeutics is seeking a Principal Clinical Datawarehouse Programmer to design, develop, and support ETL data pipelines for high-quality clinical data in studies. You will collaborate with SDS, Clinical Operations, Safety, IT, and Medical Affairs to ensure data governance, security, and timely data outputs for decision-making.

A 5+ year background in ETL, SQL, and clinical trial data is required. Proficiency in Python, R, and JavaScript, plus experience with Oracle Life Science Data

Qualifications

• Bachelor's degree in computer science, software engineering, or related field.
• 5+ years of experience with ETL development, SQL, relational databases, and clinical trial data.
• 2+ years SDLC experience.
• 3+ years experience with Oracle Life Science Data Hub, DMW, CDA, ODI.
• API experience.
• Proficiency in SQL, Python, R, JavaScript.
• Familiarity with CDISC SDTM/SDTMIG and EDC systems preferred.

Responsibilities

• Design, develop, test, and deploy ETL pipelines, validation checks, and data models.
• Maintain data pipelines with data governance, security, troubleshooting, and performance optimization.
• Collaborate with stakeholders across SDS, Clinical Operations, Safety, IT, Medical Affairs.
• Support analytics tools and data outputs for various business needs.

Skills

SQL

Python

R

JavaScript

API integration

Education

Bachelor's degree in computer science, software engineering, or related field

Tools

Oracle Life Science Data Hub

DMW

CDA

ODI

Job description

Role

Principal Clinical Datawarehouse Programmer responsible for developing and supporting ETL data pipelines to ensure high-quality clinical data for decision-making and risk management in clinical studies.

Responsibilities

• Design, develop, test, and deploy ETL pipelines, validation checks, and data models;
• Maintain data pipelines with data governance, security, troubleshooting, and performance optimization;
• Collaborate with stakeholders across SDS, Clinical Operations, Safety, IT, Medical Affairs;
• Support analytics tools and data outputs for various business needs.

Requirements

• Bachelor's degree in computer science, software engineering, or related field;
• 5+ years of experience with ETL development, SQL, relational databases, and clinical trial data;
• 2+ years SDLC experience;
• 3+ years experience with Oracle Life Science Data Hub, DMW, CDA, ODI;
• API experience;
• Proficiency in SQL, Python, R, JavaScript;
• Familiarity with CDISC SDTM/SDTMIG and EDC systems preferred.

High-Value

Clinical trial data management in biotech/pharma setting, focus on cancer studies, supporting regulatory/compliance standards, using Oracle Life Science platforms, with emphasis on data quality, security, and cross-functional stakeholder interaction.

Work setup

Not specified; travel not required.