Analyst – AEV Hub – Analytics Engineer

Eli Lilly

  • Indianapolis, IN
  • $63,750-145,200 per year
  • Permanent
  • Full-time
  • 1 day ago
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.Organization Overview:The Analytics Engineering and Visualization Hub is a centralized team within Finance Digital Transformation whose mission is to build trusted data products—including semantic models, dashboards, and other tools—that empower Finance and the broader organization to make faster, smarter decisions. By standardizing data and visual design, we enable scalable analytics, data literacy, and the foundation for AI-driven solutions.Position Description:The Analyst – AEV Hub – Analytics Engineer will design, build, and maintain robust data pipelines and semantic models that serve as the foundation for scalable self-service analytics. This role is ideal for someone who thrives at the intersection of data engineering and analytics, with a passion for shaping raw data into clean, governed, and reusable assets that empower scalable analytics and decision-making. The engineer will work in Microsoft Fabric and other modern data platforms to deliver high-quality data products that power decision-making across Finance. This role reports to the Senior Director of the Analytics Engineering and Visualization Hub.Responsibilities:
  • Partner with Finance stakeholders, enterprise data engineers, and AEV Hub data analysts to understand business needs and ensure data products deliver accurate, relevant, and actionable insights
  • Ingest and integrate data from diverse sources using Microsoft Fabric tools (shortcuts, pipelines, dataflows Gen2) to create unified and accessible datasets
  • Transform and enrich data with reusable logic and workflows using Fabric dataflows Gen2, stored procedures, and notebooks
  • Design and maintain lakehouses and data warehouses to support scalable analytics
  • Build and manage enterprise-grade semantic models with reusable metrics and robust access controls
  • Implement and enforce data governance, quality, and documentation standards
  • Optimize performance and reliability of data pipelines and models
  • Contribute to the enablement of self-service analytics through training and support
Basic Requirements:
  • Bachelor’s degree in Finance, Computer Science, Data Analytics, or a related technical field
  • 3+ years of experience in data engineering, analytics engineering, or business intelligence
  • Proficiency in SQL and experience with data transformation tools (e.g., Power Query, PySpark, T-SQL)
  • Experience with Microsoft Fabric, Azure Synapse, Azure Databrick, or similar cloud data platforms
  • 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 and/or visas for this role.
Additional Skills/Preferences:
  • Power BI certification (e.g., PL-300) or Microsoft Fabric certification (e.g., DP-600 or successor)
  • Experience with Microsoft Fabric components: lakehouses, dataflows, pipelines, notebooks, and semantic models
  • Experience with Git-based development workflows and CI/CD for data products
  • Strong understanding of data modeling principles and semantic layer design
  • Experience building Power BI semantic models and dashboards
  • Experience with Power BI service (workspaces, deployment, row-level security, dataflows).
  • Experience working in Finance or with financial data
  • Strong collaboration and communication skills, with the ability to work across business and technical stakeholders
Additional Information:
  • Travel 0-10%
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 ( ) 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 Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Women’s Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups.Actual compensation will depend on a candidate’s education, experience, skills, and geographic location. The anticipated wage for this position is $63,750 - $145,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

Eli Lilly