Associate Director - CAS AI Analytics Platform Engineering & AI Solutions
Eli Lilly and Company
August 31, 2026
Remote friendly (Indianapolis, IN)
United States
IT
Primary Position Responsibilities
Fabric Data Engineering & ELT
- Design, build, and maintain scalable data solutions on Microsoft Fabric (lakehouses/warehouses; Bronze/Silver/Gold medallion architecture).
- Engineer full ELT lifecycle: ingestion, transformations, and refresh pipelines using Fabric notebooks/config-driven frameworks.
- Build/maintain data orchestration (dependencies, scheduling, refresh).
- Refactor/migrate solutions to Fabric following governance/deployment standards.
- Apply CI/CD, Git version control, and automated testing.
- Uphold/extend CAS data architecture and governance (security, structure, maintainability).
Semantic Models, Power BI & Fabric Apps
- Build governed semantic models/data engines (Direct Lake), emphasizing DAX and performance.
- Develop “AI Ready” semantic models (contextual layer: definitions, relationships, business meaning) to ground Claude/AI agents.
- Use Claude, MCP, and Claude Code to build/enrich AI Ready models.
- Own Power BI delivery (dashboards, executive visualizations, reporting).
- Innovate Fabric-native apps and self-service analytics.
- Establish enterprise deployment patterns (shared datasets, deployment pipelines, version control).
Solution Delivery & Stakeholder Partnership
- Partner with CAS audit leadership to translate priorities/pain points into analytics/automation.
- Advise proactively on streamlining audits; maintain/evolve solution portfolio.
- Deliver reporting/analytics; orchestrate delivery via Smartsheet; operate in Agile.
Automation & Agentic Innovation
- Automate audit processes and Data Analytics operations to reduce manual effort.
- Use Claude Code for accelerated development; pilot agentic/auto solutioning.
- Contribute to CAS Claude Skill strategy and define AI-native CAS patterns.
Technical Leadership & Innovation
- Set/evolve technical standards, lead design for complex challenges, own delivery end-to-end.
- Contribute to solution/code reviews; share knowledge and enablement.
Basic Qualifications / Requirements
- Bachelor’s degree (Business Analytics, Data Science, CS, IS, Data Engineering) or equivalent.
- 5+ years in data engineering/analytics/data solutions in a global, matrixed environment.
- Authorization to work in the United States full-time (no visa sponsorship).
Additional Skills / Preferences
- Experience setting technical standards; hands-on Microsoft Fabric (preferred) and ELT lifecycle.
- Advanced semantic modeling (DAX, performance optimization).
- Power BI and Fabric app delivery.
- Python/PySpark/SQL; automated/config-driven pipelines.
- CI/CD, Git, testing, DataOps; monitoring/operational support.
- Exposure to Claude Code; interest in agentic AI frameworks; JSON/YAML and AI grounding.
- Data access/security controls; data privacy/AI governance; regulated enterprise experience.
- Agile delivery and Smartsheet (or similar).
Fabric Data Engineering & ELT
- Design, build, and maintain scalable data solutions on Microsoft Fabric (lakehouses/warehouses; Bronze/Silver/Gold medallion architecture).
- Engineer full ELT lifecycle: ingestion, transformations, and refresh pipelines using Fabric notebooks/config-driven frameworks.
- Build/maintain data orchestration (dependencies, scheduling, refresh).
- Refactor/migrate solutions to Fabric following governance/deployment standards.
- Apply CI/CD, Git version control, and automated testing.
- Uphold/extend CAS data architecture and governance (security, structure, maintainability).
Semantic Models, Power BI & Fabric Apps
- Build governed semantic models/data engines (Direct Lake), emphasizing DAX and performance.
- Develop “AI Ready” semantic models (contextual layer: definitions, relationships, business meaning) to ground Claude/AI agents.
- Use Claude, MCP, and Claude Code to build/enrich AI Ready models.
- Own Power BI delivery (dashboards, executive visualizations, reporting).
- Innovate Fabric-native apps and self-service analytics.
- Establish enterprise deployment patterns (shared datasets, deployment pipelines, version control).
Solution Delivery & Stakeholder Partnership
- Partner with CAS audit leadership to translate priorities/pain points into analytics/automation.
- Advise proactively on streamlining audits; maintain/evolve solution portfolio.
- Deliver reporting/analytics; orchestrate delivery via Smartsheet; operate in Agile.
Automation & Agentic Innovation
- Automate audit processes and Data Analytics operations to reduce manual effort.
- Use Claude Code for accelerated development; pilot agentic/auto solutioning.
- Contribute to CAS Claude Skill strategy and define AI-native CAS patterns.
Technical Leadership & Innovation
- Set/evolve technical standards, lead design for complex challenges, own delivery end-to-end.
- Contribute to solution/code reviews; share knowledge and enablement.
Basic Qualifications / Requirements
- Bachelor’s degree (Business Analytics, Data Science, CS, IS, Data Engineering) or equivalent.
- 5+ years in data engineering/analytics/data solutions in a global, matrixed environment.
- Authorization to work in the United States full-time (no visa sponsorship).
Additional Skills / Preferences
- Experience setting technical standards; hands-on Microsoft Fabric (preferred) and ELT lifecycle.
- Advanced semantic modeling (DAX, performance optimization).
- Power BI and Fabric app delivery.
- Python/PySpark/SQL; automated/config-driven pipelines.
- CI/CD, Git, testing, DataOps; monitoring/operational support.
- Exposure to Claude Code; interest in agentic AI frameworks; JSON/YAML and AI grounding.
- Data access/security controls; data privacy/AI governance; regulated enterprise experience.
- Agile delivery and Smartsheet (or similar).