Sql jobs in United Kingdom

Location: UK - remote with monthly travel to London

Type: Permanent

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

Scope of Work:

• Customer & Order-Level Data Analysis – Identify patterns in customer behavior, order frequency, retention, and product mix to diagnose key growth levers.
• Business Metrics Diagnosis – Build 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 – Incorporate key profitability signals (COGS, contribution margin, discounts) to ensure recommendations are commercially sound.
• Blended Marketing Insights – Surface 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 – Understands 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, Power BI, or similar tools to rapidly extract and visualize insights.
• Fast Execution & Clear Thinking – Can move quickly to develop a structured approach for ongoing analysis.