Oracle Developer

AbbVie Inc; North Chicago (IL); Hybrid; USD 90,000 - 120,000; Full time

Job summary

AbbVie Inc is seeking a Data Engineer to join their Business Technology Solutions team. This hybrid role involves working on the design and development of data pipelines and warehouses crucial for enhancing drug discovery and development processes. The ideal candidate will have a strong background in RDBMS, Python, and data modeling, with a passion for collaborative solution-building in a transformative biopharma environment.

Benefits

Comprehensive benefits package

Paid time off

401(k) eligibility

Participation in incentive programs

Qualifications

• Bachelor’s Degree with 5+ years’ experience; Master’s Degree with 4+ years’ experience.
• Hands-on experience in Data modelling and data warehouse designing.
• Analytical mind with outstanding interpersonal skills.

Responsibilities

• Collaborative design of data solutions with various stakeholders.
• Development of custom solutions and processes for data integration.
• Adaptability to different project responsibilities.

Skills

RDBMS (Oracle and PostgreSQL)

Python

Data warehousing concepts

Data Modelling

Education

Bachelor’s Degree

Tools

Toad

ERWIN

AWS

Spotfire

PowerBI

Job description

Company Description

AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us atwww.abbvie.com. Follow @abbvie onX,Facebook,Instagram,YouTube,LinkedInandTik Tok.

Job Description

Come to work each day with an inclusive and collaborative Business technology team! As aData Engineer in AbbVie Business Technology Solutions (BTS), you’ll 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 AbbVie’s 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 AbbVie’s 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 discoveryand development
• Business Knowledge – Ability to quickly learn and acquire knowledge in Drug Discovery and Drug Development domains

Qualifications

• Bachelor’s Degree with 5+ years’ experience; Master’s 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 ingood faith it will pay for this role at the time of this posting based on the job grade for this position. Individualcompensation paid within this range will depend on many factors including geographic location, and we may ultimatelypay 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/visioninsurance and 401(k) to eligible employees.

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

Note: No amount of payis considered to bewages 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 benefitsthat are allocable to a particular employee remains in the Company's sole and absolute discretion unless and until paid andmay be modified at the Company’s 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, visithttps://www.abbvie.com/join-us/equal-employment-opportunity-employer.html

US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:

https://www.abbvie.com/join-us/reasonable-accommodations.html