Recruiter screen, technical phone (SQL + data modeling), virtual onsite with coding round (Spark/Snowflake), system design on a data warehouse migration, Life Story round, and team-fit. Shopify Data is one of the larger data orgs in commerce.
Walk me through a data quality issue you found. How did you resolve it?
Tell me about migrating a critical pipeline with zero downtime.
Describe partnering with analytics on a metric definition disagreement.
How do you balance data warehouse cost vs. query performance?
Merchant Success Manager
virtual
· Difficulty 3/5
Recruiter screen, hiring manager video, merchant scenario role-play, behavioral, and Life Story / final with director. Shopify Plus serves high-GMV merchants and the role is strategic relationship management.
Walk me through a merchant you saved from churn.
Tell me about advising a merchant against a feature they wanted.
Describe partnering with the AE on a renewal expansion.
How do you stay credible with a merchant whose business you don't fully understand?
Product Designer
virtual
· Difficulty 4/5
Portfolio review, design exercise (rethink a checkout flow for a Shopify merchant), critique session, cross-functional with PM and engineering, and Life Story / culture round. Shopify designers are expected to write production code (Polaris design system).
Walk me through a design that shipped. What's the production impact?
Tell me about a project where research changed your mind fundamentally.
Describe partnering with engineering on a design system contribution.
How do you balance designing for new merchants vs. established merchants?