Duplicate Record Resolution (SQL)

About this task

This Series B accounting software company for e-commerce sellers (51–200 employees) is looking for a specialist Data Quality Analyst for a monthly bundle of recurring tasks, 8–20 h a month. Finds and merges duplicate accounts and contacts.

A named list of recurring items keeps the month predictable for both sides. It operates in regulated payments and lending, so a written trail for every decision matters.

The work is fully remote, but the company can only contract people who live in Alberta, so this one is for residents there. You choose your hours; nothing is scheduled except an occasional short call. About 2 hours a week should overlap with the team's day (MT).

What you deliver

• Identify 4,000 likely duplicate accounts in the CRM and prepare a merge file with rules.
• The monthly list of items completed, each with a link to the result
• A month-end summary with hours used against the cap
• A named list of items moved to next month, so nothing is lost

What a month looks like

• Week 1: intake call and a list of what is due this month
• Weeks 2 and 3: items completed in short sessions
• Week 4: month-end summary and the list for next month

Duration: 12 weeks, with a monthly hours cap. Accepted on the company's written OK. If something is missed, you fix it in the same week at no extra charge to either side.

Tools

How you get paid

• The company prepays Deftridge before your first hour, so payment does not depend on a late invoice.
• Deftridge pays you in CAD after the company confirms the hours or the deliverable. The payment date is written in your task agreement.
• You work as an independent contractor: you report your own income, and your recruiter sends the statements your accountant needs.
• You never chase the company. Questions about money go to Deftridge.

What happens after you say you're interested

1. Within one working dayA recruiter writes to you to confirm your hours and the rate you want.
2. You agree the rateYou and the recruiter fix an exact rate inside the company's range. You decide whether to go ahead.
3. With your written OKThe company sees the anonymous profile below. Most companies answer within three working days.
4. StartYou sign the task agreement and the company's confidentiality terms through Deftridge, and begin on the date above.

What the company sees about you

First name, field, experience, tools and the hours you offer. Not your surname, your employer or your contact details.

How this rate compares

The midpoint of this range, CA$50 an hour, is in line with the median specialist Data Quality Analyst rate in Alberta (CA$50). The shaded band is the 25th to 75th percentile of the market.

All Data Quality Analyst jobs in Canada · Data Quality Analyst rates in Alberta · Data & Analytics jobs

Questions about pay and privacy

The rules are the same for every task. Pricing explains the 15% fee, prepayment and when you are paid; How it works covers matching, what the company sees and side work next to a job.