Shopify Data Analyst interview questions

1 Data Analyst has shared notes from their Shopify interview, with the questions they were asked. That is 3% of the 29 Shopify interview notes on Screna AI.

1 Data Analyst interview note

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.”

View Post