[Remote] Principal Clinical Datawarehouse Programmer
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