Based on six candidate reports, Shopee's Business Intelligence interviews usually start with an HR screen, followed by a SQL-focused technical check and a hiring-manager round that sometimes includes case-style business questions.
$98K
Avg. Base Comp
$115K
Avg. Total Comp
Not reported
Typical Rounds
Not reported
Process Length
Across six candidate reports, Shopee's Business Intelligence interviews usually begin with an HR conversation and then move to a technical check. Several candidates describe a SQL assessment, sometimes with Excel, Python or numerical reasoning, completed over a couple of days. One candidate was asked to write queries and spot errors in MySQL code. Another took online tests with screen recording and webcam on.
The hiring-manager round is where reports diverge most. Some candidates describe a technical discussion of their assignment, including why they chose a particular SQL approach and what alternatives existed. Others describe business case questions: diagnosing a drop in customer satisfaction, working out why a feature like self-collection was not catching on, analysing a marketing campaign, or improving an expansion strategy for Indonesia. In the most open-ended case, the candidate said the context was thin and wished they had pressed harder with clarifying questions.
Outcomes were mixed. Two candidates received offers, including one internship candidate, and four did not advance. Two of the rejected candidates reported little or no feedback after their later rounds. Preparation should therefore cover clean SQL you can explain and defend, plus a structured way to investigate a metric: ask about constraints and available data, form hypotheses, and say how you would communicate findings. Behavioral answers in STAR format also came up in the internship report.
Synthesized from 6 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
Describing a data project and its challenges
| Question | |
|---|---|
| Real-Time Transaction Streaming | |
| Promoting Instagram | |
| Categorize Sales | |
| Slow SQL Query | |
| Find Duplicate Numbers in a List | |
| Career Jumping | |
| A/B Testing a Checkout Button Change | |
| Open Source Reporting Pipeline | |
| Addressing Data Quality Issues | |
| Blob Indexing | |
| Weighted Average Sales | |
| Optimize Model Performance | |
| Why Do You Want to Work With Us | |
| Boosting Instagram Stories | |
| Youtube Recommendations | |
| Your Strengths and Weaknesses | |
| Google Docs Drop | |
| Evaluating Revenue Decline | |
| Regularization and Validation | |
| Unified Live Comments | |
| LRU Cache 1 | |
| Influencer Metrics | |
| E-Commerce Subscription Retention | |
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Experiment Validity | |
| Top Three Salaries | |
| Customer Orders | |
| Button AB Test |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report an initial HR conversation that covers your background and why you want the role. Some reports also mention salary expectations and Excel or PowerPoint skills, and one included a market sizing question. One candidate took this screen over Zoom. Expect it to be fairly conversational.
Several candidates describe a take-home or online assessment completed within a few days. Reported content includes SQL writing, spotting errors in MySQL code, Excel, Python and numerical reasoning. One candidate said the test was recorded with screen capture and webcam. Formats may differ by team and level.
Candidates report meeting a BI lead, line manager or hiring manager. Reported content includes walking through assessment answers, defending SQL choices and discussing alternative approaches, and a live SQL test. One candidate also discussed preferred coding languages. Prepare to explain your reasoning, not just produce the query.
Some candidates report case studies built around business problems such as customer satisfaction drops, low feature adoption, marketing campaign analysis or regional expansion strategy. Interviewers appear to value a clear methodology and good clarifying questions. Not every candidate reported a case round.
Some candidates describe behavioral questions about past impact, and one internship candidate mentions STAR-style answers. In one report a planned final round with the manager's boss never happened. Two candidates reported slow or absent feedback after their later rounds, while others found recruiters responsive.
