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 lakehouses, 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 pipelines, and version control that bring engineering rigor to analytics delivery.
Solution Delivery & Stakeholder Partnership
Partner with CAS audit leadership to understand their priorities, workflows, and process pain points, translating them into analytics and automation solutions that measurably improve how audits are executed.
Act as a trusted advisor, proactively identifying opportunities to streamline audit processes and bringing forward solutions rather than waiting for requirements.
Maintain and evolve a portfolio of Fabric solutions, continuously improving performance, usability, and reliability.
Deliver organizational reporting and analytics dashboards for business partners, leaders, and stakeholders.
Orchestrate work delivery through Smartsheet, managing intake, prioritization, tracking, and delivery metrics.
Operate in an Agile delivery model, driving continuous improvement, adoption, and business value.
Automation & Agentic Innovation
Automate CAS audit processes, building automation solutions for auditors that reduce manual effort and improve consistency across audit execution.
Automate Data Analytics operations, streamlining intake, delivery, and platform tasks to increase team efficiency and quality.
Leverage Claude Code and AI-assisted development to accelerate the build and maintenance of Fabric and automation solutions.
Pilot autonomous solutioning, applying agentic frameworks to automate build, testing, and operational tasks as this emerging capability matures.
Contribute to the CAS Claude Skill strategy, helping create and maintain reusable skills that encode Fabric, solution, and automation capabilities.
Pioneer and help define how agentic approaches evolve into AI-native CAS solutions over time, establishing early patterns the team will build on.
Technical Leadership & Innovation
Set, follow, and evolve technical standards alongside the team, contributing best practices, design patterns, and reusable templates to the shared Confluence repository referenced across Data Analytics and CAS.
Lead solution design for complex analytics and data challenges, shaping the approach and bringing peers along collaboratively.
Own delivery end to end, driving efforts to completion and taking accountability for quality, performance, and outcomes.
Contribute to solution and code reviews, exchanging feedback with peers to keep quality, consistency, and governance high across the team.
Advance how CAS builds, evaluating and piloting emerging Fabric, analytics, and agentic capabilities and sharing what works so the whole team benefits.
Share knowledge and enablement, helping build collective capability on Fabric, semantic modeling, Power BI, and AI tools.
Basic Qualifications / Requirements
Bachelor's Degree in Business Analytics, Data Science, Computer Science, Information Systems, Data Engineering, or related field, or equivalent experience.
5+ years of relevant professional experience in data engineering, analytics, or data solution development within a global, matrixed organization.
Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support for or sponsor work authorization or visas for this role, including but not limited to F-1 CPT, F-1 OPT, F-1 STEM OPT, J-1, H-1B, TN, O-1, E-3, H-1B1, or L-1.
Additional Skills / Preferences
Demonstrated experience leading end-to-end data solution delivery and setting technical standards that others follow, including through solution and design reviews.
Hands-on Microsoft Fabric experience (preferred) or a similar cloud data platform, including Lakehouse and warehouse design, medallion architecture, notebooks, and the full ELT lifecycle.
Strong semantic modeling proficiency, including advanced DAX, model design, and performance optimization.
Power BI and Fabric app delivery as a presentation layer, including dashboards, executive visualizations, and Fabric-native applications.
Data engineering languages and tools (Python, PySpark, SQL) and configuration-driven, automated data pipelines across diverse source systems.
Power BI and Fabric app delivery as a presentation layer, including dashboards, executive visualizations, and Fabric-native applications.
End-to-end solution delivery from requirements through deployment, adoption, and iteration.
Stakeholder partnership, translating business or audit needs into working solutions and driving adoption.
Process automation experience, building automations that reduce manual effort for business or operations teams.
CI/CD, Git, version control, testing, and DataOps for analytics and data engineering.
Pipeline monitoring and operational support patterns, including alerting and reliability practices.
Exposure to Claude Code, or strong interest in adopting AI-assisted development to accelerate solution building.
Interest in agentic AI frameworks and autonomous solutioning, with a desire to help build this emerging capability for CAS.
Structured data formats (JSON, YAML) and data-grounding patterns for AI.
Data access and security controls to govern data and AI access.
Data privacy and AI governance awareness, including responsible AI practices.
Regulated enterprise experience with attention to data governance and auditability.
Agile delivery methodologies and work-management tooling such as Smartsheet.
Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form (https://careers.lilly.com/us/en/workplace-accommodation) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.
Lilly is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status.
Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia (AMECA), Black Employees at Lilly (BE@Lilly), Chinese Culture Network (CCN), EnAble, Evolve, Lilly Indian Network (LIN), Organization of Latinx at Lilly (OLA), Pride (LGBTQ+ Allies), Veterans Leadership Network (VLN) and Women’s Initiative for Leading at Lilly (WILL).
Actual compensation will depend on a candidate’s education, experience, skills, and geographic location. The anticipated wage for this position is
$129,000 - $189,200Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lilly’s compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.
#WeAreLilly
Skills Required
- Bachelor's degree in Business Analytics, Data Science, Computer Science, Information Systems, Data Engineering, or a related field, or equivalent experience.
- 5+ years of relevant professional experience in data engineering, analytics, or data solution development within a global, matrixed organization.
- Authorization to work full-time in the United States without employer-sponsored work authorization or visas.
- Experience leading end-to-end data solution delivery and setting technical standards through solution and design reviews.
- Hands-on Microsoft Fabric or similar cloud data platform experience, including lakehouse, warehouse, medallion architecture, notebooks, and ELT lifecycle.
- Strong semantic modeling proficiency, including advanced DAX, model design, and performance optimization.
- Power BI and Fabric app delivery experience, including dashboards and executive visualizations.
- Experience with Python, PySpark, SQL, and configuration-driven automated data pipelines.
- Experience delivering solutions from requirements through deployment, adoption, and iteration.
- Stakeholder partnership experience translating business or audit needs into working solutions.
- Process automation experience reducing manual effort for business or operations teams.
- Experience with CI/CD, Git, version control, testing, and DataOps.
- Experience with pipeline monitoring, alerting, reliability, data access controls, and security practices.
- Exposure to Claude Code or strong interest in AI-assisted development.
- Interest in agentic AI frameworks and autonomous solutioning.
- Experience with JSON, YAML, AI data-grounding patterns, data privacy, AI governance, and responsible AI practices.
- Regulated enterprise experience with data governance and auditability.
- Experience with Agile delivery methodologies and work-management tools such as Smartsheet.
Eli Lilly and Company Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Eli Lilly and Company and has not been reviewed or approved by Eli Lilly and Company.
-
Retirement Support — Feedback suggests long-term savings are bolstered by a defined-benefit pension alongside a company 401(k) match and retiree health options. These elements make total compensation feel strong beyond base salary.
-
Leave & Time Off Breadth — Feedback suggests paid time off is expansive, with substantial vacation, company shutdown days, and milestone time. This breadth of leave is viewed as a meaningful part of overall rewards.
-
Parental & Family Support — Feedback suggests family-building and caregiving support are robust, including paid parental leave, adoption or surrogacy assistance, and backup care. These programs enhance the perceived value of benefits across life stages.
Eli Lilly and Company Insights
What We Do
Eli Lilly and Company engages in the discovery, development, manufacture, and sale of products in pharmaceutical products business segment. For more than a century, we have stayed true to a core set of values – excellence, integrity, and respect for people – that guide us in all we do: discovering medicines that meet real needs, improving the understanding and management of disease, and giving back to communities through philanthropy and volunteerism.
