Senior Engineer, Technology II (Data Engineering & Architecture)

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

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 atwww.abbvie.com. Follow @abbvie onLinkedIn,Facebook,Instagram,XandYouTube.

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 including immunology, oncology, and neuroscience - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us atwww.abbvie.com. Follow @abbvie onLinkedIn,Facebook,Instagram,XandYouTube.

Job Description

TheSr.Data Engineer &Solution Architectserves as the principal designer forOperationsDataorganization, with a focus on cloud-native datalakehousearchitecture, advanced data engineering, and Supply Chain data domains. This roleis responsible forconceiving, designing, and implementing scalable, high-performance data solutionsleveragingmodern AWSDatabase &Analytics services, Apache Iceberg open table format, AWS Redshift, and Medallion Architecture principles. TheSr.Data Engineer & Solution Architectwill drive Data Product-centric thinking and data mesh principlesforthe organization, partnering closely with Supply Chainfunctional andbusiness stakeholders to deliver trusted, governed, and actionable dataand dashboardsacrossfromSupply Chaindomains. This role requires a deep combination of hands-on technicalexpertise, solution architecture, and the ability to communicate complex data strategies to both technical teams andcross functionalstakeholders.

Responsibilities

• Design, develop,implementand overseelegacy ETLand cloud-native data ingestion frameworks and end-to-end data pipelines leveraging AWS services including AWSGlue, AmazonS3, AWS EMR, AWS Lambda, and other ingestion/ ETLtechnologieslike Informatica; assess information needs and data flows to engineer scalable, reliable, and cost-effective solutions.
• Solutionarchitect data need forthe Operations Supply Chainanalyticaluse casesusing Apache Iceberg open table format, implementing Medallion Architecture to ensuringdata quality, lineage, and accessibility.
• Build,optimize, andmaintainAWS Redshift data warehouse solutionsfor Supply Chainanalyticaluse cases, including the design of data productsleveragingAWSRedshift aligned to enterprise analytics consumption patterns.
• Define, promote, and implement Data Product-centric architecture and data mesh principlesfrombusiness domains;establishstandards for data product design, ownership, discoverability, and interoperability to enableallanalyticalDashboardsand AI use cases.
• Partner with Supply ChainBTS(IT)functional andbusinessstakeholders tounderstand and model critical data flows acrossfromSAPandplanning systemsprocesses; translate complex ERP data structures into governed, analytics-ready data products within thelakehouseplatform.
• Leadconsultanttechnical data engineering team responsible for buildingthe solutions; supervise team members as needed, remain accountable for team delivery and performance, and cultivate a culture of engineering excellence and continuous improvement.

Qualifications

Required:

• Bachelors Degree in Computer Science, Information Systems, Data Engineering, or a related field with 7+ years of experience in data architectureanddata engineering;Master's Degreewith 6 years' experience; or PhD with 2 years of experience.
• Deep, hands-onexpertisewith modern AWS Database& Analytics services including AWS Glue, Amazon S3, AWS EMR and related ingestion and transformation technologieslike Informatica.
• Demonstrated hands-on experience with ApacheIcebergopen table formator similar technologiesforlakehousearchitecture.
• Proficiencywith AWS Redshift for enterprise data warehousingor similar Modern data warehousingplatforms.
• Proven experience designing and implementing Medallion Architecture (Bronze/Silver/Gold layers) and Data Product frameworks; familiarity with data mesh principles including domain ownership, data product thinking.
• Familiarity with Supply Chain ERP systems, specifically SAP, and working knowledge of core Supply Chain data flowsanddata domains.
• Familiarity withBlue Yonder (formerly JDA) planningdomaincovering demand planning, supplyplanningetc.including understanding of the underlying data models and integration patterns with enterprise data platforms.
• Strong programming and query skills inETL,SQL, Python, and Apache Spark/PySparkfor large-scale data transformation, processing, and pipeline development.
• Solid knowledge of data governance frameworks, data cataloging usingAlation orAWS 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; provenexperienceoperatingwith 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 asPowerBIetc. is a plus for the role.

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 Companybelieves ingood faith it will pay for this role at the timeof this posting based on the job grade for this position.Individualcompensation paid within this range will depend on many factors including geographic location, andwemayultimatelypaymore or less than the posted range. This range may bemodifiedin thefuture.
• We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick),medical/dental/visioninsurance and 401(k) to eligibleemployees.
• This job is eligible toparticipatein our long-term incentiveprograms.

Note: No amount of payis considered to bewages or compensation until such amount is earned, vested, anddeterminable.The amount and availability of any bonus,commission, incentive, benefits, or any other form ofcompensation and benefitsthat are allocable to a particular employeeremainsin the Company's sole andabsolutediscretion unless and until paid andmay bemodifiedat the Companys sole and absolute discretion, consistent withapplicable 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