Shopify SQL Pair Programming Interview
Have an upcoming interview with Shopify for a Senior Data Analyst position. The interviewer is a Senior DS, it'll be a pair programming interview where I will have to explore a dataset in SQL. I'm allowed to use chatgpt, stack overflow etc for my analysis. Never really given an interview like this before, any tips as to what to expect, what should I prepare for? This is for the Content Management team just FYI
This is the best type of interview
Any reason you’re proceeding with an interview at Shopify ? Read the reviews on culture and recent state of affairs at that company. It is not great .
I'm not in a situation to be picky right now. (Need a remote position due to personal reasons)
Ok. hope things work out. Keep your head down and stay clear of some of the leadership . It can be a bit toxic in spots
What is the TC that is being offered for the role?
Many websites with question examples like data lemur and stratascrstch
Is this interview more to flex your SQL skills or business domain knowledge skills? Ie, what metrics you should be pulling them etc?
I dont know for Shopify. I think it’ll be like an SQL interview but they might add requirements along the way. In any regular SQL problem you have to figure out which metrics to use, but you typically get a few and it’s very obvious what you need.