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%
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.
