Business Insights & Analytics Data Engineering Intern

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.

Organization Overview

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.

Functional Overview & Responsibilities

You will join a growing and dynamic team of data engineering professionals within Business Insights & Analytics whose main goal is to build the governed data pipelines and platforms that power marketing, sales, finance, and leadership decision-making across Lilly — increasingly through agentic AI systems, not just static dashboards. BI&A is building toward a future where AI agents query governed data products directly to answer business questions and, in some cases, trigger action — which means data engineering is feeding decisions made in real time. As a Data Engineering Intern, you will develop understanding of Lilly’s data platforms (Databricks, Unity Catalog), build and support production data pipelines, and contribute to the automation and governance practices that make data products reliable, fresh, and AI-ready. Project scope will be provided by your Lilly Intern supervisor and aligned to your interests and background.

Responsibilities:

Develop understanding of BI&A’s data platforms, pipeline architecture, and the data sources feeding brand/business unit analytics Build and support data pipeline components under the guidance of senior engineers — ingestion, transformation, and validation logic on Databricks/Delta Lake Write and maintain SQL and Python for data extraction, cleaning, and transformation tasks (project scope aligned to intern’s interests and background) Contribute to data quality and testing practices — writing test cases, validating pipeline outputs against expected results Assist with documentation of data pipelines, schemas, and data lineage — the metadata that lets both people and AI agents trust what they’re querying Support work to make data products “AI-ready”: tracking freshness SLAs, lineage, and quality metrics so downstream agentic systems (e.g., BI&A’s NL2SQL agent platform) can safely consume the data they need to answer questions or act on them Gain exposure to how pipeline design choices — batch vs. streaming, refresh cadence, latency — determine whether a data product can support real-time decision-making versus next-day reporting Proactively partner across BI&A engineering teams for shared learning and to elevate engineering practice Ensure compliance with all privacy, governance, and contractual obligations related to the use of data