Intern, CI&A Data Analyst
Eli Lilly and Company
About the Role
The Customer Insights & Analytics (LCCI) team partners with US Customer Insights & Analytics to provide high-quality analytical support to Brand, Market Research, and other internal partners. This involves leveraging the right data, smart analytics, and actionable insights.
Key Responsibilities
- Develop familiarity with commercial data sources and access 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.
- Build and maintain performance dashboards and reports using Power BI covering brand performance, market monitoring, launch trackers, and KAM/Institutional analytics.
- Apply Generative AI tools (e.g., Claude, Copilot) to accelerate analysis, draft insight summaries, and explore agentic approaches for automating routine reporting.
- Query Gold Layer metric views using SQL and Python in Databricks notebooks to support consistent, governed analytics.
- Leverage Generative AI tools and agentic workflows to automate routine reporting, simplify data summarization, and accelerate the delivery of analytical insights.
- Participate in stakeholder meetings, contribute to presenting outputs and recommendations, and help translate analytical findings into actionable business decisions.
Requirements & Tech Stack
- SQL (preferred)
- Data visualization tools such as Power BI (preferred)
- Knowledge of AWS services on Databricks (preferred)
- Generative AI tools (e.g., Claude, Copilot)
- Databricks Unity Catalog
- Databricks notebooks
- Python
- MS-Excel
- MS-PowerPoint
Qualifications
- 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.
- Strong problem-solving skills.
- Advanced MS-office skills.
- Strong work ethic and personal motivation.
- Good presentation skills.
- Interpersonal and communication skills with the 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.

