Eli Lilly Services India Pvt Ltd

healthcare

SeniorConsultant-ConsumerAnalyticsDataEngineering

Bengaluru, India FULL TIME Remote Friendly
Market Sentiment
HIGH DEMAND

Neural analysis suggests this role is
optimal for Senior candidates.

The Brief

“Senior Consultant - Consumer Analytics Data Engineering at Eli Lilly Services India Pvt Ltd. Skills: Databricks platform, AWS data engineering, Consumer analytics data engineering, Lakehouse architectures, Semantic layer design, AI agent development. Design, develop, and implement scalable ETL/ELT pipelines. Architect and manage end-to-end solutions on Databricks”

What You'll Achieve.

making life better for patients; design and execute the next-generation marketing campaigns; power advanced analytical solutions and AI/agentic workflows for consumer insights; performance and cost efficiency; support complex analytical queries and reporting requirements; efficiency, reliability, and SLA adherence

Industry & Context.

healthcare
Problems you'll solve

Excellent problem-solving; Troubleshoot and resolve data-related issues; Performing root cause analysis

What They're Looking For.

Must Have

Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related quantitative field, 8+ years of data engineering experience with hands-on production experience on Databricks, proficiency in Python and advanced SQL for complex analytical workloads, Deep knowledge of Databricks platform architecture — Unity Catalog, Delta Lake, Databricks Workflows, Databricks SQL, and cluster/compute management, Solid experience with AWS data stack: S3, Glue, Redshift, Lambda, and IAM, Experience designing lakehouse architectures (medallion/multi-hop patterns) at scale and with ETL/ELT orchestration tools, understanding of data warehousing concepts, dimensional modeling, and data governance principles, Hands-on experience building semantic layers (e.g., dbt metrics, Databricks AII semantic layer) and creating AI agents or agentic pipelines (Databricks AI Functions etc.), Excellent problem-solving, communication, and stakeholder collaboration skills

Nice to Have

Familiarity with Software Development Life Cycle (SDLC) practices — including version control (Git), CI/CD pipelines, code reviews, and agile development methodologies

What You'll Do.

and implement scalable ETL/ELT pipelines

Architect and manage end-to-end solutions on Databricks

Design multi-hop lakehouse architectures

Leverage AWS data services

Architect and optimize data models and schemas

Design and publish semantic layers

Build and deploy agentic workflows

Collaborate with data scientists

Partner to productionize ML models and feature stores on Databricks

Implement automation for data ingestion

Troubleshoot and resolve data-related issues

Mentor other data engineers

Contribute to engineering standards

and comprehensive documentation

Stay current with Databricks platform updates

and emerging best practices

How You'll Work.

Team & Collaboration

Collaborate with data scientists, business analysts, and marketing teams; Partner to productionize ML models and feature stores on Databricks; Contribute to engineering standards, code reviews, knowledge sharing

Communication Scope

Excellent communication

Process & Methodology

agile development methodologies

Full Job Description

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world. **Eli Lilly Services India Pvt Ltd** **Senior Consultant, Consumer Analytics Data Engineering** As Eli Lilly strives to achieve its purpose of making life better for patients, we have been building up our in-house ‘Consumer Experience’ function, which designs and executes the next-generation marketing campaigns aimed at informing and educating consumers (or patients) directly. We are seeking a highly skilled Senior Consultant to lead consumer analytics data engineering initiatives at Lilly, Bengaluru. This role is primarily focused on the Databricks platform and AWS ecosystem, designing and maintaining robust data pipelines, lakehouse architectures, and semantic layers that power advanced analytical solutions and AI/agentic workflows for consumer insights. The ideal candidate brings deep hands-on Databricks expertise, good AWS data engineering skills, and a working knowledge of semantic layer design and AI agent development. The role will be a blend of technical expertise along with business/domain integration. **Job Responsibilities:** * Design, develop, and implement scalable ETL/ELT pipelines for extracting, transforming, and loading consumer data from various sources (e.g., CRM, marketing platforms, DCM, GA4, digital channels), with Databricks/AWS as the primary execution platform. * Architect and manage end-to-end solutions on Databricks including Unity Catalog, Delta Live Tables, Databricks Workflows, Databricks SQL, etc

Free ATS check

Applying for this Senior Consultant - Consumer Analytics Data Engineering role?

Most applicants get filtered before a human reads their resume. See if yours makes the cut.

How to Apply on Workday

  • Workday has a multi-step form — save your progress after every section.
  • "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
  • Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
  • Job requisition numbers are useful when following up with HR by email.

ANONYMOUS · UNFILTERED

What do employees actually say about Eli Lilly Services India Pvt Ltd?

Real rants from real employees. Read before you apply.

Read Company Rants →