Source: https://deftridge.com/job/dbt-model-development-canada-dt-4251655/ Title: dbt Model Development, CA$71-80/h | Deftridge Summary: dbt Model Development for a specialist SQL & ETL Support, remote in Canada. CA$71-CA$80 an hour, 10 to 24 hours a month. Starts within 7 days. Bundle Posted Oct 28 · DT-4251655 # dbt Model Development Specialist · SQL & ETL Support · Remote · Canada **CA$71–CA$80** / hour About CA$760–CA$1,810 a month. 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** Health insurer for gig workers · 201–500 employeesCL-32638 · based in Grande Prairie - **Where** Remote · Canada - **Format** Task bundle - **Time needed** 10–24 h a month - **Start** Starts within 7 days - **Level** Specialist · 2-5 years - **When you work** Two set slots a week **822** tasks of this type completed on Deftridge ## About this task This health insurer for gig workers (201–500 employees) is looking for a specialist SQL & ETL Support for a monthly bundle of recurring tasks, 10–24 h a month. Builds clean, tested models from raw tables. The same kind of work comes back every month, so the company prefers one person with an hours cap over ad-hoc requests. It is an insurer, so accuracy and an audit trail come before speed. The work is fully remote. Any location in Canada works, with a few hours of overlap with the team's day. The work runs in two set slots a week, agreed with the team at the start. ## What you deliver - Build staging and mart models for subscriptions with tests and documentation. - A named list of items moved to next month, so nothing is lost - A running log of open questions, reviewed at the start of each week - A month-end summary with hours used against the cap ## 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 when the company contact confirms the deliverable against the written checklist. One round of edits is included. ## Tools dbt SQL Snowflake ## Who fits - 2-5 years of hands-on work as an SQL & ETL Support, or the equivalent mix of roles - Comfortable working in dbt, SQL and Snowflake - 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 - A habit of asking one clarifying question early rather than five late ## Not included - Work outside the scope written in the brief; extra items are quoted separately - On-call availability outside the agreed window - Travel or work at a fixed location ## 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** Specialist SQL & ETL Support - **Experience** 2-5 years in data & analytics - **Tools** dbt, SQL, Snowflake - **Offers** 17 hours a month, weekday evenings - **Rate** CA$76 an hour, agreed with the recruiter ## How this rate compares The midpoint of this range, CA$76 an hour, is **above** the median specialist SQL & ETL Support rate in Canada (CA$75). The shaded band is the 25th to 75th percentile of the market. Median CA$75 This task CA$76 CA$55 CA$95 [All SQL & ETL Support jobs in Canada](https://deftridge.com/jobs/sql-etl-support/canada/) · [SQL & ETL Support rates in Canada](https://deftridge.com/rates/sql-etl-support/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-32638 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, dbt Model Development 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 SQL & ETL Support tasks [All SQL & ETL Support jobs](https://deftridge.com/jobs/sql-etl-support/) One-off Posted Nov 2 ### [Warehouse Cost Review](https://deftridge.com/job/warehouse-cost-review-canada-dt-3966702/) Manager · SQL & ETL Support Management consulting firm for the public sector · 201–500 employees **CA$109–CA$137** / hour About CA$490–CA$980 in total - about 6 h in total - Remote · Canada - Starts within 7 days - Top 25% for the role [View task](https://deftridge.com/job/warehouse-cost-review-canada-dt-3966702/) Bundle Posted Nov 2 ### [dbt Model Development](https://deftridge.com/job/dbt-model-development-vancouver-dt-8186377/) Senior · SQL & ETL Support Aerospace supplier in space launch · 5,000+ employees **CA$92–CA$115** / hour About CA$1,040–CA$2,500 a month - 10–24 h a month - Hybrid · Vancouver - Starts next week - Top 25% for the role [View task](https://deftridge.com/job/dbt-model-development-vancouver-dt-8186377/) Regular Posted Nov 2 ### [Pipeline Failure Triage](https://deftridge.com/job/pipeline-failure-triage-canada-dt-8916998/) Manager · SQL & ETL Support Digital bank · 11–50 employees **CA$92–CA$113** / hour About CA$2,000 a month at 5 h a week - 3–6 h a week - Remote · Canada - Starts next week [View task](https://deftridge.com/job/pipeline-failure-triage-canada-dt-8916998/) **CA$71–CA$80 / hr** I'm interested