dbt Model Development
Manager · SQL & ETL Support · Hybrid · Saint-Jérôme
- Company
- Series B medical devices company for dental practices · 51–200 employeesCL-21510 · based in Saint-Jérôme
- Where
- Hybrid · Saint-Jérôme
- Format
- Task bundle
- Time needed
- 10–24 h a month
- Start
- Starts next week
- Level
- Manager · 7-12 years
- When you work
- Weekday evenings2 h a week overlap with ET
- Language
- English and Frenchbusiness level
823 tasks of this type completed on Deftridge
About this task
This Series B medical devices company for dental practices (51–200 employees) is looking for a manager SQL & ETL Support for a monthly bundle of recurring tasks, 10–24 h a month. Builds clean, tested models from raw tables.
A named list of recurring items keeps the month predictable for both sides. It works in healthcare, so patient data is never part of the task and privacy rules are strict.
The team sits in Saint-Jérôme. Everything can be done remotely; an occasional visit is welcome and never required for the first month. Most people do this on weekday evenings; replies inside the working day are not expected. About 2 hours a week should overlap with the team's day (ET).
What you deliver
- Build staging and mart models for subscriptions with tests and documentation.
- A running log of open questions, reviewed at the start of each week
- The monthly list of items completed, each with a link to the result
- 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 when the output matches the agreed checklist and the sample check passes; the recruiter confirms by e-mail.
Tools
Who fits
- 7-12 years of hands-on work as an SQL & ETL Support, or the equivalent mix of roles
- Business-level French as well as English: the documents and part of the team work in French
- 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
- Comfortable explaining numbers or decisions to a non-specialist reader
- 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
- Managing other contractors or employees
- Anything that needs a signature in your own name unless the brief says so
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
- Within one working dayA recruiter writes to you to confirm your hours and the rate you want.
- You agree the rateYou and the recruiter fix an exact rate inside the company's range. You decide whether to go ahead.
- With your written OKThe company sees the anonymous profile below. Most companies answer within three working days.
- 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.
- Experience
- 7-12 years in data & analytics
- Tools
- dbt, SQL, Snowflake
- Offers
- 17 hours a month, weekday evenings
- Rate
- CA$112 an hour, agreed with the recruiter
How this rate compares
The midpoint of this range, CA$112 an hour, is above the median manager SQL & ETL Support rate in Quebec (CA$110). The shaded band is the 25th to 75th percentile of the market.
All SQL & ETL Support jobs in Canada · SQL & ETL Support rates in Quebec · 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.
CL-21510 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.