Dataford
Top 42
Prep plan
Updated weekly · Last refresh Aug 30

Eli Lilly and Consultant Interview Questions

The questions to prepare for a Eli Lilly and Consultant interview. Questions from real interview reports rank first. Updated weekly.

42questions
~6htotal time
Track your progressSign up free to work through all 42 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 4 questions · ~32 min
Demonstrating Project LeadershipMedium

Tests your leadership behaviors and influence during research or analytical work.

Success CriteriaRoadmappingRisk AssessmentEli Lilly and
Improve a Business ProcessMedium

Tests structured problem solving and execution planning for process improvements at Eli Lilly and.

Trade-offsRoadmappingRisk AssessmentEli Lilly and
More Execution questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
SQL and Problem SolvingMedium

Tests baseline SQL proficiency and your approach to structured reasoning and estimation.

JoinsData WranglingAggregationsEli Lilly and
Fundamental SQL Case ExercisesEasy

Tests SQL fundamentals and structured problem-solving approach used in the interview process.

JoinsData WranglingAggregationsEli Lilly and
Write and Explain SQL QueriesMedium

Tests ability to write correct SQL and explain reasoning clearly for data problems.

Window FunctionsJoinsAggregationsEli Lilly and
Active Customer List by CityEasy
Practice
Practice drill

Retrieve active customers from a single table, grouped by city with a customer count and sorted by highest count.

JoinsData WranglingAggregationsEli Lilly and
Window Functions SQL QueryMedium
Practice
Practice drill

Rank Eli Lilly products by regional completed prescription revenue using aggregation, joins, a CTE, and RANK().

Window FunctionsRankingRunning TotalsEli Lilly and
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership30 questions · ~240 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Develop a New Market GTM StrategyEasy

Approach for building a go-to-market strategy for a new market or solution.

Competitive AnalysisGo-to-MarketGrowth StrategyEli Lilly and
Analyze Clinical Trial ResultsHard

Tests statistical reasoning and ability to interpret clinical trial data for decision-making.

Confidence IntervalsExperimentationHypothesis TestingEli Lilly and
Sizing and Alignment PlanningHard

Tests your ability to plan and scope client work with clear alignment and realistic execution.

PlanningMarket SizingEli Lilly and

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 42 questions plus 3 hands-on drills to finish this plan.