Data Analyst Intern

Eli Lilly and Company; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Eli Lilly and Company in Bengaluru seeks a data analytics professional to transform raw business data into actionable insights across departments globally. You will build dashboards, analyze datasets, and communicate findings to technical and non-technical stakeholders.

The role emphasizes SQL data prep, Power BI visualizations, and compelling PowerPoint presentations, with collaboration across multiple time zones to inform strategic decisions.

Qualifications

• Proficient in SQL for data extraction and cleaning.
• Strong experience creating dashboards in Power BI.
• Advanced Excel data modeling and analysis.
• Ability to present data stories in PowerPoint to varied audiences.

Responsibilities

• Transform raw data into actionable insights across departments.
• Conduct exploratory analysis to identify patterns and opportunities.
• Build dashboards and visual reports with Power BI or similar tools.
• Collaborate with cross-functional teams across time zones to refine recommendations.

Skills

SQL

Power BI

MS Excel

PowerPoint

Data storytelling

Communication

Collaboration

Education

Bachelor's degree in a related field

Tools

Databricks

AWS

Job description

Batch: 2025/2026/2027.

About the role

• Transform raw business data into actionable insights that drive decision-making across departments at a global pharmaceutical organization.


• Conduct exploratory analysis on complex datasets to identify patterns, anomalies, and opportunities that inform strategy.


• Build dashboards and visual reports using modern analytics tools to communicate findings to both technical and non-technical stakeholders.


• Support cross-functional teams by translating their data needs into clear analytical questions and delivering solutions on tight timelines.

What you'll work on

• Extracting, cleaning, and querying data using SQL to prepare datasets for analysis.


• Designing and developing interactive visualizations in Power BI or similar platforms to track key business metrics.


• Creating polished presentations and reports in PowerPoint that tell a story with data and guide action.


• Collaborating with colleagues across multiple time zones to understand requirements, validate findings, and refine recommendations.

What we're looking for

• Comfort navigating ambiguous situations where the path forward is unclear, staying analytical and methodical as you work.


• Demonstrated ability to break down hard problems into manageable steps and solve them logically.


• Advanced proficiency in MS Excel, including complex formulas, data modeling, and analysis.


• Advanced skill in PowerPoint-you can turn numbers into compelling visual narratives.


• Strategic mindset; you think about the bigger picture and how data connects to business outcomes.


• Strong communication and presentation abilities; you explain technical concepts clearly to any audience.


• Collaborative approach to working with stakeholders; you listen, ask good questions, and build consensus.

Good to know

• SQL experience is preferred.


• Experience with Power BI or other data visualization tools is preferred.


• Familiarity with AWS services on Databricks is preferred.