Insight Interview Questions
The questions to prepare for Insight interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreAggregate Snowflake partition usage and rank the highest-consuming partitions, including ties.
Snowflake ComputingApproach for maintaining data quality and integrity across ETL pipelines.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain a controlled month-end close, including reconciliations, accruals, variance analysis, review, and GAAP financial statement completion.
Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.
Design an LLM serving system that balances latency, cost, scalability, and safety for production traffic.
Summarize relevant product experience, emphasizing user needs, decisions, outcomes, and lessons learned.
Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.
Reduce hallucinations in a RAG system even when retrieval is already correct, using grounding, verification, and evaluation.