Lead AI Data Engineer

eCTS CTI-MD Path/Level: R3

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 workplace, while staying deeply hands-on with schema design, query optimization, migration, and troubleshooting, and setting standards the wider team can follow.

What Were 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. eCTSs 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 mastering the existing logic and leading its transformation, not just by greenfield modernization.

What You Will Do

- Own, maintain, and continuously improve eCTSs existing stored procedures and database objects, which carry critical business logic today, while leading their conversion into full-stack and AI-enabled flows using AI-assisted approaches.
- Make embedded business logic explicit: document rules, build automated unit and regression tests for stored procedures and data logic, and create the safety net that makes confident, rapid change possible.
- Own the design, development, and evolution of relational and non-relational data models supporting eCTS and IWRS.
- Write, review, and optimize complex SQL, stored procedures, functions, and scripts, with the depth and care to keep long-standing logic correct and performant.
- Translate product and engineering requirements into robust, scalable database designs.
- Establish and enforce data modeling standards, naming conventions, and design patterns across the team

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 MD IDS - Product Delivery - Lead AI Data Engineer (Bengaluru)
🏢 Eli Lilly
📍 Bengaluru