Database Engineer

Employer
AbbVie
Location
Lake County, IL, US
Posted
Oct 16, 2018
Ref
1807288
Required Education
Bachelors Degree
Position Type
Full time
AbbVie (NYSE:ABBV) is a global, research-based biopharmaceutical company formed in 2013 following separation from Abbott Laboratories. The company's mission is to use its expertise, dedicated people and unique approach to innovation to develop and market advanced therapies that address some of the world's most complex and serious diseases. AbbVie employs approximately 30,000 people worldwide and markets medicines in more than 170 countries.

POSITION DESCRIPTION:

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 Include:

  • 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


BS or MS degree in scientific or engineering

Typically, 4-8 years of pharmaceutical or biotechnological industry experience for BS (2-5 years for MS)

  • 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