Shopify & SQL Expert

About the Role

You'll review real merchant conversations where Shopify's Sidekick AI assistant answered an analytics or segmentation question and the merchant was left unhappy with the result. You'll pinpoint the failing query or filter, determine what the correct version should have been, and categorize the error against a detailed rubric.

What You'll Do

• Read multi-turn merchant-agent conversations, including tool-call cards and the data they return
• Identify the query or segment filter the assistant generated, and determine the correct version
• Categorize why the response fell short (wrong metric, dimension, filter, unsupported report, etc.)
• Write concise, objective explanations of what went wrong
• Commitment: approximately 5-10 hours per week

Requirements

• Strong general SQL skills — comfortably read, write, and critique queries: WHERE vs. HAVING, GROUP BY, ORDER BY / LIMIT, joins, and aggregation

Preferred Qualifications

• Hands-on Shopify merchant experience — you've run or operated a Shopify store and know how merchants actually use analytics and segmentation
• First-hand experience using Shopify's Sidekick AI assistant
• Familiarity with Shopify analytics / ShopifyQL and the Shopify data model (schemas, metric nuances, segmentation model), plus general e-commerce / analytics operations experience

Compensation & Logistics

• Type: Independent Contractor
• Compensation: Competitive, paid weekly via Stripe or Wise
• Location: Remote, approximately 5-10 hours/week

Application Process

Submit your resume or relevant technical background to get started. Qualified applicants may be asked to complete a brief technical assessment or submit additional information. Applications are reviewed on a rolling basis.