Source: https://deftridge.com/job/ad-hoc-analysis-request-canada-dt-8783340/ Title: Ad Hoc Analysis Request (SQL), remote in Canada | Deftridge Summary: Ad Hoc Analysis Request (SQL) for a manager Data Analyst, remote in Canada. CA$97-CA$110 an hour, about 6 hours in total. Starts within 2 weeks. One-off Shortlisting · 3 candidates Posted Oct 23 · DT-8783340 # Ad Hoc Analysis Request (SQL) Manager · Data Analyst · Remote · Canada **CA$97–CA$110** / hour About CA$310–CA$830 in total. Set by the company within a range checked against market pay for the role; your recruiter agrees your exact rate with you before anything is sent. Deftridge adds 15% on top and bills it to the company, so **nothing comes out of your rate**. - **Company** Payroll and HR services provider · 11–50 employeesCL-60952 · based in North Vancouver - **Where** Remote · Canada - **Format** One-off task - **Time needed** about 6 h in total - **Start** Starts within 2 weeks - **Level** Manager · 7-12 years - **When you work** Flexible hours, async2 h a week overlap with PT The company is already looking at 3 profiles for this task. It is still open: new profiles are added to the shortlist until the company decides. **4** professionals have asked about this task **732** tasks of this type completed on Deftridge ## About this task This payroll and HR services provider (11–50 employees) is looking for a manager Data Analyst for a single piece of work with a fixed scope and a fixed price. A specific business question answered with data and a short write-up. It is a self-contained job: scope, checklist and price are agreed before you start. It works in staffing and HR technology, and the team is used to external specialists. The work is fully remote. Any location in Canada works, with a few hours of overlap with the team's day. You choose your hours; nothing is scheduled except an occasional short call. About 2 hours a week should overlap with the team's day (PT). ## What you deliver - Find out why trial-to-paid conversion fell in September: segment by channel and plan and write one page. - A 20-minute walkthrough call, or a recorded screen share if you prefer - A final note stating what was checked and what was left out of scope - One round of edits after the company's review is included ## How the work runs - Day 1: scope confirmed in writing, files shared - Middle of the period: draft shared for early feedback - Last day: final version and handover note **Duration:** about 10 working days. 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 SQL Excel Python ## Who fits - 7-12 years of hands-on work as a Data Analyst, or the equivalent mix of roles - Comfortable working in SQL, Excel and Python - Your own work history stays private; the company sees a first name, your field and a rate ### Nice to have - Used to short written handovers - Comfortable explaining numbers or decisions to a non-specialist reader ## Not included - Managing other contractors or employees - Travel or work at a fixed location - On-call availability outside the agreed window ## 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 day** A recruiter writes to you to confirm your hours and the rate you want. 1. **You agree the rate** You and the recruiter fix an exact rate inside the company's range. You decide whether to go ahead. 1. **With your written OK** The company sees the anonymous profile below. Most companies answer within three working days. 1. **Start** You 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. Your profile **Alex** Manager Data Analyst - **Experience** 7-12 years in data & analytics - **Tools** SQL, Excel, Python - **Offers** 6 hours in total, weekday evenings - **Rate** CA$104 an hour, agreed with the recruiter ## How this rate compares The midpoint of this range, CA$104 an hour, is **above** the median manager Data Analyst rate in Canada (CA$100). The shaded band is the 25th to 75th percentile of the market. Median CA$100 This task CA$104 CA$74 CA$132 [All Data Analyst jobs in Canada](https://deftridge.com/jobs/data-analyst/canada/) · [Data Analyst rates in Canada](https://deftridge.com/rates/data-analyst/canada/) · [Data & Analytics jobs](https://deftridge.com/jobs/data-and-analytics/) ## Questions about pay and privacy The rules are the same for every task. [Pricing](https://deftridge.com/pricing/) explains the 15% fee, prepayment and when you are paid; [How it works](https://deftridge.com/how-it-works/) covers matching, what the company sees and side work next to a job. CL-60952 is the Deftridge code for this company. Its name is shared only after you agree to an introduction, and you decide whether to go ahead. ## Interested in this task? Leave your first name and e-mail. You hear back from a recruiter inside one working day, and nothing reaches the company without your written OK. - You see and agree the rate before the company hears about you - Your employer and surname stay private - E-mail only, no phone calls Thank you, Ad Hoc Analysis Request (SQL) is noted. A recruiter writes to you from a @deftridge.com address within one working day; the next steps are listed on this page. ## More Data Analyst tasks [All Data Analyst jobs](https://deftridge.com/jobs/data-analyst/) One-off Posted Nov 2 ### [Spreadsheet to Database Migration](https://deftridge.com/job/spreadsheet-to-database-migration-toronto-dt-2001467/) Senior · Data Analyst Games studio making multiplayer shooters · 1,001–5,000 employees **CA$88–CA$100** / hour About CA$560–CA$1,320 in total - about 10 h in total - Hybrid · Toronto - Starts within 7 days - Top 25% for the role [View task](https://deftridge.com/job/spreadsheet-to-database-migration-toronto-dt-2001467/) One-off Posted Oct 31 ### [Customer Segmentation Analysis · Media](https://deftridge.com/job/customer-segmentation-analysis-canada-dt-8359725/) Senior · Data Analyst Publishing house in education · 201–500 employees **CA$89–CA$100** / hour About CA$760–CA$1,510 in total - about 12 h in total - Remote · Canada - Starts within 7 days - Top 25% for the role - 3 interested [View task](https://deftridge.com/job/customer-segmentation-analysis-canada-dt-8359725/) One-off Posted Oct 29 ### [Survey and CRM Data Merge](https://deftridge.com/job/survey-and-crm-data-merge-toronto-dt-3088081/) Manager · Data Analyst Games studio making multiplayer shooters · 1,001–5,000 employees **CA$100–CA$124** / hour About CA$450–CA$1,120 in total - about 7 h in total - Hybrid · Toronto - Starts within 2 weeks - Top 25% for the role [View task](https://deftridge.com/job/survey-and-crm-data-merge-toronto-dt-3088081/) **CA$97–CA$110 / hr** I'm interested