Principal Clinical Datawarehouse Programmer

BeOne Medicines

Principal Clinical Datawarehouse Programmer developing ETL data pipelines for cancer research. Collaborating with various stakeholders to ensure high-quality clinical data for decision making.

Posted 6/17/2026full-timeRemote • 🇺🇸 United StatesLead💰 $125,000 - $165,000 per yearWebsite

Tech Stack

Tools & technologies

ETLOraclePythonSDLCSQL

About the role

Key responsibilities & impact

Work with business/project owners understanding business requirements.
In-depth understanding of clinical trials and their associated deliverables
Design ETL data pipelines specifications following SDLC process.
Design, develop, test, and deploy ETL data pipelines.
Design, develop, test, and deploy Validation Checks
Design, develop, test, and deploy Data Models.
Maintain ETL data pipelines and enforce data governance, security, and protection of our data.
Troubleshooting ETL data pipelines and debugging faulty code.
Monitoring and improving ETL data pipelines performance.
Testing data outputs to ensure that they are fit for use.
Assemble large, complex data sets that meet business requirements.
Preparing data outputs for manipulation by downstream applications/users.
Design and build the infrastructure if required for optimal ETL data pipelines from a wide variety of data sources using SQL and other technologies (like R or Python).
Support the build analytics tools that utilize the data to provide actionable insights into operational efficiency, and other key business performance metrics.
Work with internal and external stakeholders to assist with data-related technical issues and support data needs.
Ability to work in a dynamic environment.
Perform other duties as directed by Director, Clinical Data Architect

Requirements

What you’ll need

5+ years’ experience with ETL data pipelines
5+ years’ experience with SQL and relational databases
2+ years’ experience with SDLC
3+ years’ experience with clinical trial data in the pharmaceutical/biotechnology
2+ years’ experience with APIs
Experience with CDISC SDTM, SDTMIG, and other working CDASH standards a plus
3+ Years’ Experience with Oracle Life Science Data Hub (LSH)
3+ Years’ Experience with Oracle Data Management Workbench (DMW)
3+ Years’ Experience with Oracle Clinical Data Analytics (CDA)
3+ Years’ Experience with Oracle Clinical Data Analytics (ODI)
Experience with Oracle Business Intelligence Enterprise Edition (OBIEE)
Experience with BI platform (Spotfire, PowerBI, and etc.) a plus

Benefits

Comp & perks

Medical
Dental
Vision
401(k)
FSA/HSA
Life Insurance
Paid Time Off
Wellness

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL data pipelinesSQLrelational databasesSDLCAPIsCDISC SDTMSDTMIGOracle Life Science Data HubOracle Data Management WorkbenchOracle Clinical Data Analytics

Soft Skills

communicationtroubleshootingproblem-solvingcollaborationadaptability