Senior Data and Analytics Engineer

AbbVie Inc.; Chicago (IL); On-site; USD 150,000 - 190,000; Full time

Job summary

AbbVie in Chicago, IL seeks a Senior Data and Analytics Engineer to translate complex data requirements into scalable analytics and data-engineering solutions for the Operations (Supply Chain) organization. You will partner with DATA, BTS, and business stakeholders to design, build, and deliver modern data products, pipelines, and governance in line with enterprise standards.

Responsibilities include batch and streaming pipelines, lakehouse architectures, data mesh concepts, and strong focus on

Qualifications

• Bachelor's degree in CS/IS/Data Eng or related field with significant hands-on experience.
• Proven experience designing and delivering enterprise data warehouse/lakehouse and analytics solutions.
• Strong SQL and Python with PySpark/Scala in distributed frameworks.
• Experience with S3, Iceberg/Open table formats, AWS Glue, EMR, Redshift/Spectrum.
• Knowledge of medallion architecture, data modeling, partitioning, and performance tuning.
• Experience building production-grade batch and streaming pipelines with orchestration and observability.
• Experience with Airflow or similar orchestration tools and CI/CD practices.
• Ability to deliver AI-ready data products for BI, self-service analytics, data science, and ML.

Responsibilities

• Design, develop, test, deploy, and support data pipelines and data products across structured, semi-structured, and unstructured data.
• Implement lakehouse/modern data warehouse architectures and optimize performance and costs.
• Translate business domains into governed data products with contracts, ownership, and lineage.
• Engineer reliable data ingestion from applications, DBs, files, APIs, and event streams; build orchestrations with Airflow or Step Functions.
• Embed data quality, security, and governance aligned with AbbVie standards.
• Lead technical deliverables through lifecycle with risk management and stakeholder communication.
• Collaborate with DATA, BTS, and Operations stakeholders to align with roadmap and governance.

Skills

SQL

Python

PySpark

Scala

Distributed data processing

Data modeling

CI/CD

Apache Airflow

dbt

ETL

Education

Bachelor's Degree in Computer Science/Information Systems/Data Engineering

Master's Degree

PhD (plus 2 years)

Tools

AWS (S3, EMR, Redshift)

Apache Iceberg

AWS Glue Data Catalog

Apache Spark

dbt

Airflow

Kinesis

IAM/Security tools

Job description

Company 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,XandYouTube.

Job Description

The Senior Data and Analytics Engineer will be responsible for translating complex business and data requirements into scalable, secure, and high-performing analytics and data engineering solutions for the Operations (Supply Chain) organization. The role will partner closely with internal DATA (Data, AI, Transformation and Automation) teams, and cross functional Business Technology Solutions (BTS), business stakeholders, architects, and delivery teams to understand strategic priorities and design, build, and deliver modern data solutions that enables analytics, business intelligence, and AI use cases.

This role requires a strong combination of hands-on technical expertise and strategic thinking, understanding the North Star platform architecture to implement practical engineering solutions while ensuring alignment with enterprise architecture, development standards, data governance, security, and engineering best practices.

The individual will also provide technical leadership throughout the solution lifecycle, proactively manage technical risks and dependencies, and communicate effectively with both technical and business stakeholders.

Responsibilities

• Hands-on engineering and solution delivery: Design, develop, test, deploy, and support production-grade data pipelines and data products for structured, semi-structured, and unstructured data. Build for both batch and near-real-time/streaming patterns, with reusable components, parameterized frameworks, and automated recovery.
• Lakehouse and modern data warehouse architecture: Implement solutions using Amazon S3, Apache Iceberg/open table formats, AWS Glue Data Catalog, Amazon EMR/Spark, Amazon Redshift and Redshift Spectrum. Apply medallion patterns (Bronze, Silver, Gold), dimensional and domain-oriented modeling, workload isolation, partitioning, clustering/sort strategies, and performance optimization.
• Data product and data mesh enablement: Translate business domains into discoverable, interoperable, and governed data products. Define product contracts, ownership, metadata, quality expectations, service-level objectives, lineage, and approved consumption patterns for dashboards, self-service analytics, APIs, data science, and AI.
• Ingestion and orchestration: Engineer reliable ingestion from enterprise applications, databases, files, APIs, and event streams. Develop orchestration using tools such as Apache Airflow, dbt, AWS Step Functions or equivalent approved platforms, with dependency management, idempotency, observability, alerting, and backfill capability.
• Data quality, governance, and security: Embed automated data-quality controls, reconciliation, schema validation, lineage, cataloging, retention, encryption, least-privilege access, and auditability. Partner with data governance, security, privacy, architecture, and platform teams to meet AbbVie standards and regulated-industry expectations.
• DevSecOps and engineering excellence: Establish source-control, code-review, automated testing, CI/CD, infrastructure-as-code, environment promotion, release management, and operational monitoring practices. Improve reliability, cost, performance, and developer productivity through measurable engineering standards.
• Business partnership and technical leadership: Understands organization's vision, goals, and strategies and partner with DATA, BTS, Operations stakeholders to translate complex requirements into scalable designs. Provide technical direction, resolve design and delivery issues, communicate risks and trade-offs, and contribute to portfolio prioritization and roadmap decisions.
• Operational ownership: Own solutions through the full lifecycle, including production readiness, deployment, support transition, incident resolution, root-cause analysis, technical debt reduction, and continuous improvement. Work with minimal oversight while escalating material risks early.

Qualifications

Required:

• Bachelor’s Degree in Computer Science, Information Systems, Data Engineering, or a related field plus 7 years of relevant experience; Master's Degree plus 6 years of experience; PhD plus 2years of experience.
• Respective years of hands-on experience designing and delivering enterprise modern data warehouse, Lakehouse, data engineering, and analytical solutions.
• Advanced proficiency in SQL and Python, with strong hands-on experience in PySpark or Scala and distributed data processing on Apache Spark/EMR or a comparable platform.
• Demonstrated experience building large Lakehouse and modern warehouse solutions using Amazon S3, Apache Iceberg or comparable open table formats, AWS Glue, Amazon EMR, Amazon Redshift, and Redshift Spectrum.
• Proven experience with medallion architecture, data modeling, schema design, incremental processing, change data capture, partitioning, performance tuning, and cost optimization.
• Experience developing production-grade batch and streaming data pipelines, including orchestration, retries, backfills, observability, alerting, and operational support.
• Hands‑on experience with data transformation and orchestration tools such as Apache Airflow, AWS Step Functions or approved equivalents.
• Experience implementing CI/CD, automated testing, Git-based development, infrastructure-as-code, and Agile DevOps delivery practices.
• Demonstrated ability to build governed, AI-ready data products that support BI, self-service analytics, data science, machine learning, and contextual AI consumption.
• Strong analytical, problem-solving, communication, and stakeholder‑management skills, with the ability to work effectively across technical and business teams in a matrixed organization.
• Experience with data catalogs, lineage, and governance platforms such as Alation, AWS Glue Data Catalog, or approved equivalents.

Preferred:

• Supply Chain or Operations domain knowledge across planning, sourcing, inventory, manufacturing, logistics, or distribution.
• Experience with streaming technologies such as Amazon Kinesis, Apache Kafka, Spark Structured Streaming, or equivalent platforms.
• Working experience with AWS Lake Formation, IAM, Secrets Manager, CloudWatch, CloudTrail, and enterprise controls for secure data platforms.
• Experience exposing data through APIs, semantic models, governed data services, or feature/context layers for AI-enabled applications.
• Relevant cloud or data engineering certifications are beneficial but not required.
• 5+ years of hands‑on experience designing and delivering enterprise modern data warehouse, Lakehouse, data engineering, and analytical solutions.

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 Company’s 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