Data Engineer

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 Summary The CMC Portfolio Analytics & Insights (PAI) team is an integral part of CMC Project Management within Lilly Research Laboratories’ Product Research and Development organization. The CMC Project Management team is responsible for leading the design and execution of integrated CMC strategies from portfolio entry through global submissions and approvals. The PAI is a newly established, strategic team dedicated to leveraging data analytics to transform CMC project management. This team will transform CMC portfolio data into a strategic asset for decision-making—tracking PRD portfolio metrics, driving PM tool development, and setting data standards. As a key enabler for data-driven decision making, this team has significant opportunities to create substantial impact by providing actionable insights, optimizing portfolio performance, and supporting strategic initiatives across our CMC operations. Join us at this pivotal moment and play a key role in shaping the future of CMC project management.

Summary We are seeking a highly motivated and skilled Data Engineer to join our CMC Portfolio Analytics & Insights Team. This role will be crucial in designing, building, and maintaining robust and scalable data pipelines and infrastructure to support our cutting-edge research, development, and business operations. The successful candidate will play a key role in transforming raw data into actionable insights, contributing directly to our mission of making life better.

Data Engineering & Pipeline Architecture Design, build, and maintain the data pipeline architecture behind the unified CMC Operational Data Hub Apply strong data modeling practices — datamart design, semantic modeling, and clean integration into Power BI Use Microsoft Fabric's unified analytics ecosystem (Data Factory, Synapse Data Engineering, Data Warehouse, Real-Time Analytics) to deliver scalable, production-grade solutions Automate extraction, transformation, and loading across diverse source systems, replacing manual reconciliation with reliable, repeatable pipelines Drive continuous improvement in data delivery and infrastructure as the team and data volumes scale Analytics & Visualization Build high-impact, interactive Power BI dashboards and reports that set the standard for portfolio analytics across CMC Implement and maintain row-level security and tiered access models so the right audiences see the right data Write advanced SQL to support in-depth analysis, reporting, and ad hoc portfolio questions Translate technical work into clear, business-friendly language that builds trust and drives adoption across CMC PM AI-Enabled Acceleration Use AI/LLM tools (e.g., Copilot, Claude) and emerging AI-enabled data platforms to speed up data integration, pipeline development, and standardization — always on validated, governed data Partner with the team's AI Expert as that role comes online, ensuring AI capabilities are built on a trustworthy data foundation Basic Requirements Bachelor's degree in Data Science, Engineering, or Medical related field 3+ years of experience in data engineering or data analytics, with a track record of delivering solutions that were actually adopted Expert-level proficiency in Power BI: dashboard design, development, and administration Strong