Power BI Developer & Data Engineer

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.

Job Description

Position Summary

We are seeking a skilled Power BI Developer with Data Engineering capabilities to join our data and analytics team. The role will be responsible for delivering end-to-end analytics solutions, transforming complex data into actionable insights through intuitive dashboards and reports.

The ideal candidate should have strong expertise in Power BI development, along with working knowledge of data engineering concepts such as data pipelines, data modeling, and cloud-based analytics platforms. This role will collaborate closely with business stakeholders, data architects, and engineering teams to design scalable analytics solutions across the enterprise data ecosystem.

Key Responsibilities

Power BI Development & Visualization

• Design, develop, and maintain Power BI dashboards, reports, and data visualizations to support business decision-making.
• Develop advanced DAX calculations and measures for KPIs, time intelligence, and analytical insights.
• Optimize report performance using aggregations, incremental refresh, and appropriate dataset modes (Import/DirectQuery).
• Build and maintain Power BI Dataflows (Gen1/Gen2) for reusable transformations.
• Work with Microsoft Fabric or similar analytics platforms when applicable.
  
  
  

Data Modeling & Semantic Layer

• Develop and maintain the semantic layer that connects enterprise datasets to Power BI reports.
• Define consistent KPI definitions, business logic, and data standards across reports.
• Ensure datasets are clean, structured, and optimized for analytical consumption.
• Collaborate with data engineers to ensure data models align with reporting requirements.
• Validate and reconcile data accuracy between reporting layers and upstream data sources.
  
  
  

Data Engineering & Pipeline Contribution

• Contribute to data pipeline development and orchestration supporting analytics datasets.
• Work with SQL, Spark SQL, or PySpark to transform and prepare data for reporting.
• Support development or maintenance of data pipelines using tools such as Azure Data Factory, Databricks, or similar platforms.
• Collaborate with data engineers to design scalable data models, partitioning strategies, and optimized query performance.
• Assist in building automated workflows that refresh datasets and support reporting operations.
  
  
  

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Data Science, Information Systems, Engineering, or related field.
• 3–5 years of hands-on experience in Power BI development.
• Experience on Microsoft Fabric.
• Strong expertise in DAX, Power BI data modeling, and report design.
• Experience managing Power BI Service environments, including workspaces, refresh management, and security.
• Proficiency in SQL for data analysis and transformation.
• Experience connecting Power BI to cloud-based data platforms (Azure, Databricks, Synapse, SQL, etc.).
  
  
  

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 does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

#WeAreLilly