Lilly
Create a free account
One signup unlocks everything for this job:
- See your personalized profile match score
- See the skills this role is missing for you
- Apply to this job and track your application
- Generate an AI cover letter for this role
Bengaluru · On-site · 3-6 Yrs · Sep 28
Biotech & Pharmaceuticals · 10000+ Employees · Indianapolis, US
Lilly is a global health care leader that unites caring with discovery to create medicine that make life better for people around the world. For more than a century, we have stayed true to a core set of values – excellence, integrity, and respect for people – that guide us in all we do: discovering medicines that meet real needs, improving the understanding and management of disease, and giving back to communities through philanthropy and volunteerism. We also have been committed to investing in our employees – through competitive salaries, training and development, health, and the opportunity to do good. The pharmaceutical industry is a complex, rapidly changing environment and we’re looking for people who are determined to make life better for people around the world. Visit https://careers.lilly.com for more information.
Hiring: Engineering
What employees say
+ Decent salary & Variable pay
− Name sale benefits like free lunch must be discontinued. No Transparency in Org policies. If you are managers favourite you will go a long way.
More reviews on the company profile.
Interview experience · Intern
Good experience. Nice people. Asked 2 dsa questions one from linked list and other one was strings. OT was also good had 4 questions medium easy level. Overall great interview experience.
Average difficulty · India · 141 reports
More interview insightsJob description
Overview
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.
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.
- Develop and manage end-to-end solutions on Databricks including Unity Catalog, Delta Live Tables, Databricks Workflows, Databricks SQL, etc.; own platform governance covering schemas, permissions, and data lineage.
- Design multi-hop lakehouse architectures (Bronze / Silver / Gold) using Delta Lake; optimize Spark compute, cluster configurations, and Auto Loader for performance and cost efficiency.
- Leverage AWS data services — S3, Glue, Lambda and Redshift — in conjunction with Databricks to build reliable, end-to-end consumer data flows.
- Architect and optimize data models and schemas to support complex analytical queries and reporting requirements related to consumer behaviour, preferences, and engagement.
- Publish semantic layers (metrics definitions, certified datasets, business logic) consumed by downstream BI tools and AI agents; build and deploy agentic workflows using Databricks AI Functions or similar frameworks.
- Ensure data quality, integrity, and governance across all consumer data assets by implementing validation rules, schema evolution controls, and monitoring processes through Unity Catalog.
- Collaborate with data scientists, business analysts, and marketing teams to understand data needs and translate them into technical data engineering solutions; partner to productionize ML models and feature stores on Databricks.
- Implement automation for data ingestion, processing, and delivery with a focus on efficiency, reliability, and SLA adherence.
- Troubleshoot and resolve data-related issues, performing root cause analysis and implementing corrective actions.
- Stay current with Databricks platform updates, AWS data services, and emerging best practices in data engineering and AI-driven analytics.
- Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related quantitative field.
- 3-8 years of data engineering experience with hands-on production experience on Databricks.
- Deep knowledge of Databricks platform architecture — Unity Catalog, Delta Lake, Databricks Workflows, Databricks SQL, and cluster/compute management. (Preferred)
Qualifications
- Strong proficiency in Python and PySpark; advanced SQL for complex analytical workloads.
- Familiarity with Software Development Life Cycle (SDLC) practices — including version control (Git), CI/CD pipelines, code reviews, and agile development methodologies. (Preferred)
- Strong understanding of data warehousing concepts, dimensional modeling, and data governance principles.
- Hands-on experience building semantic layers (e.g., dbt metrics, Databricks AI/BI semantic layer) and creating AI agents or agentic pipelines (Databricks AI Functions etc.) .
- Excellent problem-solving, communication, and stakeholder collaboration skills.
Verify Lilly for this role
Free PRACTICE for Lilly adds a verified skill signal that can boost how roles like this rank for you — optional, not required to browse or apply.
Sign up — verify Lilly free →Want match scores and deeper insight? Create a free candidate profile
Job application FAQ
Last updated 4 October 2026
- How do I apply for Consultant/Sr. Consultant, Consumer Analytics Data Engineering at Lilly?
- Open this job on Feedback AI and sign up free (or sign in). You can apply from the job detail page; match scores and skill gaps appear when your profile is complete. Lilly may attach structured assessments to interview rounds after you apply.
- Does Feedback AI show a match score for this Consultant/Sr. Consultant, Consumer Analytics Data Engineering role?
- Yes after you add a resume or skills. Match score ranks this role against your profile — skills met, gaps, level, and location — so you prioritise applications where fit is strongest.
- Is Consultant/Sr. Consultant, Consumer Analytics Data Engineering remote or on-site in Bengaluru, Karnataka?
- This listing is marked on_site with location Bengaluru, Karnataka. Confirm details on the job description before applying.
- What skills matter for this Consultant/Sr. Consultant, Consumer Analytics Data Engineering role at Lilly?
- This is a senior Consultant/Sr. Consultant, Consumer Analytics Data Engineering role. Key skills include skills listed in the job description. Feedback AI highlights matched vs missing skills on your profile after signup.