Lead Data Analyst - D2C eCom Consultancy

www.cranberrypanda.co.uk - JobBoard; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading eCommerce consultancy in the UK is looking for a Lead BI Analyst to analyze customer behavior and optimize business growth strategies. The role requires strong DTC eCommerce experience and proficiency in data analysis tools like SQL and PowerBI. Enjoy remote work with occasional travel to London, and contribute to impactful projects enhancing client performance.

Qualifications

• Deep DTC eCommerce experience required.
• Fluent in analyzing business performance data.
• Ability to spot trends and design diagnostic frameworks.

Responsibilities

• Analyze customer behavior and order frequency.
• Develop actionable workflows to diagnose brand performance.
• Conduct light financial analysis for profitability.

Skills

DTC eCommerce experience

Business performance data analysis

Pattern recognition

SQL proficiency

PowerBI proficiency

Tools

Looker

PowerBI

SQL

Job description

Overview

LeadDataAnalyst UK - remote with monthly travel to London • Permanent

We’re looking for a LeadBIAnalyst with strong DTC eCommerce experience to work for a eCommerce consultancy who are building a proprietary business growth platform.

Scope of Work

• Customer&Order-Level Data Analysis – Identifies patterns in customer behavior, order frequency, retention, and product mix to diagnose key growth levers.
• Business Metrics Diagnosis – Builds a structured root-cause analysis framework that helps brands understand what’s driving or blocking scale (e.g., product mix efficiency, retention trends, discount impact).
• Light Financial Analysis – Incorporates key profitability signals (COGS, contribution margin, discounts) to ensure recommendations are commercially sound.
• Blended Marketing Insights – Surfaces insights at the business level with a light marketing lens (e.g., CAC, efficiency trends across channels).
• Actionable Workflow Development – The output must be a structured and repeatable process for diagnosing DTC brand performance, not just ad-hoc insights.

Ideal Candidate

• Deep DTC eCommerce Experience – Understand how order-level, customer cohort, and retention trends impact scale.
• BI & Data Fluency – Comfortable structuring and analyzing business performance data rather than purely marketing or financial data.
• Pattern Recognition & Root Cause Thinking – Can spot trends quickly and design a framework that helps businesses consistently diagnose their growth blockers.
• Tool Proficiency – SQL, Looker, PowerBI, or similar tools to rapidly extract and visualize insights.
• Fast Execution & Clear Thinking – Can move quickly to develop a structured approach for ongoing analysis.

Contact

Get in touch with Yasha Mirsamadi, Associate Director at cranberry panda, for all of your ecommerce jobs and digital recruitment needs.