Principal Clinical Datawarehouse Programmer

About the role

The Principal Clinical Datawarehouse Programmer will develop and support ETL data pipelines, working closely with business/project owners to translate requirements into specifications and ensuring high-quality, secure, and maintainable code.

Responsibilities

• Work with business/project owners to understand and translate business requirements into ETL data pipeline design specifications.
• Design, develop, test, and deploy ETL data pipelines following SDLC process.
• Maintain ETL data pipelines and enforce data governance, security, and protection of data.
• Troubleshoot ETL data pipelines and debug faulty code.
• Monitor and improve ETL data pipelines performance.
• Test data outputs to ensure they are fit for use.
• Assemble large, complex data sets that meet business requirements.
• Prepare data outputs for manipulation by downstream applications/users.
• Design and build infrastructure for optimal ETL data pipelines from various data sources using SQL and other technologies.
• Support the development of analytics tools that provide actionable insights into operational efficiency and business performance metrics.
• Collaborate with internal and external stakeholders to address data-related technical issues and support data needs.

Requirements

• 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 industry.
• 2+ years’ experience with APIs.
• Experience with CDISC SDTM, SDTMIG, and other working CDASH standards.
• 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 platforms like Spotfire, PowerBI, etc.
• Computer Skills: Life Science Data Hub (LSH), Data Management Workbench (DMW), Clinical Data Analytics (CDA), OBIEE, REST API, SDLC Life Cycle processes, SQL, SAS, Python, JavaScript, SDTM mapping/programming, EDC experience is highly desirable.

Qualifications

• Minimum of Bachelor’s degree in computer science, software engineering, or related scientific discipline.

Benefits

Salary Range: $125,000.00 - $165,000.00 annually

BeOne offers a comprehensive benefits package that includes Medical, Dental, Vision, 401(k), FSA/HSA, Life Insurance, Paid Time Off, and Wellness. Employees also have the opportunity to own shares of BeOne Medicines Ltd. stock through discretionary equity awards and the Employee Stock Purchase Plan.