Bayer is a global enterprise with core competencies in the Life Science fields of health care and agriculture. Its products and services are designed to benefit people and improve their quality of life. At Bayer you have the opportunity to be part of a culture where we value the passion of our employees to innovate and give them the power to change.

Principal Clinical Data Warehouse Programmer

Your tasks and responsibilities

 

The primary responsibilities of this role, Principal Clinical Data Warehouse Programmer, are to:

 

  • Understand protocol and compound requirements and has responsibility to translate them to technical specifications;
  • Document and maintain study level specifications for data transformations ensuring a high level of consistency and quality within and across studies;
  • Develop and maintain study level programs to create operational study level data structures for downstream end to end use by multiple consumers ensuring alignment across studies within the same compound;
  • Create and maintain consumer areas and/or data marts for the provision and use of data;
  • Ensure that standard development and testing techniques are used and that all solutions are of the highest quality and conform to all SOPs, OIs and Best Practice Documents;
  • Facilitate requirements gathering from consumers and develop solutions to meeting immediate and long-term needs of business customers;   
  • Perform compliance of study structure against standard library definitions;
  • Collaborate with study team functional representatives to ensure a sound understanding of the technical platforms for standardized solutions to study related requests or issues;
  • Monitor system performance and integrity from user perspective, and report any deficiencies to technical colleagues.  Work with technical colleagues on identification and implementation of corrective and preventative actions, as required;    
  • Estimate the time and resources needed to complete assignments. Track work progress and provide status reports to line manager and study team representatives;
  • Complete documentation associated with programming tasks in compliance with applicable SOPs, OIs and Best Practice Documents;
  • Participate and actively contribute to process definition and documentation of Best Practices and/or step by step guides;
  • Closely collaborate and communicate within the group and across the organization;
  • Participate and actively contribute to cross functional process optimization initiatives;
  • Participate in Knowledge Sharing forums within the group and across the organization;
  • Assist with the training of new programmer(s) or temporary staff;
  • Perform other duties as assigned.

 

Who you are

 

Your success will be driven by your demonstration of our LIFE values.  More specifically related to this position, Bayer seeks an incumbent who possesses the following:

 

Required Qualifications:

  • Masters in a natural science, Statistics, Computer Science or a related field with 5+ years of experience in a technical environment, focusing on data warehousing and/or extract, transform, load (ETL) activities;
  • Bachelors in a natural science, Statistics, Computer Science or a related field with 8+ years of experience in a technical environment, focusing on data warehousing and/or ETL activities;
  • Experience considered higher weight over educational background;
  • Advanced knowledge of data warehousing principles, technologies and related ETL processes;
  • Previous experience in Oracle Life Sciences Data Hub (LSH) preferred, including advanced knowledge of core functionality of LSH, and familiarity with LSH best practices;
  • Experience using standard templates for data warehouse container structures, along with the ability to manage, create and update templates;
  • Experience in performing ETL tasks and validating results;
  • Experience in the set-up, maintenance and promotion of programs to and from standard libraries;
  • Experience with the tools and utilities for the management of pharmaceutical sponsor proprietary or industry clinical data standards  i.e. sponsor specific or CDISC) is required;
  • Experience with a variety of programming languages including but not limited to PL/SQL, JAVA, SAS, C #;
  • 5+ years hands on experience in programming in SQL and Oracle PL/SQL, using SQL developer, TOAD or similar program development applications for realization of automations and programming activities in a regulated environment;
  • Ability to translate business questions into SQL queries to answer those questions appropriately;
  • Writing PL/SQL programs for accomplishing more complex queries or data modifications;
  • Knowledge of clinical data mapping, transformation and end to end processes;
  • Experience working with clinical data in a relational database;
  • Ability to work in and lead team initiatives, including priority setting and timeline development;
  • Experience in comprehensive software testing, inspections, analyses, and other verification tasks performed at each stage of the software development life cycle is required;
  • Knowledge of CDISC standards for CDASH, SDTM and ADaM;
  • Excellent oral and written communication skills.

 

Preferred Qualifications:

  • Experience in the pharmaceutical or biotechnology industry.

Your application

Bayer offers a wide variety of competitive compensation and benefits programs. If you meet the requirements of this unique opportunity, and you have the "Passion to Innovate" and the "Power to Change", we encourage you to apply now. Job postings will remain open for a minimum of ten business days and are subject to immediate closure thereafter without additional notice. To all recruitment agencies: Bayer does not accept unsolicited third party resumes.

Bayer is an Equal Opportunity Employer/Disabled/Veterans

 

Bayer is committed to providing access and reasonable accommodations in its application process for individuals with disabilities and encourages applicants with disabilities to request any needed accommodation(s) using the contact information below.

 

Country: United States
Location: NJ-Whippany

Job Search

Follow Us

           

Your Application Status

Exciting times!

Bayer has launched a new recruiting system that makes it faster and easier for you to apply.

 

Track your job applications:

 

Jobs published on or after October 19, 2016

ATTENTION
:

Due to system updates, returning candidates will need to re-accept the data privacy statement when logging into their profile.

We apologize for the inconvenience.

Returning Applicants

 

Jobs published before October 19, 2016

Returning Applicants

 

If you require assistance please Contact us

 

Job Fairs & Career Expos

9/14/17

Fall Career Days, Penn State University Main Campus

9/28/17 - 9/29/17

National Black MBAA

10/10/17 - 10/12/17

Out and Equal 2017 Workplace Summit

11/13/17 - 11/15/17

American Association of Pharmaceutical Scientists

Events Overview

Resources

 

Bayer is committed to providing access and reasonable accommodations in its application process for individuals with disabilities and encourages applicants with disabilities to request any needed accommodation(s) using the contact information below.
 

 

EEO is the Law

Pay Transparency

 

 

If you have questions regarding the recruiting process or your application, please visit our FAQ section. 

 

FAQs

 

If you need additional information, click below to contact us directly!

 

Contact Us

 

 

 

Aug 11, 2017   Copyright © Bayer AG
URL: https://career.bayer.us/opencms/opencms/job/Principal-Clinical-Data-Warehouse-Programmer--SF8370.html