Database Engineer II (Oracle Developer)

Lake County, IL, US
Dec 12, 2018
Required Education
Bachelors Degree
Position Type
Full time
The Data Solutions Department within the Information Research (IR) Division is building the next generation of data management and decision support tools and services to optimize the efficiency and efficacy of research and development at AbbVie.

The Database Engineer is a critical technical role for AbbVie within the Data Solutions department. This position provides a combination of thought leadership and execution in the ongoing design, development and delivery of AbbVie's Discovery and Preclinical Development data warehouses. This position provides the tactical IT leadership to achieve business and enterprise operating objectives, including support of key business solutions in the preclinical space. Key responsibilities include the technical stewardship for AbbVie's preclinical data warehouses, PL/SQL development and providing oracle leadership within Data Solutions.

Key Responsibilities
  • Business Knowledge - knowledge in Drug Discovery or Drug Development is important
  • Collaborative Design - you should find it inspiring to work with a wide variety of colleagues (e.g., data scientists, developers, scientists); understand their needs and then propose and build solutions
  • Build - through your own efforts and by working with other database engineers, develop custom solutions/processes that contribute to and help foster the growing AbbVie data integration environment
  • Presentation - use your strong computational and data visualization skills to bring together disparate data types in compelling visualization packages that provide end users with the ability to see both 'the landscape' and details leading to improved decision-making
  • Adaptability - given our diverse mission you should be able to move fluidly between different project responsibilities
  • Breadth - as a talented and motivated Database Engineer, you can contribute to a wide variety of missions related to enhancing drug discovery and development

Database Engineer II:

BS or MS degree in biological sciences or quantitative sciences (mathematics, physics, statistics, Engineering or computer science)
Typically, 5+ years of pharmaceutical or biotechnological industry experience for MS (8+ years for BS)

  • Working knowledge of the drug discovery and/or drug development process is desired
  • Responsible for having a concise understanding of the end to end operational data warehouses, including system integrations, data quality and harmonization rules, as well as an understanding of downstream information consumption
  • Have the necessary skills and experience to both design and develop of ETLs (materialized views, packages, procedures, triggers, functions, etc.)
  • Demonstrated expertise using Oracle 12c
  • Dedicated team player who can interface with stakeholders from a variety of internal IT disciplines (infrastructure, DBAs, architects, etc.)
  • Proficient in Unix shell scripting
  • A self-motivated learner and thinker with a hands-on approach
  • An analytical mind with outstanding interpersonal, verbal and written communication skills

Equal Opportunity Employer Minorities/Women/Veterans/Disabled