Data Engineer - Lilly Medicine Foundry

At Lilly, the work is demanding because patients are waiting. We unite caring with discovery to help make life better for people around the world, knowing that every decision, every detail, and every day matters. Headquartered in Indianapolis, Indiana, our over 50,000 employees around the globe take on complex challenges to discover and deliver life-changing medicines, strengthen how health is understood and managed, and support the communities we serve.

This is hard, urgent, selfless work—but it’s work worth doing. If you’re driven by purpose and ready to bring your best to work that truly matters for patients, we invite you to join us.

Lilly is entering an exciting period of growth, and we are committed to delivering innovative medicines to patients around the world. LRL has increasing needs for in-house manufacture of material for clinical supplies and will therefore construct a new campus to manufacture Clinical Trial (CT) Active Pharmaceutical Ingredient (API) to meet needs for an expanding portfolio (more and new areas), to accelerate development timelines, and to enhance supply chain robustness.

The brand-new facility also known as Lilly Medicine Foundry (LMF) will utilize the latest technology to augment the current clinical supply chain for small molecules (SM), oligonucleotides, peptides, and Antibody Drug Conjugates (ADCs), monoclonal antibodies and bioconjugates, and add new capabilities including mRNA. The new site will be built using the latest high-tech equipment, advanced highly integrated and automated manufacturing systems, and have a focus on minimizing the impact to our environment.

As a Data Engineer based at the Lilly Medicine Foundry, in Lebanon, IN. you will design and build data pipelines for the site. Working closely with the Data Architect and Data Scientists, you'll engage directly with business and operational collaborators to understand how data flows across the Foundry — from lab systems, process engineering, and manufacturing execution to quality and process analytics — and translate that understanding into reliable, scalable data products.

Your core focus will be integrating IT and OT source systems with cloud data Lakehouse architecture spanning AWS and Azure, enabling the advanced analytics and AI/ML capabilities that will define how Foundry operates. This includes the full data value chain: capture, ingestion, integration, contextualization, harmonization, and delivery as reusable data domains and data-as-a-product. You will work across enterprise and edge systems, navigate a diverse technology landscape, and ensure that everything you build meets the data integrity and compliance standards required in a GxP-regulated manufacturing environment.

• Build and deliver high-quality data solutions.:
  You design and develop robust data pipelines for ingestion, transformation, and integration across cloud platforms (AWS and Azure), applying modern patterns such as medallion architecture, streaming ingestion, and API-based extraction. You write clean, maintainable code, optimize for performance, and think carefully about how data flows from source systems into trustworthy, analytics-ready products.
• Translate business needs into technical outcomes. You engage proactively with stakeholders across multiple modalities and business teams including Operations, Quality, Lab, and Engineering to understand their data needs. You're comfortable eliciting requirements, identifying gaps, and translating operational realities into sound technical designs — and explaining your architectural decisions back to a non-technical audience.
• Navigate a diverse enterprise landscape:
  The Foundry operates within a broader Lilly ecosystem of enterprise systems including ERP, ELN, MES, LIMS, Historians, PLM, and QMS platforms. You invest time in understanding upstream and downstream dependencies, seek opportunities to reuse existing services and integrations, and build with the broader data architecture in mind.
• Ensure compliance:
  You understand the data integrity requirements of a GxP manufacturing environment and…