I applied online. The process took 4 weeks. I interviewed at Shopify in Sept 2025
Interview
1) An OA where AI use is allowed: one SQL and one Python question. With AI, only took about 15 minutes.
2) A take-home assessment with several datasets, specific querying questions, and open-ended questions. I used pandas for this portion. AI is allowed. A small report required to summarize and share your insights.
3) Technical interview: Very similar to the take home, but done in SQL. Be prepared to use AI to your fullest extent. I essentially copy pasted the question into ChatGPT and got the answer. Make sure you understand the code being outputted and are able to show creativity and logic.
4) Behavioral interview: A resume walk-through with questions focused on your passions and what led you to this role, and some STAR questions. Nothing out of the ordinary here.
Interview questions [1]
Question 1
Types of joins and their differences, how to identify NULLS in a dataset.
I applied online. The process took 4 weeks. I interviewed at Shopify
Interview
First, an OA including Python and SQL questions. Then an interview of only SQL, where we could use AI to help us. Then a life story interview, which was fully behavioural.
Top companies for "Compensation and Benefits" near you
