Intern - CI&A Data Analyst

Overview

An internship on the Customer Insights & Analytics team in Lilly's commercial function in Bengaluru, partnering with US Customer Insights & Analytics to provide analytical support to Brand, Market Research and other internal partners.

What you'll do

• 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.

What you'll need

• Degree in a quantitative discipline (Statistics, Mathematics, Finance, Engineering or Computer Sciences) from a Tier-I institute.
• Ability to think strategically in an ambiguous environment in analytics.
• Strong problem-solving skills.
• Advanced MS-Office skills (MS-Excel and MS-PowerPoint).
• Strong work ethic and personal motivation.
• Good presentation skills.
• Interpersonal and communication skills with ability to work across time zones.
• Ability to operate effectively in an international matrix environment.
• Strong stakeholder management skills.
• Strong team player who is dynamic and result oriented.

Nice to have

• Experience in SQL.
• Experience in data visualization tools such as Power BI.
• Knowledge of AWS services on Databricks.

Details

• Location: Bengaluru, India.