Shopee Data Analyst interview questions

The interview process for the Business Intelligence role at Shopee began with a phone screening conducted by HR, where I shared my background, interests, and expectations for the role. This was followed by a take-home technical test, which assessed my ability to work with SQL and analytical problem-solving in a real-world scenario. After passing the test, I moved on to the first-round team interview, which combined a live SQL test, a case study analysis, and a Q&A session. The questions focused on both technical execution and business thinking — including real scenarios like supporting customer service teams, investigating trends, and presenting metrics like GMV or resolution time.

The process included one assessment, an initial interview with HR, an interview with the team lead, and a final interview with the hiring manager. While the first few steps were standard, the final interview was uncomfortable — the hiring manager asked overly personal and intrusive questions, such as “What negative traits do your family usually point out about you?” Steel yourself if you plan to apply here; the last round crosses professional boundaries. The hiring manager also questioned my job-hopping — which felt hypocritical in hindsight after reviewing their own professional history online. Honestly, it’s disappointing that no one took the time to review or filter these types of questions. It reflects poorly on the company’s professionalism.