<!-- canonical: https://deftridge.com/job/customer-segmentation-analysis-united-kingdom-dt-4504465/ -->
Source: https://deftridge.com/job/customer-segmentation-analysis-united-kingdom-dt-4504465/
Title: Customer Segmentation Analysis, remote, UK | Deftridge
Summary: Customer Segmentation Analysis (SQL) for a manager Data Analyst, remote in the UK. £43-£52 an hour, about 12 hours in total. Starts next week.

One-off Shortlisting · 5 candidates Posted Oct 22 · DT-4504465

# Customer Segmentation Analysis (SQL)

Manager · Data Analyst · Remote · United Kingdom

**£43–£52** / hour About £380–£760 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** Specialty insurer for homeowners · 51–200 employeesCL-13720 · based in York

- **Where** Remote · United Kingdom

- **Format** One-off task

- **Time needed** about 12 h in total

- **Start** Starts next week

- **Level** Manager · 7-12 years

- **When you work** Weekday evenings1 h a week overlap with UK time

The company is already looking at 5 profiles for this task. It is still open: new profiles are added to the shortlist until the company decides.

**13** professionals have asked about this task **1,049** tasks of this type completed on Deftridge

## About this task

This specialty insurer for homeowners (51–200 employees) is looking for a manager Data Analyst for a single piece of work with a fixed scope and a fixed price. Groups customers by behaviour and value and names the segments.

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 United Kingdom works, with a few hours of overlap with the team's day. Most people do this on weekday evenings; replies inside the working day are not expected. About 1 hour a week should overlap with the team's day (UK time).

## What you deliver

- Segment 40,000 customers by order frequency and margin and describe five groups with actions.

- A final note stating what was checked and what was left out of scope

- 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: kickoff call and access to the files

- Days 2 to 8: the work, with questions answered the same day

- Last day: delivery and a short walkthrough

**Duration:** about 10 working days. Accepted when the company contact confirms the deliverable against the written checklist. One round of edits is included.

## Tools

SQL Python Excel

## Who fits

- 7-12 years of hands-on work as a Data Analyst, or the equivalent mix of roles

- Comfortable working in SQL, Python and Excel

- Your own work history stays private; the company sees a first name, your field and a rate

### Nice to have

- Experience in a similar industry

- Comfortable explaining numbers or decisions to a non-specialist reader

## Not included

- Travel or work at a fixed location

- Managing other contractors or employees

- 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 GBP 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, Python, Excel

- **Offers** 12 hours in total, weekday evenings

- **Rate** £48 an hour, agreed with the recruiter

## How this rate compares

The midpoint of this range, £48 an hour, is **above** the median manager Data Analyst rate in the United Kingdom (£45). The shaded band is the 25th to 75th percentile of the market.

Median £45

This task £48

£37 £64

[All Data Analyst jobs in United Kingdom](https://deftridge.com/jobs/data-analyst/united-kingdom/) · [Data Analyst rates in United Kingdom](https://deftridge.com/rates/data-analyst/united-kingdom/) · [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-13720 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, Customer Segmentation Analysis (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 1

### [Survey and CRM Data Merge · Logistics](https://deftridge.com/job/survey-and-crm-data-merge-united-kingdom-dt-2860619/)

Manager · Data Analyst

Supply-chain software company with a cold-chain network · 201–500 employees

**£46–£56** / hour

About £200–£510 in total

- about 7 h in total

- Remote · United Kingdom

- Starts next week

- Top 25% for the role

[View task](https://deftridge.com/job/survey-and-crm-data-merge-united-kingdom-dt-2860619/)

One-off Posted Oct 30

### [A/B Test Readout (SQL)](https://deftridge.com/job/ab-test-readout-london-dt-2819179/)

Manager · Data Analyst

Insurtech company covering small businesses · 201–500 employees

**£57–£66** / hour

About £180–£370 in total

- about 4 h in total

- Hybrid · London

- Starts within 7 days

- Top 25% for the role

[View task](https://deftridge.com/job/ab-test-readout-london-dt-2819179/)

One-off Posted Oct 28

### [Ad Hoc Analysis Request (SQL)](https://deftridge.com/job/ad-hoc-analysis-request-dundee-dt-7066745/)

Manager · Data Analyst

Supply-chain software company with cross-border freight · 51–200 employees

**£49–£54** / hour

About £150–£410 in total

- about 6 h in total

- Hybrid · Dundee

- Starts within 7 days

- Top 25% for the role

[View task](https://deftridge.com/job/ad-hoc-analysis-request-dundee-dt-7066745/)

**£43–£52 / hr** I'm interested
