Shopify·Data Analyst·Technical Phone Screen
Jun 2026
Shopify data/analytics interview with a SQL-focused technical screen. Single question but it had two parts and they clearly wanted you to know both approaches, not just one.
- You have a table with a URL column. Write a SQL query to pull out a specific segment of the URL, and show two ways to do it: one using regex extraction, one using string splitting. Then explain when you'd use each.
“I knew REGEXP_EXTRACT and I knew SPLIT_PART but I'd never been asked to compare them out loud before.”