All jobs
Eli Lilly and Company logo

Data Analyst – Consultant/Senior Consultant

Eli Lilly and Company · Posted 1 month ago

  • Bengaluru East, Karnataka, India (On-site)
  • Full-time
  • 4+ yrs

About the role

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.

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.

At Lilly, we believe in the talent of our workforce. One of the best ways to utilize and develop that talent is to use our existing workforce to fill new and/or open positions. If you are looking for a new position within Lilly, you can view and apply to open roles posted in the internal job posting system. You must meet the minimum qualifications outlined in the job description and have/obtain work authorization in the country the position is located in order to be considered. When applying internally for a position, your current supervisor will receive notification that you have applied to the position. We encourage employees to discuss the opportunity with their supervisor prior to applying.

Path/Level

  • P1/P2

Note: Roles are posted at the lowest level of a band, however, employees should search across all levels of the band to identify all opportunities. Employees hired on banded positions (ex: P1-P3, R-path, B1-B3, etc.) transfer at their current level, despite the level indicated on the job posting. For example, if a P2 candidate is selected for a P1-P3 banded position, the candidate will remain a P2 in the new role.

Job Summary

The purpose of the POP HCP Analytics Product Team within Global Customer Insights & Analytics (CI&A) is to provide high-quality analytical support to brand, marketing, and other internal partners through the right data, smart analytics, and actionable insights delivered on Lilly's commercial analytics platform. We are seeking a highly motivated and detail-oriented Data Analyst – Consultant/Senior Consultant to build governed data products and analyses that support achievement of brand goals across multiple therapeutic areas, while continuously driving process improvement, innovation, and adoption of agentic AI ways of working.

  • Job Responsibilities
  • Design, build, and maintain governed data objects (tables, materialized views, metric views) within Unity Catalog and the enterprise semantic layer, supporting a range of commercial analytics use cases across multiple therapeutic areas.
  • Design and define key KPIs and metrics for brand and commercial stakeholders using HCP prescribing behaviour, activity, patient journey, and claims-based datasets, exercising sound judgment when data is incomplete or ambiguous.
  • Support the team's agentic AI initiatives by contributing to feedback triage and quality checks that keep AI-driven tools aligned with the governed data layer.
  • Participate across the full project lifecycle, including kick-off, methodology development, execution, insight generation, and results presentation, while developing into a trusted advisor to stakeholders.
  • Collaborate across teams (data engineering, data science, functional product, BI) to resolve dependencies/open issues, prioritize backlog items and identify technical debt and legacy dependencies and design governed, reusable alternatives.
  • Prepare clear analytical summaries and documentation, and communicate final outputs and recommendations directly to stakeholders.
  • Translate ambiguous or loosely-defined business requirements into technical specifications and user stories within an Agile delivery framework.
  • Continuously leverage AI/agentic tools to automate documentation, code review, and repetitive tasks, driving team efficiency.
  • Own data quality and validation for assigned data assets, validating outputs against production baselines and maintaining documentation, lineage, and version control.
  • Investigate and root-cause data discrepancies distinguishing genuine defects from issues owned elsewhere, and propose fixes.
  • Job Qualifications
  • Bachelor's degree in a quantitative field such as Statistics, Computer Science, Data Science, Engineering, Life Sciences, or a related discipline.
  • 4+ years of experience carrying out the required responsibilities in pharma commercial/HCP analytics, claims-based analytics, or analytics in other industries.
  • Strong analytical and problem-solving skills, with the ability to break down ambiguous or loosely-defined business questions into structured solutions.
  • Working knowledge of Databricks (Unity Catalog, Delta Lake) and advanced SQL for building and reviewing large-scale data objects; familiarity with PySpark or Python or SAS is a plus.
  • Working knowledge of pharma claims data sources and U.S. HCP/patient-level analytics concepts is a plus.
  • Excellent communication skills, with the ability to translate complex technical/data concepts for both technical and non-technical audiences.
  • Exposure to or strong interest in agentic AI/LLM-assisted engineering workflows that accelerate documentation, testing, and code review, paired with working knowledge of CI/CD concepts for data pipelines, including version control and environment promotion across development, test, and production.
  • Experience with Agile delivery practices (epics, stories, sprint planning) in a data product environment is preferred.
  • Ability to work independently and as part of a cross-functional team in a fast-paced, ambiguous environment, using sound judgment to prioritize and resolve issues with incomplete information; strong organizational skills and ability to manage multiple priorities.
  • Traditional BI tool experience (Power BI, Tableau) is a plus, as is exposure to building lightweight analytical front ends using frameworks such as Flask or Streamlit.
  • Lilly does not discriminate on the basis of age, race, colour, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.
  • #WeAreLilly
  • 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 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

Skills

Analytical skillsProblem-solving skillsSQLDatabricks (Unity Catalog, Delta Lake)Python/PySpark/SASCommunication skillsAgentic AI/LLM-assisted engineering workflowsCI/CD concepts

Quark9 guide

How to land this Data Analyst – Consultant/Senior Consultant role

Our notes for applicants, based on how data and AI hiring usually works and on 337 similar open jobs on Quark9.

Resume checklist for this job

Most companies screen resumes with an ATS before a person reads them. Make sure each skill you genuinely have appears in your resume in the same words the job uses.

Must have

  • Analytical skills
  • Problem-solving skills
  • SQL
  • Databricks (Unity Catalog, Delta Lake)
  • Python/PySpark/SAS
  • Communication skills
  • Agentic AI/LLM-assisted engineering workflows
  • CI/CD concepts
  • Lead each project with the business result (revenue, cost, time saved), then the method
  • List the stack precisely: SQL dialect, Python libraries, BI tool, cloud platform
  • Link a portfolio or GitHub with one or two well-documented projects
Check your resume against this job free

What interviewers expect: early to mid level

Expect questions about work you owned end to end. Show what you delivered, the tools you used daily and one or two results with numbers.

How data and AI interviews usually run

  1. A screening call on your projects and the size of data you have worked with
  2. A SQL round, usually joins, window functions and aggregations on a sample schema
  3. A case or modelling round: frame a business problem, choose metrics, explain trade-offs
  4. A take-home or live exercise in Python, then a final round with the hiring manager

Questions worth preparing

  • Write a query for the second-highest salary in each department.
  • How would you measure whether a new feature improved retention?
  • Explain overfitting to a non-technical stakeholder and how you guard against it.
  • Walk through a project end to end: the question, the data, the method and the impact.

Every company runs its own process, so treat this as a likely shape, not a promise. Practise a mock interview on Quark9 and get scored feedback before the real one.

The market for Data Analyst roles right now

  • Most openings are in Bengaluru, Pune, Gurgaon, Hyderabad, and 2 of the 20 we looked at offer remote work.
  • The skills these jobs ask for most:
SQLData analysisMicrosoft ExcelPythonProject managementCommunicationBusiness analysisData analytics

From open jobs on Quark9 matching “Data Analyst”, updated every few minutes.

Similar jobs