
Candidates for analyst-type roles at Shopee report an HR screen, practical SQL, Python or Excel assessments, and case interviews on success metrics. Here is how those stages were described and how to prepare.
$93K
Avg. Base Comp
$106K
Avg. Total Comp
Shopee analyst interview reports are scarce, and the two closest to this role, from a Consumer Insights Analyst and a senior project analyst, describe different processes, so treat them as separate data points.
The Consumer Insights Analyst described an HR screen followed by two take-home assignments covering SQL and Python. The assignments were described as easy, but the candidate spent more than six hours on them. SQL topics named were window functions, joins and aggregations. Case interviews followed, where the focus was methodology: root cause analysis, defining success metrics, and prioritizing under constraints. Sample prompts included how to define success for a feature or campaign, and how to suggest two or three homepage or search-bar improvements backed by metrics. Market sizing also came up.
The senior project analyst instead reported an Excel assessment on VLOOKUP and pivot tables. Conversations with HR and area leaders then covered retail dynamics, performance drivers, estimating growth for a key product, and the tools used in past roles.
To prepare, practice SQL window functions, joins and aggregations, rehearse a repeatable metrics framework, and be ready to walk through past analysis in detail. Both candidates also reported poor communication afterward: one saw the position frozen mid-process and the other heard nothing after following up. Ask early about timelines.
Synthesized from 3 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Shopee process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Shopee
Where and how could you promote Instagram through Facebook
Synthesized from candidate reports. Individual experiences may vary.
The Consumer Insights Analyst candidate reports starting with an HR screening call to assess fit before moving on. Be ready to explain your background and why you want an analyst role in e-commerce.
One candidate reports two take-home assignments testing SQL (window functions, joins, aggregations) and Python, taking over six hours despite being described as easy. Another reports an Excel assessment on VLOOKUP and pivot tables. The format may vary by team and role.
The Consumer Insights Analyst candidate reports ambiguous case problems where methodology mattered: root cause analysis, defining success metrics, prioritizing resources, and proposing two or three homepage or search improvements with supporting metrics. Market sizing questions also appeared.
One candidate reports brief, structured rounds of about 30-45 minutes each, including an HR interview, a user-focused interview and a board-level conversation. Another describes relaxed conversations with HR and area leaders. Topics included past tools and techniques, retail performance drivers, and how you tracked success in previous work.
Both analyst candidates report uncertainty after interviewing: one saw the position frozen for internal hiring reviews, and the other received no response to follow-ups. Applicants may want to ask recruiters about timelines at each stage.