Senior Engineer, Technology II (Data Engineering & Architecture)

AbbVie; Illinois; On-site; USD 150,000 - 210,000; Full time

Benefits offered by this job

Paid time off

Medical/dental/vision insurance

401(k) plan

Long-term incentive programs

Job summary

AbbVie seeks a Sr. Data Engineer & Solution Architect to lead cloud-native data lakehouse initiatives across Operations. You will design and implement scalable data pipelines using AWS Glue, S3, EMR, and Redshift, applying Medallion Architecture and data mesh principles.

You'll partner with Supply Chain stakeholders to deliver governance, data products, and analytics dashboards, while supervising a data engineering team and driving engineering excellence in a regulated enterprise.

Qualifications

• 7+ years of experience in data architecture and data engineering.
• Hands-on with AWS Glue, Amazon S3, AWS EMR and related ingestion/transform technologies like Informatica.
• Experience with Apache Iceberg open table format or similar for lakehouse architecture.
• Proficiency with AWS Redshift for enterprise data warehousing.
• Experience designing Medallion Architecture and data product frameworks; familiarity with data mesh.

Responsibilities

• Design, develop, implement, and oversee legacy ETL and cloud-native data ingestion frameworks and end-to-end data pipelines using AWS services (Glue, S3, EMR, Lambda) and Informatica.
• Solution architect data needs for Operations Supply Chain analytics using Apache Iceberg and Medallion Architecture to ensure data quality, lineage, and accessibility.
• Build, optimize, and maintain AWS Redshift data warehouse solutions for Supply Chain analytics, designing data products aligned to analytics consumption patterns.
• Promote data product-centric architecture and data mesh principles across domains; establish standards for data product design, ownership, discoverability, and interoperability.
• Partner with SAP and planning domain teams to translate ERP data structures into governed analytics-ready data products in the lakehouse platform.
• Lead the data engineering team, supervise members, and cultivate engineering excellence and continuous improvement.

Skills

AWS Glue

AWS Redshift

Apache Spark / PySpark

Python

SQL

Data Mesh

Medallion Architecture

Data governance

ETL design

Education

Bachelor’s Degree in CS/IS/Data Engineering or related field

Master’s Degree (optional)

Tools

Informatica

Amazon S3

AWS EMR

Apache Iceberg

Alation Data Catalog

Job description

About AbbVie

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 including immunology, oncology, and neuroscience – and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on LinkedIn, Facebook, Instagram, X and YouTube.

The Sr. Data Engineer & Solution Architect serves as the principal designer for Operations Data organization, with a focus on cloud‑native datalakehouse architecture, advanced data engineering, and Supply Chain data domains. This role is responsible for conceiving, designing, and implementing scalable, high‑performance data solutions leveraging modern AWS Database & Analytics services, Apache Iceberg open table format, AWS Redshift, and Medallion Architecture principles. The Sr. Data Engineer & Solution Architect will drive data product‑centric thinking and data mesh principles for the organization, partnering closely with Supply Chain functional and business stakeholders to deliver trusted, governed, and actionable data and dashboards across Supply Chain domains. This role requires a deep combination of hands‑on technical expertise, solution architecture, and the ability to communicate complex data strategies to both technical teams and cross‑functional stakeholders.

Responsibilities

• Design, develop, implement, and oversee legacy ETL and cloud‑native data ingestion frameworks and end‑to‑end data pipelines leveraging AWS services including AWS Glue, Amazon S3, AWS EMR, AWS Lambda, and other ingestion/ETL technologies like Informatica; assess information needs and data flows to engineer scalable, reliable, and cost‑effective solutions.
• Solution architect data needs for the Operations Supply Chain analytical use cases using Apache Iceberg open table format, implementing Medallion Architecture to ensure data quality, lineage, and accessibility.
• Build, optimize, and maintain AWS Redshift data warehouse solutions for Supply Chain analytical use cases, including the design of data products leveraging AWS Redshift aligned to enterprise analytics consumption patterns.
• Define, promote, and implement data product‑centric architecture and data mesh principles from business domains; establish standards for data product design, ownership, discoverability, and interoperability to enable all analytical dashboards and AI use cases.
• Partner with Supply Chain BTS (IT) functional and business stakeholders to understand and model critical data flows across from SAP and planning system processes; translate complex ERP data structures into governed, analytics‑ready data products within the lakehouse platform.
• Lead consultant technical data engineering team responsible for building the solutions; supervise team members as needed, remain accountable for team delivery and performance, and cultivate a culture of engineering excellence and continuous improvement.

Required

• Bachelor’s Degree in Computer Science, Information Systems, Data Engineering, or a related field with 7+ years of experience in data architecture and data engineering; or Master’s Degree with 6 years’ experience; or PhD with 2 years of experience.
• Deep, hands‑on expertise with modern AWS Database & Analytics services including AWS Glue, Amazon S3, AWS EMR and related ingestion and transformation technologies like Informatica.
• Demonstrated hands‑on experience with Apache Iceberg open table format or similar technologies for lakehouse architecture.
• Proficiency with AWS Redshift for enterprise data warehousing or similar modern data warehousing platforms.
• Proven experience designing and implementing Medallion Architecture (Bronze/Silver/Gold layers) and data product frameworks; familiarity with data mesh principles including domain ownership and data product thinking.
• Familiarity with Supply Chain ERP systems, specifically SAP, and working knowledge of core Supply Chain data flows and data domains.
• Familiarity with Blue Yonder (formerly JDA) planning domain covering demand planning, supply planning, etc., including understanding of the underlying data models and integration patterns with enterprise data platforms.
• Strong programming and query skills in ETL, SQL, Python, and Apache Spark/PySpark for large‑scale data transformation, processing, and pipeline development.
• Solid knowledge of data governance frameworks, data cataloging using Alation or AWS Glue Data Catalog, metadata management, data lineage, and data quality practices; experience implementing enterprise‑wide data governance policies and controls.
• Demonstrated ability to analyze complex business requirements, evaluate technical options, and deliver efficient, scalable, and cost‑effective data solutions; proven experience operating with a high degree of autonomy in enterprise or regulated IT environments, balancing technical depth, architecture leadership, and senior stakeholder engagement.

Preferred

• Knowledge of reporting tools such as PowerBI is a plus for the role.

Compensation & Benefits

• 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 long‑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 Company’s sole and absolute discretion unless and until paid, and may 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, visit https://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