Margin by Segment Analysis (Excel)

About this task

This property and casualty insurer covering fleets and logistics (11–50 employees) is looking for a manager Pricing & Competitive Analyst for a single piece of work with a fixed scope and a fixed price. Contribution margin by product and customer type.

It is a self-contained job: scope, checklist and price are agreed before you start. 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. You choose your hours; nothing is scheduled except an occasional short call.

What you deliver

• Calculate gross margin by customer segment and highlight the three least profitable groups.
• One round of edits after the company's review is included
• A 20-minute walkthrough call, or a recorded screen share if you prefer
• The finished deliverable in the agreed file format, with sources and assumptions listed

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: 1 to 2 weeks. Accepted after the walkthrough. Edits requested within three working days are part of the price.

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$133 an hour, is above the median manager Pricing & Competitive Analyst rate in Canada (CA$130). The shaded band is the 25th to 75th percentile of the market.

All Pricing & Competitive Analyst jobs in Canada · Pricing & Competitive Analyst rates in Canada · 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.