Interns - BI&A Data Analyst

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.

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 39,000 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.

The purpose of the LBI Business Insights & Analytics team is to partner with US Business Insights & Analytics in providing high quality analytical support to Brand, Market Research and other internal partners through right data, smart analytics and actionable insights.

Intern - Business Insights & Analytics

We are seeking a motivated and enthusiastic intern to join our Business Insights & Analytics team for a 6-month internship. This role offers hands-on experience in commercial analytics within a leading pharmaceutical company, working on real business problems using modern analytics tools, AI-powered workflows, and governed data products.

Job Location

Bengaluru

Key Responsibilities

• Develop familiarity with commercial data sources and access and build governed datasets via Gold Layer / semantic layer assets in Databricks Unity Catalog.
• Deliver high-quality analytical outputs across the commercial value chain — patient journey, segmentation, targeting, channel spend, and persistency — translating findings into clear business insights and recommendations for brand and commercial teams.
• Build and maintain performance dashboards and reports covering brand performance, market monitoring, launch trackers, and KAM/Institutional analytics using Power BI.
• Apply Generative AI tools (e.g. Claude, Copilot) to accelerate analysis, draft insight summaries, and explore agentic approaches to automate routine reporting tasks.
• Query Gold Layer metric views using SQL and Python in Databricks notebooks to support consistent, governed analytics across brand and commercial use cases.
• Leverage Generative AI tools and agentic workflows to automate routine reporting, simplify data summarization, and accelerate delivery of analytical insights to stakeholders.
• Participate in stakeholder meetings, contribute to presenting outputs and recommendations, and help translate analytical findings into actionable business decisions.

Education Requirements

• Pursuing or recently completed a degree in Statistics, Mathematics, Finance, Engineering, or Computer Sciences, preferably from a Tier-I institute.

What We Look For

• Strong learning agility and intellectual curiosity - comfortable picking up new tools and technologies quickly.
• Strong problem-solving skills and ability to work through ambiguous, real-world data challenges.
• Excellent teamwork, communication, and collaboration skills; able to work effectively across technical and business teams.
• Flexibility and adaptability in a dynamic, fast-paced analytics environment.
• Ability to synthesize data into clear findings and communicate results effectively to business stakeholders
• Working knowledge of SQL and Python for data analysis; experience with Power BI or Tableau for visualization preferred.

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