Process
First step was recruiter screen. After that it's a 1-hour SQL pairing exercise. For the SQL Screen, you are encouraged to use AI and it is done through CoderPad.
Questions
First two questions are relatively straightforward with aggregations.
The third question involves a cross join with a date spine. Basically you have some activities on certain dates, and need to fill in the activity count on missing dates with 0.
I did not get a chance to look at the fourth question.
Was this helpful?
Interview Statistics
The following metrics were computed from 11 interview experiences for the Shopify Data Engineer role.
Success Rate
Shopify's interview process for their Data Engineer roles is very selective, failing most engineers who go through it.
Experience Rating
Candidates reported having very good feelings for Shopify's Data Engineer interview process.
Shopify Work Experiences
- 5.0great company!Data Engineer • Current EmployeeToronto, ONApril 17, 2026Pros: - Work from home. - Flexible. - Tech forward.Cons: - Can be stressful and fast-paced
- 5.0Flexible But Low PayData Engineer • Current EmployeeNew York, New York, United StatesApril 7, 2023Pros: Flexible hours and work environmentCons: Low salary and bossy culture
- 1.0Used to be goodData Engineer • Former EmployeeBerlin, Berlin, GermanyMay 21, 2023Pros: None. Used to be good, now it's just very bad.Cons: Bad leadership that is not trustworthy.
Shopify Interview Questions
