Senior Engineer, Technology II (Data Engineering & Architecture)

BioSpace; North Chicago (IL); On-site; USD 150,000 - 200,000; Full time

Benefits offered by this job

Medical/dental/vision insurance

401(k) matching

Paid time off

Job summary

AbbVie seeks a Senior Data Engineer & Solution Architect to lead the Operations Data organization, shaping a cloud-native lakehouse for Supply Chain analytics. You will design end-to-end data pipelines on AWS, define data products, and embody data mesh principles across SAP and planning domains.

You will collaborate with business stakeholders and lead a data engineering team to deliver scalable, governed data and dashboards that empower analytics and AI use cases across the Supply Chain.

Qualifications

• 7+ years in data architecture and data engineering; advanced degree options.
• Hands-on with AWS Glue, Amazon S3, AWS EMR and related ingestion/transformation techs like Informatica.
• Experience with Apache Iceberg and lakehouse architectures.
• Proficiency with AWS Redshift or modern data warehousing platforms.
• Familiarity with Medallion Architecture and data mesh concepts.
• Strong Python, SQL, Spark/PySpark skills.
• Data governance, cataloging, lineage, quality practices.

Responsibilities

• Design, build, and maintain legacy ETL and cloud-native data pipelines on AWS.
• Architect data needs for Operations Supply Chain analytics using Iceberg and Medallion.
• Develop Redshift data warehouses for Supply Chain analytics.
• Define data product architecture and data mesh standards.
• Collaborate with SAP and planning systems to model critical data flows.
• Lead and mentor the data engineering team; drive delivery and excellence.

Skills

Data engineering

Python

SQL

ETL

Spark/PySpark

Data governance

Analytical thinking

Communication

Education

Bachelor's degree in CS/IS/Data Engineering

Master's degree

PhD

Tools

AWS Glue

Amazon S3

AWS EMR

Informatica

Apache Iceberg

AWS Redshift

Medallion Architecture

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.

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.

• 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 delivery 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

• 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. Individual compensation 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, visithttps://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