Data Analyst – Consultant/Senior Consultant

Bioksha; Bengaluru; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

Lilly India is seeking a Data Analyst – Consultant/Senior Consultant (Formulary & Payer Access Analytics) to support data-driven decision making by translating MMIT and market access data into actionable insights. You will collaborate with market access, brand, and pricing teams to understand payer landscapes and improve access strategies.

The role requires strong SQL, data visualization, and programming skills, plus experience with Databricks.

Qualifications

• Experience in pharma market access or payer analytics.
• Strong SQL and data visualization expertise.
• Ability to translate data insights to non-technical stakeholders.

Responsibilities

• Extract, analyse, and validate formulary and access data from MMIT to track coverage, tier placement, and utilization management restrictions across commercial, Medicare, and Medicaid channels.
• Perform in-depth analysis of payer/PBM formulary decisions, competitive access positioning, and formulary shifts impacting brand performance.
• Build and leverage AI to present KPIs and analytical findings to stakeholders.
• Collaborate with business users to understand requirements and translate them into technical specifications for data analysis products.
• Identify opportunities for data quality improvement and implement best practices for data governance while creating data products.
• Prepare clear summaries, presentations, and recommendations based on analytical findings.
• Participate in cross-functional teams to contribute to data-driven access strategy initiatives.
• Continuously learn, leverage AI, and apply new data analysis techniques to formulary/access reporting.

Skills

MMIT datasets

SQL

AI in analytics

Python/R

Education

Bachelor's degree in a quantitative field

Tools

Databricks

Tableau

Power BI

Qlik Sense

Job description

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.

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

We are seeking a highly motivated and detail-oriented Data Analyst – Consultant/Senior Consultant (Formulary & Payer Access Analytics) to join our team at Eli Lilly Services India Pvt Ltd. In this role, you will play a crucial part in supporting data-driven decision-making around formulary and payer access by leveraging MMIT datasets and other market access data sources. You will work closely with market access, brand, and pricing/contracting stakeholders to translate complex payer landscape data into actionable insights.

Job Responsibilities

• Extract, analyse, and validate formulary and access data from MMIT to track coverage, tier placement, and utilization management restrictions (PA, ST) across commercial, Medicare, and Medicaid channels.
• Perform in-depth analysis of payer/PBM formulary decisions, competitive access positioning, and formulary shifts impacting brand performance.
• Build and leverage AI to present key performance indicators (KPIs) and analytical findings to stakeholders.
• Collaborate with business users to understand their requirements and translate them into technical specifications for data analysis products or projects.
• Identify opportunities for data quality improvement and implement best practices for data governance while creating data products.
• Prepare clear and concise summaries, presentations, and recommendations based on formulary and access analytical findings.
• Participate in cross-functional teams to contribute to data-driven access strategy initiatives.
• Continuously learn, leverage AI, and apply new data analysis techniques, tools, and technologies to formulary/access reporting.

Job Qualifications

• Bachelor's degree in a quantitative field such as Statistics, Mathematics, Computer Science, Economics, Life Sciences, or a related discipline.
• 4+ years of experience in pharma market access, payer analytics, formulary/access data analysis, or a similar role.
• Hands‑on working experience with MMIT datasets/platforms.
• Solid understanding of the U.S. payer landscape - Commercial, Medicare Part D, Medicaid, PBMs, and Formulary mechanics.
• Proficiency in SQL for data extraction and manipulation; experience with Databricks is preferable.
• Strong experience with data visualization tools (such as Tableau, Power BI, or Qlik Sense).
• Leverage AI in day‑to‑day work — including documenting processes, developing and training AI agents, automating repetitive tasks, and effective presentation of insights — to drive efficiency and productivity.
• Excellent analytical and problem‑solving skills with a keen eye for detail.
• Ability to communicate complex formulary/access insights effectively to both technical and non-technical audiences.
• Proficiency in Microsoft Excel (pivot tables, VLOOKUP, advanced formulas).
• Experience with a programming language for data analysis (e.g., Python, R) is a plus.
• Ability to work independently and as part of a team in a fast‑paced environment.
• Strong organizational skills and ability to manage multiple priorities.

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

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions.