Lead Data and Analytics Engineer

AbbVie Inc.; Chicago (IL); Hybrid; USD 150,000 - 210,000; Full time

Job summary

AbbVie in Lake County, IL seeks a Lead Data and Analytics Engineer to design and implement data solutions that transform HR and Corporate Services workflows. You will bridge business needs and technical execution, building prototypes and mentoring the team to deliver measurable ROI.

Hybrid role, on-site Tue-Thu in Lake County; you will work with enterprise tools, data pipelines, vector AI applications, and governance practices to drive efficiency and scale across the organization.

Qualifications

• Bachelor's/Master's/PhD with the specified years of experience.
• Python and SQL proficiency for production-quality pipelines.
• Experience with batch and real-time data pipelines (Spark/Kafka/Flink).
• Cloud data platforms (Azure/AWS/GCP).
• Data modeling, warehousing, data lakes, lakehouse architectures.
• Data quality, observability, lineage, governance and security.
• Airflow, dbt, Prefect experience.
• AI engineering data prep including embeddings and RAG.
• Production-grade software delivery and maintenance.
• Strong analytical and cross-functional collaboration skills.

Responsibilities

• Translate business needs into technical designs delivering efficiency gains.
• Engineer scalable data solutions with production-ready code.
• Prototype MVPs and iterate based on stakeholder feedback.
• Foster cross-team relationships and optimize internal resources.

Skills

Python

SQL

Data engineering

Communication

Problem solving

Education

Bachelor's Degree (7 years)

Master's Degree (6 years)

PhD (2 years)

Tools

Apache Spark

Apache Kafka

Apache Flink

Databricks

Azure

AWS

Google Cloud

dbt

Apache Airflow

Prefect

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, X and YouTube.

Job Description

As aLead Data and Analytics Engineer, you will drive measurable business impact by designing and implementing data solutions that transform how our Corporate Services and HR business partnersoperate.You willserve as the critical bridge between complex business needs and technical execution—deeply understanding current-state processes, translating inefficiencies into innovative automation opportunities, andleveragingenterprise tools to deliver rapid ROI. This role uniquely combines hands-on technical leadership with strategic thinking:you willarchitect end-to-end solutions, build working prototypes, mentortheteam in design thinking and agentic development, and ensure every solution drives tangible efficiency gains and value for stakeholders.

This role reports to the Associate Director, BTS CorporateServiceswithin the Business Technology Solutions department.We set the vision for how data, analytics and AI automation enhance our enterprise systems. We work closely with business partners and technical implementors to bring that vision to life. This is a hybrid role required to be on-site Tuesday through Thursday every week in Lake County, IL.

Responsibilities

• Engage deeply with Corporate Services and HR stakeholders to understand current-state processes, pain points,constraints,to-bebusiness requirements, and success metrics; translate these into technical solution designs that deliver measurable efficiency gains.
• Engineer and implement scalable data engineering solutions;deliveringclean, scalable, production-ready code that integrates with enterprise systems and optimizes business partner workflows.
• Prioritize rapid prototyping and iterative development,building working MVPs quickly tovalidatesolutions with stakeholders, then refining based on feedback to accelerate time-to-value.
• Cultivate cross-team relationships while continuously expanding technical knowledge;identifyingexisting capabilities, shared platforms, and collaborative opportunities that maximize internal resources and drive productivity gains.

Qualifications

Required

• Bachelor's Degree with 7years of experience;Master's Degreewith 6 years of experience; or PhD with 2 years of relevant experience.
• Pythonand SQL proficiencyrequired— expert-level ability to write production-quality code for pipeline automation, LLM enrichment, and enterprise integrations.
• Experience developing batch and real-time data pipelines using technologies such as Apache Spark, Apache Kafka, Apache Flink, Databricks, or equivalent platforms.
• Experience with modern cloud data platforms and services, such as Azure, AWS, or Google Cloud.
• Strong knowledge of data modeling, data warehousing, data lakes, and data lakehouse architectures.
• Experience implementing data quality, observability, lineage, metadata management, governance, and security.
• Familiarity with data orchestration tools like Apache Airflow, dbt, Prefect, etc.
• Experience preparing enterprise data for AI engineering use cases, including embedding and vectorization pipelines, Retrieval-augmented generation and semantic search architectures, Vector databases or vector search capabilities, and generative AI and agentic AI applications.
• Proven ability to deliver andmaintainproduction-grade software in enterprise environments, including ongoing support, monitoring, and iterative improvements.
• Strong analytical, problem-solving, and diagnostic skills withabilityto understand business processes andidentifyautomation opportunities.
• Broad technicalproficiencyacross software development, data integration, cloud platforms, and enterprise systems — withabilityto rapidly learn and applynew technologies.
• Excellent written and oral communication skills, including ability to communicate technical concepts to non-technical stakeholders.
• Operatewith high autonomy and minimal supervision—proactively managing stakeholder expectations and keeping leadership informed through clear, concise verbal and written communication.
• Demonstratedability to mentor technical staff, lead cross-functional teams, and drive initiatives to completion.

Preferred

• Experience in the pharmaceutical industry or other highly regulated environments is preferred.
• Understanding ofSDLC methodologies,GxPcompliance, and validation requirements is preferred.
• Experience in working with international development teams across multiple time zones is preferred.
• Exposure to graph databases and GraphQL a plus.

Additional Information

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state orlocal 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

https://www.abbvie.com/join-us/reasonable-accommodations.html