MD IDS - Product Delivery - Lead AI 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. Lead AI Data Engineer eCTS · CTI-MD · Path/Level: R3 At Lilly, we believe in the talent of our workforce. One of the best ways to utilize and develop that talent is to use our existing workforce to fill new and/or open positions. If you are looking for a new position within Lilly, you can view and apply to open roles posted in the internal job posting system. You must meet the minimum qualifications outlined in the job description and have/obtain work authorization in the country the position is located in order to be considered. When applying internally for a position, your current supervisor will receive notification that you have applied to the position. We encourage employees to discuss the opportunity with their supervisor prior to applying. Path/Level: R3 Note: Roles are posted at the lowest level of a band, however, employees should search across all levels of the band to identify all opportunities. Employees hired on banded positions (ex: P1–P3, R-path, B1–B3, etc.) transfer at their current level, despite the level indicated on the job posting. For example, if an R2 candidate is selected for an R1–R3 banded position, the candidate will remain an R2 in the new role. 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. Role Overview eCTS is a core clinical supply product within CTI-MD, helping make sure the right investigational medicine reaches the right patient at the right time. Over the next few years, clinical systems will evolve from a database-centric application into an intelligent, cloud-native clinical supply data platform: one where critical business logic is explicit and tested, data is served as governed products, and AI agents work safely alongside people to plan, monitor, and resolve supply events. We are seeking a hands-on Data Systems Lead to drive that evolution. This role owns the data foundation of eCTS today, including the stored procedures and database objects that carry critical business logic, and leads its transformation into AI-enabled, full-stack flows, including the external facing site modernization. You will shape how data is structured, migrated, secured, served, and made AI-ready in a regulated pharmaceutical environment, while staying deeply hands-on with schema design, query optimization, migration, and troubleshooting, and setting standards the wider team can follow. The person in this role will help build the following future state. It is the lens for every responsibility below. Logic made explicit Business rules held in legacy stored procedures are documented, covered by automated tests, and progressively re-platformed, with AI accelerating analysis and conversion under validated controls. Data as a Service eCTS data is published as governed, well-documented data products and APIs with clear contracts and SLAs, serving the application, analytics, adjacent clinical systems, and AI consumers. AI-ready and agent-enabled Data is structured, described, and exposed so AI agents can reason over it and act on it safely, with least-privilege access, human-in-the-loop approvals, and full auditability. Cloud-native and as-code Database changes, infrastructure, and quality checks flow through automated pipelines, with observability that moves operations from reactive to proactive. What We're Really Looking For (Core Needs) Two things matter most in this role: Ability to lead and technically execute agentic solutions independently. We have a strong and growing pipeline of agentic AI opportunities across eCTS, ranging from AI-assisted conversion of legacy logic to agents that surface, explain, and help resolve clinical supply and data issues. We need this person to lead and drive that space: to challenge and align platform-level teams, set technical direction, and execute hands-on without hand-holding. This is an autonomous, get-it-done technical leadership role, not a coordination-only one. Genuine passion for the core database work. eCTS's stored procedures and database objects encode years of clinical supply know-how and remain a key contributor to the product today. This role owns that work end to end: enhancing it, continuously improving it, and actively using AI to convert these legacy flows into future-state full-stack and AI-enabled flows. We need someone who values this foundation, takes pride in keeping it healthy and reliable, and is energized by both mast