Intern - CI&A Data Analyst

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. About Lilly At Lilly, everything we do starts with patients. We unite caring with discovery to make life better for people around the world. Headquartered in Indianapolis, Indiana, our global team of over 50,000 employees work with urgency and purpose to discover and deliver life-changing medicines, strengthen how health is understood and managed, and support the communities we serve. We bring our best to this work because people depend on it. If you're driven by purpose and determined to make a meaningful difference for patients, we invite you to bring your skill and your commitment to Lilly. About Commercial at Lilly, Bengaluru The medicines Lilly develops only reach patients if the commercial engine behind them works with precision. At Lilly in Bengaluru, the commercial function builds and powers that engine, designing the capabilities, generating the intelligence, and developing the strategies that Lilly's customer-facing teams around the world depend on to connect medicines to the people who need them. The work here is not local in scope. It shapes how Lilly operates commercially across geographies, business units, and markets globally. Job Description- Customer Insights & Analytics The purpose of the LCCI Customer Insights & Analytics team is to partner with US Customer Insights & Analytics in providing high quality analytical support to Brand, Market Research and other internal partners through right data, smart analytics and actionable insights. 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 • Degree in quantitative discipline i.e. Statistics, Mathematics, Finance, Engineering or Computer Sciences from Tier-I institute. Job Location Bengaluru What we look for • Ability to think strategically in an ambiguous environment in analytics • Technical Skills - Strong Problem-solving skills - Advanced MS-office skills (MS-Excel and MS-PowerPoint) - Experience in SQL (preferred) - Experience in data visualization tools e.g. PowerBI (preferred) - Knowledge of AWS services on Databricks (preferred) • Soft Skills - 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 At Lilly, caring is not only what we do for patients. It is how we work. We believe the people who dedicate themselves to making medicines better deserve an environment that makes their lives better too, one where they are supported, respected, and given the space to do their best work. This is not just a policy. It is who we are. 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. 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