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

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.

About the role

This is a hybrid position based in North Chicago, IL, requiring onsite work 3 days a week and 2 days of remote work.

Responsibilities

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

Requirements

Must possess one of the following combinations of education and experience:

• A BS in computer, electronics, or electrical engineering or a related field, plus 5 years of work experience preparing and analyzing data and preparing insights and visualizations in a large, public company. Of the 5 years of required experience, must have:
  • 5 years working with database technologies, SQL and NoSQL databases, PostgreSQL, data quality, and analytics fields.
  • 5 years interpreting and analyzing data and sharing issues and insights by creating reports and dashboards for visualization in Cognos and Power BI.
  • 5 years designing and implementing large data processing, ETL systems, and testing performance of data-driven products using DataStage or Informatica.
  • 5 years creating, defining, and executing rigorous roadmaps for new data analytics projects and aligning data projects with organizational goals using JIRA and Confluence.
  • 5 years managing project stakeholders, business teams, and practicing a business mindset to understand real business issues or requirements using tools like JIRA, SNOW, and Alation.
  • 3 years working in cloud technologies, terminologies, platforms, and AWS services including Redshift.
• Alternatively, a Master’s in computer, electronics, or electrical engineering or a related field, plus 3 years of work experience preparing and analyzing data and preparing insights and visualizations in a large, public company. Of the 3 years of required experience, must have 3 years in each of the above areas (i) through (vi).

With either combination of education and work experience, must also have:

• 2 years ensuring data quality, integrity, security, and governance.
• 1 year designing and implementing large data processing, ETL systems, and testing performance of data-driven products using a combination of Databricks, PySpark, AWS Glue, and Autosys.
• 1 year developing programs for machine learning, automation, and latest analytics using Python or PySpark languages.
• 1 year designing and implementing data frameworks using Data Vault and Medallion architecture.

Work experience may be gained concurrently. Any combination of education, training, and work experience will be accepted.

Pay

$167,336 – $183,500 per year.

Benefits

• Paid time off (vacation, holidays, sick).
• Medical, dental, and vision insurance.
• 401(k) retirement plan.
• Eligibility to participate in short-term and long-term incentive programs.