[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.ResponsibilitiesWork with business/project owners understanding business requirementsIn-depth understanding of clinical trials and their associated deliverablesDesign ETL data pipelines specifications following SDLC processDesign, develop, test, and deploy ETL data pipelinesDesign, develop, test, and deploy Validation ChecksDesign, develop, test, and deploy Data ModelsMaintain ETL data pipelines and enforce data governance, security, and protection of our dataTroubleshooting ETL data pipelines and debugging faulty codeMonitoring and improving ETL data pipelines performanceTesting data outputs to ensure that they are fit for useAssemble large, complex data sets that meet business requirementsPreparing data outputs for manipulation by downstream applications/usersDesign 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 metricsWork with internal and external stakeholders to assist with data-related technical issues and support data needsAbility to work in a dynamic environmentPerform other duties as directed by Director, Clinical Data ArchitectSkills5+ years' experience with ETL data pipelines5+ years' experience with SQL and relational databases2+ years' experience with SDLC3+ years' experience with clinical trial data in the pharmaceutical/biotechnology2+ years' experience with APIsExperience with CDISC SDTM, SDTMIG, and other working CDASH standards a plus3+ 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 plusMinimum of Bachelor's degree in computer science, software engineering, or related scientific disciplineBenefitsNon-Commercial roles are eligible to participate in the annual bonus planCommercial roles are eligible to participate in an incentive compensation planAll Company employees have the opportunity to own shares of BeOne Medicines Ltd. stock because all employees are eligible for discretionary equity awardsAll employees are eligible to voluntarily participate in the Employee Stock Purchase PlanThe Company has a comprehensive benefits package that includes Medical, Dental, Vision, 401(k), FSA/HSA, Life Insurance, Paid Time Off, and WellnessCompany OverviewBeiGene is a global oncology company. It was founded in 2010, and is headquartered in Cambridge, Massachusetts, USA, with a workforce of 0-1 employees. Its website is https://www.beigene.com.Company H1B SponsorshipBeiGene has a track record of offering H1B sponsorships, with 14 in 2025, 32 in 2024, 39 in 2023, 40 in 2022, 28 in 2021, 16 in 2020. Please note that this does not guarantee sponsorship for this specific role.