Principal Clinical Datawarehouse Programmer

BeOne Medicines; San Mateo (CA); On-site; USD 140,000 - 210,000; Full time

Job summary

BeOne Medicines is seeking a Principal Clinical Datawarehouse Programmer to design, develop, test, and deploy ETL data pipelines for clinical studies. You will ensure data quality, governance, security, and scalable data models while collaborating with SDS, Clinical Operations, Safety, IT and Medical affairs.

The role requires 5+ years in ETL data pipelines, strong SQL, and experience with SDLC. Familiarity with CDISC SDTM/SDTMIG is a plus, with BI tools like Spotfire and PowerBI considered

Qualifications

• Bachelor’s degree in computer science or related field.
• 5+ years of ETL data pipelines experience in clinical domains.
• Strong SQL and relational database knowledge.
• Experience with SDLC and APIs.
• Experience with CDISC standards is a plus.

Responsibilities

• Design, develop, test, and deploy ETL data pipelines.
• Ensure data governance, security, and compliance.
• Build data models and validation checks.
• Collaborate with cross-functional stakeholders.
• Troubleshoot and optimize pipeline performance.

Skills

ETL pipelines

SQL

Python

R

Data governance

Data security

APIs

Troubleshooting

Education

Bachelor’s degree in CS/Software

Tools

Oracle LSH

DMW

CDA

ODI

OBIEE

Spotfire

PowerBI

Job description

General Description:

The Principal Clinical Datawarehouse Programmer will be responsible for the development and support of ETL (Extract, Transform, Load) data pipelines. Work with business/project owners to understand user requirements and translate them into ETL data pipeline design specifications following SDLC process. Design, develop, test, and deploy ETL data pipelines while maintaining best practices and engineering standards. Develop high-quality, well-tested, secure, and maintainable code. This position will ensure high quality clinical data for business decision making and risk management for clinical studies. This person will interact with stakeholders including SDS, Clinical Operations, Safety, IT, Medical affairs, and other relevant cross functional departments.

Essential Functions of the job:

• 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
• 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

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, Java Script, SDTM mapping/Programming, EDC experience is highly desirable.

Other Qualifications:

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

Travel:

N/A

Education Required:

Bachelor’s Degree and 5+ years of experience

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.