高级临床数据仓库程序员
Principal Clinical Datawarehouse Programmer
BeOne持续以快速的步伐增长,为有经验的专业人士提供具有挑战性和令人兴奋的机会。在考虑候选人时,我们寻找高度积极、协作,并且最重要的是,对抗击癌症充满热情的科学和商业专业人士。
职位概述:
首席临床数据仓库程序员将负责ETL(抽取、转换、加载)数据管道的开发和支持。与业务/项目负责人合作,理解用户需求,并根据SDLC流程将其转化为ETL数据管道设计规范。设计、开发、测试和部署ETL数据管道,同时保持最佳实践和工程标准。开发高质量、经过充分测试、安全且易于维护的代码。该职位将确保为业务决策和临床研究的风险管理提供高质量的临床数据。该人员将与包括SDS、临床运营、安全性、IT、医学事务和其他相关跨职能部门的干系人进行互动。
岗位主要职责:
· 与业务/项目负责人合作,理解业务需求
· 深入了解临床试验及其相关交付成果
· 根据SDLC流程设计ETL数据管道规范
· 设计、开发、测试和部署ETL数据管道
· 设计、开发、测试和部署验证检查
· 设计、开发、测试和部署数据模型
· 维护ETL数据管道,执行数据治理、安全和数据保护
· 排查ETL数据管道问题并调试错误代码
· 监控和优化ETL数据管道性能
· 测试数据输出,确保其适合使用
· 整合符合业务需求的大规模复杂数据集
· 准备数据输出,供下游应用程序/用户使用
· 如果需要,使用SQL和其他技术(如R或Python)从各种数据源设计和构建最优ETL数据管道的基础设施
· 支持构建分析工具,利用数据提供操作效率和其他关键业务绩效指标的可操作洞察
· 与内部和外部干系人合作,协助解决与数据相关的技术问题并支持数据需求
· 能够在动态环境中工作
· 完成临床数据架构师主任指派的其他任务
· 5年以上相关工作经验
查看英文原文
BeOne continues to grow at a rapid pace with challenging and exciting opportunities for experienced professionals. When considering candidates, we look for scientific and business professionals who are highly motivated, collaborative, and most importantly, share our passionate interest in fighting cancer.
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
Global Competencies
When we exhibit our values of Patients First, Driving Excellence, Bold Ingenuity and Collaborative Spirit, through our twelve global competencies below, we help get more affordable medicines to more patients around the world.
- Fosters Teamwork
- Provides and Solicits Honest and Actionable Feedback
- Self-Awareness
- Acts Inclusively
- Demonstrates Initiative
- Entrepreneurial Mindset
- Continuous Learning
- Embraces Change
- Results-Oriented
- Analytical Thinking/Data Analysis
- Financial Excellence
- Communicates with Clarity
Salary Range: $125,000.00 - $165,000.00 annuallyBeOne is committed to fair and equitable compensation practices. Actual compensation packages are determined by several factors that are unique to each candidate, including but not limited to job-related skills, depth of experience, certifications, relevant education or training, and specific work location. Packages may vary by location due to differences in the cost of labor. The recruiter can share more about the specific salary range for a preferred location during the hiring process. Please note that the listed range reflects the base salary or hourly range only. Non-Commercial roles are eligible to participate in the annual bonus plan, and 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 and 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.
We are proud to be an equal opportunity employer. BeOne does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need. In order to ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Era Veterans’ Readjustment Assistance Act of 1974, Title I of the Americans with Disabilities Act of 1990, and any other applicable federal, state or local laws, applicants who require reasonable accommodation in the job application process may contact .
Originally posted on Himalayas