Analytics Engineer

Crew Clothing Company; Kingston upon Thames; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

Crew Clothing Company seeks an Analytics Engineer to advance data and analytics capabilities across multiple brands. You will transform a Microsoft Fabric Lakehouse into actionable data products, dashboards and AI-assisted insights for trading, buying, retail and finance teams.

This AI-first role focuses on data pipelines, semantic modeling and live data decision-making, working with Claude Code, MCP tooling, and modern cloud platforms to deliver rapid, scalable analytics in a retail context.

Qualifications

• 3+ years’ experience in analytics engineering, BI development or data engineering.
• Strong SQL — write and optimise complex views, CTEs and window functions.
• Hands‑on Power BI experience, especially DAX and semantic model design.
• Familiarity with basic DevOps — Git workflows and deployment pipelines.
• Experience with Microsoft Fabric, Databricks or similar cloud data platforms.
• Genuine enthusiasm for AI‑assisted development and active tooling usage.
• Commercial awareness to translate retail problems into data requirements.

Responsibilities

• Own delivery against the D&A roadmap and data integration priorities.
• Build, maintain and document Fabric Lakehouse and data transformations.
• Extend and maintain the Power BI semantic model for new brands and data sources.
• Utilize Claude Code and MCP tooling in daily workflows for faster delivery.
• Apply DevOps practices to analytics pipelines and environment governance.
• Monitor Fabric Data Pipelines and ensure data quality across sources.
• Design dashboards used by senior leaders for trading, stock and store performance.
• Use Python for data manipulation where SQL/DAX aren’t ideal.
• Onboard new brands data onto the Fabric platform for group reporting.
• Maintain a data dictionary and deployment documentation.

Skills

SQL

BI development

Python

Retail analytics

Data modeling

AI tooling

Tools

Power BI

Python

Microsoft Fabric

Databricks

Job description

Analytics Engineer

Kingston-on-Thames (4 Days in Office, 1 Day from home)

37.5 hours per week

About The Business

Crew Clothing Company is a British lifestyle brand operating across four brands — Crew Clothing, Pringle of Scotland, Saltrock and Ben Sherman — with 120+ stores, a growing digital channel and an omnichannel customer experience. We are in the middle of a significant technology transformation: a new eCommerce platform, a new third-party logistics partner, and an upgrade to our ERP platform, all running concurrently and targeting delivery before the end of 2027.

Our IT team is small and highly capable. We are building an internal integration function and strengthening our in-house Data & Analytics capability — and these four roles are the foundation of that work.

Purpose Of The Role

Crew Clothing’s Data & Analytics team has built a modern data platform — a Microsoft Fabric Lakehouse sitting and a growing Power BI semantic model spanning sales, stock, returns and customer data. As Analytics Engineer, you will turn that infrastructure into the analytical products the business actually uses to make decisions.

This is a genuinely AI‑first role. You will work daily with Claude Code and the latest Microsoft MCP (Model Context Protocol) tooling to build our data lakes, semantic models, and dashboards at a pace that a traditional tools simply cannot match — this is one of the most cutting‑edge roles in UK retail analytics today, and you will help shape what AI‑native analytics engineering looks like at Crew.

Your primary focus will be driving forward our integration and dashboard roadmap of data products, semantic models, and natural language AI interfaces that let trading, buying, retail and finance teams make decisions on live data rather than instinct.

Key Responsibilities

• Own delivery against the Crew D&A Strategic Roadmap — the team’s single source of truth for integration and dashboard priorities
• Build, maintain and document Fabric Lakehouse — owning the Python and SQL transformation logic that turns our raw data into business-ready datasets
• Extend and maintain the Power BI semantic model — building DAX measures, calculation groups and relationships as new data sources and brands (Ben Sherman, Pringle, Saltrock) come online
• Use Claude Code and the latest Microsoft MCP tooling as a core part of your daily workflow — this is an AI‑first role and you will be expected to use cutting‑edge AI tooling to build and document faster than a traditional tools allow
• Apply basic DevOps practice to analytics engineering — Git‑based version control, structured deployment pipelines (Dev → Prod), and clear environment governance
• Own and monitor Fabric Data Pipelines ingesting data from multiple sources — incremental load logic, agent driven failure alerting and data quality checks
• Design and build the complex dashboards senior leaders and trading teams use directly to make decisions — trading performance, stock health, buying analysis, customer behaviour, store performance
• Use Python (Pandas, PySpark) for data manipulation and automation wherever SQL and DAX are not the right tool
• Lead the technical onboarding of Ben Sherman, Pringle and Saltrock data onto the shared Fabric platform, enabling group-level reporting
• Maintain a data dictionary and clear documentation of view logic, naming conventions and the deployment process

Skills & Experience Desired

• 3+ years’ experience in analytics engineering, BI development or data engineering
• Strong SQL — able to write and optimise complex views, CTEs and window functions
• Hands‑on Power BI experience, particularly DAX measure development and semantic model design
• Comfortable with Python for data manipulation and automation (Pandas, PySpark)
• Familiarity with basic DevOps practices — Git‑based workflows, deployment pipelines and version control
• Experience with Microsoft Fabric, Databricks or a similar cloud data engineering platform
• Genuine enthusiasm for AI‑assisted development — comfortable using tools like Claude Code and MCP‑based tooling to work faster and think differently about how analytics engineering gets done
• Commercial awareness — able to translate a retail business problem into data requirements without heavy specification
• Experience in retail, fashion or ecommerce data environments is a strong advantage

Skills

Engineering

Analytics