Orange Customer Insights Analyst Interview Questions
The questions to prepare for a Orange Customer Insights Analyst interview. Questions from real interview reports rank first. Updated weekly.
Calculate the monthly spending trends for customers using window functions and joins.
OrangeClean feedback data by filtering invalid rows and counting valid responses per channel.
OrangeBuild a monthly customer retention cohort table using CTEs, date math, and conditional aggregation.
Bolt
Dave
AffirmDesign an experiment to improve support satisfaction without harming retention, with power, guardrails, and a clear ship rule.
OrangeDesign an end-to-end A/B test for a new product change, including metrics, MDE, power, randomization, and launch decision rules.
OrangeSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how you have designed and implemented A/B tests, including hypothesis setup, analysis, and decision making.
OrangeAnalyze whether customer satisfaction is associated with retention using correlation, regression, and a confidence interval.
OrangeUse customer feedback to identify the biggest pain points in the user journey.
OrangeInvestigate a sudden drop in customer satisfaction and separate leading signals from the final NPS readout.
Orange