Analytics Engineer

About MARCHON

MARCHON is the UK’s premium performance-lifestyle ecosystem, one brand that helps driven people train, fuel and dress for a life without limits. World-class coaching sits at the centre, backed by certified performance supplements and movement-ready apparel, all amplified by our beacon gyms.Founded by ex-England rugby player and CEO Ollie Marchon, the company has grown from a single HQ club to a true omni-channel offering: the Train app, a fast-scaling supplement line, and physical hubs that bring the experience to life.We’re still small enough that every new teammate leaves fingerprints on the product, yet the momentum is real. Our 2026 plans are ambitious to say the least, as we make a step-change in evolving our ecosystem between training, supplements and apparel.If you care about high standards, straight talk and making a visible impact, you’ll feel at home here. Join us while there’s still room to shape the journey.

Reports to: Adit Ruparel, Chief Operating Officer

Location: Hybrid – Harpenden HQ (2 days p/w) + remote; occasional site visits to gyms, warehouse and pop-up events

Mission

Maintain the Single View of customer data warehouse layer; model events, orders, and engagement into trusted, version-controlled tables. Serve the business with automated dashboards and deep-dive analyses that surface cohorts, LTV drivers and payback windows—so experiments and capital allocation improve every sprint.

Key Responsibilities

1. Own the SVOC stack – architect, document and govern dbt models in BigQuery (or similar) that join Mixpanel, Shopify, internal DBs and gym systems into a single customer truth.
2. Model for impact – create revenue & margin-aware tables (orders, subscriptions, events) that feed LTV, CAC and payback reporting.
3. Automate insight delivery – build Looker (or similar) dashboards and self-service explores that marketing, product and finance can trust and use daily.
4. Commercial story-telling – translate data into plain-English narratives that guide channel spend, SKU strategy and retention tactics; highlight quick wins & ROI risks.
5. Drive data quality – implement match-rate tests, anomaly alerts and version control so pipelines stay >99 % reliable.
6. Coach & enable – upskill key commercial leaders to make the most of our visualisation tools, cohort thinking and experiment read-outs; embed a “test-and-learn” mindset across the group.

12‑Month Success KPIs

• Unified ID match-rate across ≥2 verticals ≥ 90%
• Time to refresh LTV/CAC dashboard
• Active business users of SVOC dashboards ≥ 12
• Number of experiment read-outs delivered ≥ 10
• Pipeline uptime (scheduled models) ≥ 99%

Experience & Skills

• 3–5 years in analytical engineering, analytics or data science within D2C, subscription or retail/e-commerce.
• Expert SQL and dbt; comfortable refactoring legacy queries into clean, test-covered models.
• Hands-on with cloud warehouses (BigQuery, Snowflake or Redshift) and BI tools (Looker, Metabase, Hex).
• Proven record turning raw event & order data into LTV, cohort and payback insights that influenced budget decisions.
• Commercially savvy—able to speak EBITDA, margin, CAC and inventory turns with finance & GM teams.
• Strong communicator: can distil complexity into crisp decks and one-page memos.
• Bonus: experience with Mixpanel/Segment schemas, Shopify Plus data or fitness/wellness brands.

Team Structure

• Direct reports (initial): None initially (future data analyst hires possible)
• Wider team set up: Lifecycle/CRM Manager, Head of Growth, CPO, Finance lead, Supplements/Apparel MDs

Benefits

• 22 + 8 Bank Holidays + your birthday
• Pension contributions
• Starter Pack all things MARCHON
• £400 Gift card per year to spend on MARCHON Supplements & Apparel
• Year-round discount on Supplements & Apparel
• Free gym membership to all MARCHON gyms
• Full access to MARCHON Online training & Nutrition
• PC or Mac laptop