Senior Data Engineer II (Operational Business Insights – Quality Data Engineer)

AbbVie; North Chicago (IL); Hybrid; USD 167,000 - 184,000; Full time

Benefits offered by this job

Paid time off

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Job summary

AbbVie North Chicago is seeking a Senior Data Engineer II to design and build scalable data solutions for Operational Business Insights – Quality Data Engineer. Hybrid work arrangement combines onsite collaboration with two days remote work.

The role requires 5 years in data analysis, ETL design, and data governance, with experience across SQL/NoSQL, Cognos/PowerBI visualization, and cloud AWS services including Redshift.

Qualifications

• BS in computer, electronics or electrical engineering or related field.
• 5 years of work experience preparing & analyzing data & preparing insights & visualizations in a large, public company.
• Experience with Database Technologies, SQL & NoSQL databases, PostgreSQL, data quality & analytics.
• Experience creating reports & dashboards for visualization in Cognos & PowerBI.
• Experience designing ETL systems & testing performance of data-driven products using DataStage or Informatica.
• Knowledge of JIRA, Confluence, SNOW & Alation for project management & data governance.

Responsibilities

• Design & develop scalable data solutions & platforms for efficient data processing & presentation.
• Collaborate with cross-functional teams including data engineers, reporting teams & data scientists to understand data requirements & optimize loading processes.
• Build & optimize secure endpoints to facilitate data access across diverse applications & source systems.
• Implement data governance, security measures & performance optimizations for data integrity & quick access.
• Provide technical leadership & stay updated with emerging technologies to drive data integration & innovation.

Skills

SQL knowledge

Data analysis

Cross-functional collaboration

Leadership

Education

BS in computer, electronics or electrical engineering or related field

Masters in computer, electronics or electrical engineering or related field

Tools

Databricks

PySpark

AWS Glue

Autosys

Data Vault

Medallion architecture

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 at www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok.

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 at www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok.

Job Description

Senior Data Engineer II (Operational Business Insights – Quality Data Engineer), AbbVie Inc., North Chicago, IL. Hybrid (onsite 3 days a week & 2 days WFH).

Key Responsibilities

• Design & develop scalable data solutions & platforms for efficient data processing & presentation.
• Collaborate with cross-functional teams, including data engineers, reporting teams, & data scientists, to understand data requirements & optimize loading processes.
• Build & optimize secure endpoints to facilitate data access, retrieval, & integration across diverse applications & source systems.
• Implement data governance, security measures, & performance optimizations to ensure data integrity & quick, accurate access.
• Provide technical leadership, stay updated with emerging technologies, & collaborate to address data integration challenges & drive innovation.

Qualifications

Education & Experience

Must possess a BS in computer, electronics or electrical engineering or related field & 5 years of work experience preparing & analyzing data & preparing insights & visualizations in a large, public company.

Of experience required, must have 5 years:

• working with Database Technologies, SQL & NoSQL databases, PostgreSQL, data quality & analytics fields;
• interpreting & analyzing data & sharing issues & insights by creating reports & dashboards for visualization in Cognos & Power/BI;
• designing & implementing large data processing, ETL systems, & testing performance of data-driven products using DataStage or Informatica;
• creating, defining, & executing rigorous roadmaps for new data analytics projects & aligning data projects with organizational goals using JIRA & Confluence; &
• managing project stakeholders, business teams, & practicing a business mindset to understand real business issues or requirements using tools like JIRA, SNOW & Alation.

Must also have (vi) 3 years of experience working in cloud technologies, terminologies, platforms, & AWS services including Redshift.

Alternatively, would accept Masters in computer, electronics or electrical engineering or related field & 3 years of work experience preparing & analyzing data & preparing insights & visualizations in a large, public company.

Of experience required, must have 3 years’ experience in each of (i), (ii), (iii), (iv), (v), & (vi).

With either combination of education & work experience, must have 2 years ensuring data quality, integrity, security & governance & 1 year in each of the following:

• designing & implementing large data processing, ETL systems, & testing performance of data-driven products using a combination of Databricks, PySpark, AWS Glue, & Autosys;
• developing programs for machine learning, automation, & latest analytics using Python, or PySpark languages; &
• designing & implementing data frameworks using Data Vault, & Medallion architecture.

Work experience may be gained concurrently. Will accept any combination of education, training & work experience.

Additional Information

Salary Range: $167,336 - $183,500 per year.

Benefits

• paid time off (vacation, holidays, sick)
• medical/dental/vision insurance
• 401(k) to eligible employees
• short-term and long-term incentive programs

AbbVie is committed to operating with integrity, driving innovation, transforming lives, serving our community, and embracing diversity and inclusion. It is AbbVie’s policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.

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.