Data Analyst - Consultant/Sr Consultant

Eli Lilly And Company; Bengaluru; Sur place; INR 8 721 000 - 11 628 000; Plein temps

Résumé du poste

Eli Lilly And Company seeks a Data Analyst - Consultant/Senior Consultant to design, build, and govern data objects on Lilly's commercial analytics platform, delivering high-quality insights for brand, marketing, and internal partners across multiple therapeutic areas.

You'll collaborate with data engineering, data science, BI, and product teams within an Agile framework, translate business needs into technical specifications, validate outputs, and advance AI-enabled analytics and governance

Qualifications

• Bachelor's degree in a quantitative field.
• 4+ years in pharma analytics or related analytics.
• Strong analytical and problem-solving skills.
• Knowledge of Databricks, Unity Catalog, Delta Lake, and advanced SQL.
• Familiarity with PySpark, Python, or SAS is a plus.
• Experience with pharma claims data concepts is beneficial.
• Excellent communication with technical and non-technical audiences.
• Exposure to agentic AI/LLM-assisted workflows and CI/CD for data pipelines.
• Experience with Agile delivery (epics, stories, sprints) in data products.

Responsabilités

• Design, build, and maintain governed data objects within Unity Catalog and the enterprise semantic layer.
• Define KPIs for brand/commercial stakeholders using prescribing, activity, patient journey data.
• Support AI initiatives with feedback triage and quality checks to align with governance.
• Participate in end-to-end project lifecycle and become a trusted advisor to stakeholders.
• Collaborate across data engineering, data science, BI to resolve dependencies and debt.
• Prepare analytical summaries and documentation; communicate outputs to stakeholders.
• Translate business requirements into technical specs and user stories in Agile delivery.
• Leverage AI/agentic tools to automate documentation, review, and repetitive tasks.
• Own data quality and validation; maintain lineage and version control.
• Investigate data discrepancies and propose fixes.

Connaissances

Analytical thinking

Communication

Problem solving

Agile delivery

Stakeholder management

Independent / self-motivated

Team collaboration

Attention to detail

Requirements gathering

Formation

Bachelor's degree in Statistics/CS/DS/Engineering/Life Sciences

Outils

Databricks

Unity Catalog

Delta Lake

SQL

Python

PySpark

CI/CD concepts

Power BI

Tableau

Flask / Streamlit

Description du poste

Job Summary

The purpose of the POP HCP Analytics Product Team within Global Customer Insights Analytics (CIA) 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 Lillys 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.

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 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 teams 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

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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.