I applied online. The process took 4 weeks. I interviewed at Shopify (Montreal, QC)
Interview
The process is pretty seamless and well organized. You start with the life story interview, and if you demonstrate culture fit, you'll move on to the technical interview where you meet your team lead, discuss a project of yours, and then try to solve a real-life problem.
Interview questions [1]
Question 1
Why are you interested in this position?
What would you add to your project if you had more time?
I applied through an employee referral. The process took 2 weeks. I interviewed at Shopify (Montreal, QC) in Apr 2025
Interview
First went through a screening with the HR partner and then got a technical interview lasting one hour with someone in the department of data platform (the hub & spoke) analytics engineer. Went through 5 questions with a relatively simple DB where I needed to write SQL code. I went overtime but the interviewer was late to the interview so could go overtime. I answered all questions correctly but throught the interview was making some small mistakes. I didn't get into the next round.
Interview questions [1]
Question 1
Questions about some sales and log tables. Write SQL code that generated the output they wanted.
