Analytics Engineer

Analytics Engineer

Analytics Engineer

Marchon

Harpenden, England, United Kingdom

1 day ago

No application

About

  • 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
  • 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.
  • 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
  • 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.
  • Model for impact – create revenue & margin-aware tables (orders, subscriptions, events) that feed LTV, CAC and payback reporting.
  • Automate insight delivery – build Looker (or similar) dashboards and self-service explores that marketing, product and finance can trust and use daily.
  • Commercial story-telling – translate data into plain-English narratives that guide channel spend, SKU strategy and retention tactics; highlight quick wins & ROI risks.
  • Drive data quality – implement match-rate tests, anomaly alerts and version control so pipelines stay >99 % reliable.
  • 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 < 60 min
  • Active business users of SVOC dashboards ≥ 12
  • Number of experiment read-outs delivered ≥ 10
  • Pipeline uptime (scheduled models) ≥ 99%
  • 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.
  • 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