Note: The job is a remote job and is open to candidates in USA. BeOne Medicines is focused on fighting cancer and is seeking a Principal Clinical Datawarehouse Programmer to develop and support ETL data pipelines. This role involves working with stakeholders to design, develop, and maintain high-quality data pipelines that ensure the integrity of clinical data for decision-making 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
- 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)
- Minimum of Bachelor's degree in computer science, software engineering, or related scientific discipline
- Experience with CDISC SDTM, SDTMIG, and other working CDASH standards a plus
- Experience with BI platform (Spotfire, PowerBI, and etc.) a plus
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
- 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