Self-Serve Data Model Design
Senior · BI Analyst · Remote · Ontario only
- Company
- Omnichannel retailer · 201–500 employeesCL-64809 · based in Grand Forks
- Where
- Remote · Ontario only
- Format
- One-off task
- Time needed
- about 15 h in total
- Start
- Starts within 7 days
- Level
- Senior · 5-10 years
- When you work
- Flexible hours, async
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.
5 professionals have asked about this task336 tasks of this type completed on Deftridge
About this task
This omnichannel retailer (201–500 employees) is looking for a senior BI Analyst for a single piece of work with a fixed scope and a fixed price. A governed model that lets business users build their own reports.
A fresh pair of experienced eyes is needed, and the result is a document or file the team can use straight away. It is a retailer with stores and an online channel, and the team works to a weekly trading rhythm.
The work is fully remote, but the company can only contract people who live in Ontario, so this one is for residents there. You choose your hours; nothing is scheduled except an occasional short call.
What you deliver
- Create a LookML explore for sales and finance with certified measures and documentation.
- A 20-minute walkthrough call, or a recorded screen share if you prefer
- One round of edits after the company's review is included
- The finished deliverable in the agreed file format, with sources and assumptions listed
How the work runs
- Day 1: kickoff call and access to the files
- Days 2 to 10: the work, with questions answered the same day
- Last day: delivery and a short walkthrough
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
Who fits
- 5-10 years of hands-on work as a BI Analyst, or the equivalent mix of roles
- Comfortable working in LookML, dbt and SQL
- Your own work history stays private; the company sees a first name, your field and a rate
Nice to have
- A habit of asking one clarifying question early rather than five late
- Experience in a similar industry
Not included
- Anything that needs a signature in your own name unless the brief says so
- On-call availability outside the agreed window
- Work outside the scope written in the brief; extra items are quoted separately
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
- 5-10 years in data & analytics
- Tools
- LookML, dbt, SQL
- Offers
- 15 hours in total, weekday evenings
- Rate
- CA$64 an hour, agreed with the recruiter
How this rate compares
The midpoint of this range, CA$64 an hour, is below the median senior BI Analyst rate in Ontario (CA$65). The shaded band is the 25th to 75th percentile of the market.
All BI Analyst jobs in Canada · BI Analyst rates in Ontario · 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-64809 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.