Associate Director - CAS AI Analytics Platform Engineering & AI Solutions

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.

** Corporate Audit Services Organization Overview*
* Corporate Audit Services (CAS) is an independent, objective audit and consulting function driven by a commitment to add value and enhance the operations of Eli Lilly and Company. CAS's mission is to support the company in achieving its objectives by employing a systematic, disciplined approach to evaluate and improve the effectiveness of risk management, control, and governance processes.

** Position Description*
* This position builds and delivers best-in-class, end-to-end analytics solutions on Microsoft Fabric, the foundation of the CAS data platform. Working across the full lifecycle, from data engineering, warehousing, and ELT through semantic models, Power BI, and Fabric apps, the individual creates and evolves a portfolio of Fabric solutions that turn CAS data into trusted, self-service intelligence.

A core focus is building AI Ready Semantic Models, the governed, contextual data layer that grounds Claude and AI agents in trusted CAS data. Partnering directly with CAS audit teams and stakeholders, the individual translates business needs into working solutions, drives efforts to completion, and grows adoption across the function, delivering high-quality, well-governed solutions within the CAS data architecture and data engine standards.

The individual also helps innovate how CAS builds and automates, leveraging Claude Code and beginning to apply agentic frameworks to accelerate development and automate CAS audit and Data Analytics operations. Above all, this is a hands-on builder who thrives on a team of doers, collaborates openly, sets and evolves standards alongside peers, and partners across Finance and the broader Lilly organization to deliver where it creates the most value.

Success in this role is as much about how the work gets done as what gets built. This is a highly collaborative, hands-on team of builders who share openly, support one another, and put the team's success first. The individual brings an ownership mindset and a high personal bar, communicates with clarity and empathy, stays humble and curious, and builds trust across CAS and its partners, contributing to a positive culture where people do their best work.

** Primary Position Responsibilities*
* ** Fabric Data Engineering & ELT*
* + Design, build, and maintain scalable data solutions on Microsoft Fabric, spanning lake houses, warehouses, and a medallion architecture (Bronze, Silver, and Gold layers).

+ Engineer the full ELT lifecycle, building ingestion, transformation, and refresh pipelines with Fabric notebooks and configuration-driven frameworks that are scalable, reusable, and maintainable.

+ Build and maintain data orchestration across solutions, coordinating pipelines, dependencies, scheduling, and refresh.

+ Refactor and migrate existing solutions onto the Fabric platform, following established governance and deployment standards.

+ Apply CI/CD, Git version control, and automated testing that bring engineering rigor and repeatability to solution development.

+ Uphold and extend the CAS data architecture and governance frameworks, keeping solutions secure, well-structured, and maintainable at enterprise scale.

** Semantic Models, Power BI & Fabric Apps*
* + Build data engines and semantic models on Fabric to the CAS data engine standards, primarily using Direct Lake, with strong attention to DAX and model performance for governed, high-performance consumption by Power BI, Fabric apps, and Claude.

+ Develop AI Ready Semantic Models, establishing the holistic contextual layer within the semantic model (definitions, relationships, and business meaning) that makes it consumable by large language models and grounds Claude in trusted CAS data.

+ Leverage Claude, MCP, and Claude Code to build and enrich AI Ready Semantic Models and to innovate how CAS delivers AI-grounded analytics.

+ Own Power BI solution delivery, building dashboards, executive visualizations, and reporting that make data accessible and actionable for stakeholders.

+ Innovate new Fabric app solutions, designing and building Fabric-native applications that extend how CAS delivers and consumes data.

+ Architect self-service analytics that enable stakeholders to explore data without ongoing developer support.

+ Establish enterprise deployment patterns, including shared datasets, deployment…