Note: The job is a remote job and is open to candidates in USA. BeOne Medicines USA, Inc. is a rapidly growing company focused on fighting cancer, seeking a Principal Clinical Datawarehouse Programmer. This role involves developing and supporting ETL data pipelines, working closely with stakeholders to ensure high-quality clinical data for decision-making and risk management in clinical studies.

Responsibilities

• 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

Skills

• 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
• Minimum of Bachelor's degree in computer science, software engineering, or related scientific discipline

Benefits

• Non-Commercial roles are eligible to participate in the annual bonus plan
• Commercial roles are eligible to participate in an incentive compensation plan
• All Company employees have the opportunity to own shares of BeOne Medicines Ltd. stock because all employees are eligible for discretionary equity awards
• All employees are eligible to voluntarily participate in the Employee Stock Purchase Plan
• The Company has a comprehensive benefits package that includes Medical, Dental, Vision, 401(k), FSA/HSA, Life Insurance, Paid Time Off, and Wellness

Company Overview

Company H1B Sponsorship