Shopify & SQL Expert
Mercor • Remote
Education
Not stated
Type
Hourly
Pay Rate
$60/hr
Listed
74d ago
Apply opens Mercor in a new tab.
Apply Now → ⚡ Boost your chances - Optimize your resume with Rezi.aiWhat We Know About This Role
- Weekly hours
- 5–10 hrs/week
About this role
From the Mercor listing
About the role
You'll review real merchant conversations where Shopify’s Sidekick answered an analytics or segmentation question and the merchant was unhappy — pinpoint the failing query or filter, determine what it 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: ~5–10 hours/week
Qualifications
Required:
- Strong general SQL — comfortably read, write, and critique queries:
WHEREvsHAVING,GROUP BY,ORDER BY/LIMIT, joins, and aggregation. You should be able to look at a query and say what it returns and what's wrong with it.
Strongly preferred:
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 Sidekick — you've used Shopify's Sidekick AI assistant yourself.
Preferred (nice to have — we'll help you ramp on the specifics):
Familiarity with Shopify analytics / ShopifyQL and the Shopify data model — the schemas (
sales,payments,sessions,fulfillments,customers), metric nuances (e.g.net_items_soldincludes returns vsquantity_ordered; revenue vs unit counts for "best-selling"), and the segmentation model (products_purchased MATCHES, operators,AND/ORconnectors).General e-commerce / analytics ops experience.
How long hiring takes
Across the AI training platforms we refer candidates to, the median gap between referral and hire is about 30 days. It varies by platform and role, so treat it as a rough guide for this one.
Talent Pool members
Apply through this link and we can put you forward to Mercor when your profile is a strong match. Not every applicant is submitted. If you're not in the pool yet, set up your profile first.
Set up your profile →Interview Prep
This listing calls for this tool directly. Prep for the technical screen:
Why this role
AI labs pay $60/hr for a Shopify & SQL Expert because getting Software Engineering nuance wrong in a training set is expensive to fix later. That's what this rate is pricing in.
Skills and categories
Explore other opportunities in related specializations:
Related jobs
Legal Expert — Data Privacy and Cybersecurity
mercor • Software Engineering
$120 /hr
Cybersecurity Practitioner: Paid Expert Interviews (SOC, Incident Response, Detection, AppSec)
mercor • Software Engineering
$175 /hr
Cybersecurity Practitioner: Paid Expert Interviews (SOC, Incident Response, Detection, AppSec)
mercor • Software Engineering
$175 /hr
Power Systems Engineer (Substation, Transmission, Interconnection)
mercor • Software Engineering
$70 /hr
Browse All Jobs from Mercor
Discover more opportunities on Mercor that match your skills and interests.
View All Mercor Jobs →Verified Reviews
Community Reviews
Share your experience with Mercor
Help other candidates make better decisions by leaving a review.
Sign in to leave a reviewLeave your review
Common questions
Does Mercor's application require an on-camera interview?
Yes, every applicant records a video interview with an AI interviewer that asks questions about your resume. Clients review that recording to judge communication skills before matching, so there's no way to apply without going on camera.
Does it cost money to apply to Mercor?
No, applying and joining Mercor is free. Mercor's revenue comes from a fee it charges the client on top of your hourly rate, not from applicants. Treat any request for payment to join as a red flag.
What does task-based AI training work look like?
Practical, hands-on data work: recording short videos, categorizing images, rating text responses, or analyzing data. Tasks are designed to be short and distinct, typically 5 to 60 minutes each.
What does Software Engineering work look like for a Shopify & SQL Expert?
Tasks here are scoped to Software Engineering, not generic labeling. As a Shopify & SQL Expert, expect to draw on real domain judgment (evaluating outputs, correcting errors, or providing expert reasoning specific to Software Engineering) rather than following a one-size-fits-all rubric. If you don't have hands-on Software Engineering background, this is likely not the right listing to start with.
What specific skills does this listing call for?
Expert is named directly in the listing. If you don't have hands-on experience with this, expect the screening process to test for it directly rather than accepting adjacent experience as a substitute.
How many hours per week does this role require?
Based on the listing, this role is scoped at 5–10 hours per week. Treat this as a real commitment expectation, not a loose estimate.
How much does this specific role pay?
This listing is posted at $60/hr, an hourly rate. Pay can change between when we last checked the listing and when you apply, so confirm the current number on the platform's own application page before committing time.
What happens when I click Apply on this listing?
You'll be taken to Mercor's external site to complete your application there. This listing links through a referral, but the process is identical to applying directly; the link just routes you correctly. Create an account on their site and follow their onboarding steps.
How soon will I start working after applying to Mercor?
Not immediately. Mercor is a talent marketplace, not a task queue, so applying puts you in a pool of candidates. You start working only once a specific client, like a major AI lab, selects your profile, and that matching process can take weeks.