Senior Engineer, Technology II; Data Engineering & Architecture

Company Description

About Abb Vie:
Abb Vie'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 Abb Vie, please visit us at  Follow @abbvie on Linked In, Facebook, Instagram, X and You Tube.

The Sr. Data Engineer & Solution Architect serves as the principal designer for Operations Data organization, with a focus on cloud-native data lakehouse 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 from 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.

• 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 ensuring 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 systems 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;
  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, data product thinking.
• Familiarity with Supply Chain ERP systems, specifically SAP, and working knowledge of core Supply Chain data flows and data domains.
• Familiarity…