Principal Clinical Datawarehouse Programmer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+15 more
Job 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
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
Β· 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
Benefits & conditions
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 annually
BeOne 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦