Oracle Developer

Come to work each day with an inclusive and collaborative Business technology team! As a Data Engineer in AbbVie Business Technology Solutions (BTS) youll have opportunities to contribute to the digital transformation of a leading biopharma company helping to create solutions that impact patients and their communities for the better.

***This is a hybrid role based in Lake County IL***

The Global Research Informatics and Platform Solutions (GRIPS) 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.

Data Engineer is a critical technical role for AbbVie within the GRIPS department. This position provides a combination of thought leadership and execution in the ongoing design development and delivery of AbbVies Discovery DevSci and Preclinical Development data warehouses.  This position provides tactical IT leadership to achieve business and enterprise operating objectives including support of key business solutions in the preclinical space.  Key responsibilities include technical stewardship for AbbVies R&D data warehouses data pipelines development. Provide solutions to performance related issues and work with downstream systems to support data driven demands.  Escalate open issues to ensure execution success and keep stakeholders informed through effective verbal and written communication. Responsible for modifying existing software to correct errors and/or improve performance.

Responsibilities

• 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 data engineers develop custom solutions/processes that contribute to and help foster the growing AbbVie data integration environment
• Adaptability given our diverse mission you should be able to move fluidly between different project responsibilities
• Breadth as a talented and motivated Data Engineer you can contribute to a wide variety of missions related to enhancing drug discovery and development
• Business Knowledge Ability to quickly learn and acquire knowledge in Drug Discovery and Drug Development domains

Qualifications :

• Bachelors Degree with 5 years experience; Masters Degree with 4 years experience.
• 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
• Hands-on experience in Data modelling and data warehouse designing.
• Have the necessary skills experience to both design and develop ETLs in PL/SQL (using materialized views packages procedures triggers functions etc.)
• Experience in advanced analytical SQL and performance tuning SQL queries in Oracle are required.
• Experience using latest features in Oracle including but not limited to JSON and XML data processing.
• Experience using Python for file processing and orchestrating data pipelines.
• Experience replicating data from other databases (MySQL/MS SQL Server/Hadoop) to Oracle is desired.
• Experience with version controlling tools like Git and GitHub
• Experience with DevOps and CICD pipelines is a plus
• Dedicated team player who can interface with stakeholders from a variety of internal IT disciplines (infrastructure DBAs architects data scientists etc.)
• An analytical mind with outstanding interpersonal verbal and written communication skills

Skill Set

• RDBMS (Oracle and PostgreSQL) Python
• Familiarity with emerging technologies and a passion for continuous learning.
• Experience with Data warehousing concepts building warehouses in Oracle PostgreSQL
• Experience with Data Modelling and tools like Toad ERWIN
• Experience with cloud environments with more specifically in AWS Airflow NoSQL GraphQL (nice to have)
• Experience with visualization tools like Spotfire Qlik PowerBI (nice to have) 
• Hive/Impala experience (nice to have)

Additional Information :

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: 

• The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at the time of this posting based on the job grade for this position. Individual compensation paid within this range will depend on many factors including geographic location and we may ultimately pay more or less than the posted range. This range may be modified in the future.

• We offer a comprehensive package of benefits including paid time off (vacation holidays sick) medical/dental/vision insurance and 401(k) to eligible employees.

• This job is eligible to participate in our short-term incentive programs. 

Note: No amount of pay is considered to be wages or compensation until such amount is earned vested and determinable. The amount and availability of any bonus commission incentive benefits or any other form of compensation and benefits that are allocable to a particular employee remains in the Companys sole and absolute discretion unless and until paid and may be modified at the Companys sole and absolute discretion consistent with applicable law. 

AbbVie is an equal opportunity employer and is committed to operating with integrity driving innovation transforming lives and serving our community. Equal Opportunity Employer/Veterans/Disabled. 

US & Puerto Rico only - to learn more visit  & Puerto Rico applicants seeking a reasonable accommodation click here to learn more:

Work :

No