Senior Data Engineer & Solution Architect - Cloud Lakehouse

BioSpace; North Chicago (IL); On-site; USD 140,000 - 190,000; Full time

Job summary

AbbVie seeks a Sr. Data Engineer & Solution Architect to lead cloud-native data lakehouse design for Operations Data, focusing on AWS services, Apache Iceberg, and Medallion Architecture.

You will drive data product thinking and data governance across Supply Chain domains, partnering with business stakeholders to deliver trusted dashboards and analytics. Role combines hands-on engineering, architecture leadership, and cross-functional communication to enable scalable, governance-driven data

Qualifications

• Bachelor degree with 7+ years of experience in data architecture and data engineering; Master’s 6 years; PhD 2 years of experience.
• Hands-on with AWS database & analytics services including AWS Glue, Amazon S3, AWS EMR; related ingestion & transformation tech like Informatica.
• Experience with Apache Iceberg or similar lakehouse tech.
• Proficiency with AWS Redshift for enterprise data warehousing or similar platforms.
• Knowledge of Medallion Architecture (Bronze/Silver/Gold) and data product frameworks; familiarity with data mesh concepts.
• Familiarity with SAP and other supply chain ERP data flows and domains.
• Strong programming and query skills in ETL, SQL, Python, and Spark/PySpark for large-scale data pipelines.
• Experience with data governance, cataloging (Alation or Glue Data Catalog), metadata, lineage, and quality controls.

Responsibilities

• Design, develop, implement and oversee legacy ETL and cloud-native data ingestion pipelines using AWS services (Glue, S3, EMR, Lambda).
• Architect data solutions for Operations Supply Chain analytical use cases using Apache Iceberg and Medallion Architecture.
• Build and maintain AWS Redshift data warehouses for supply chain analytics and data products.
• Promote Data Product-centric architecture and data mesh principles across businesses and data domains.
• Collaborate with SAP and planning systems to model critical data flows into governed data products.
• Lead and mentor a data engineering team, ensuring delivery quality and engineering excellence.

Skills

Python

SQL

Spark/PySpark

ETL

Data Governance

Data Mesh

Medallion Architecture

AWS

Stakeholder Management

Education

Bachelor's degree in CS/IS/Data Eng

Master's degree in CS/IS/Data Eng

PhD (with 2+ years)

Tools

AWS Glue

Amazon S3

AWS EMR

Informatica

Apache Iceberg

AWS Redshift

Alation

Job description

AbbVie seeks a Sr. Data Engineer & Solution Architect to lead cloud-native data lakehouse design for Operations Data, focusing on AWS services, Apache Iceberg, and Medallion Architecture.

You will drive data product thinking and data governance across Supply Chain domains, partnering with business stakeholders to deliver trusted dashboards and analytics. Role combines hands-on engineering, architecture leadership, and cross-functional communication to enable scalable, governance-driven data