Top 50 Strategy & Data Analyst Interview Questions
The 50 most important questions to prepare for Strategy & Data Analyst interviews. Questions from real interview reports rank first. Updated weekly.
Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.
One
Celestica
TransCoreUse joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.
HarbourVest PartnersCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Explain how you prioritize work across multiple analytics projects with competing deadlines and stakeholders.
Bee Robotics
Flywire
EtsyExplain how you prioritize across multiple concurrent data engineering projects with competing stakeholder needs and limited capacity.
Cognixia
NBCUniversal
State StreetSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Set a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.
Lattice
Evernote
Belvedere TradingApproach for analyzing whether a new product category is worth entering and how to size and frame the opportunity.
DtsvDDAZN
AMD MedicomExplain what drives your best performance and connect it to building useful products for demanding users.
Siemens Healthineers
Cirrus Logic
DenodoExplain why an observed marketing relationship can be correlated without being causal, and how you would validate a true causal effect.
Rocket
Liftoff
Syracuse UniversityTests experimental design and causal measurement for incentive changes affecting Uber Drivers behavior.
Uber Drivers