← All work
Global FMCG · Multi-market

Royal Canin (MARS)

MARS subsidiary Royal Canin required a complete analytics schema and data pipeline for a global website with 50M+ monthly visitors, delivered at speed across 12+ subsidiary companies.


Approach

  • Designed the global analytics schema for a 50M+ monthly visitor website from scratch

  • Built the automation workflow for ingesting and transforming raw analytics data for internal data teams

  • Collaborated on robust data pipelines from BigQuery into Azure and then Databricks

  • Led analytics training and documentation rollout across 12+ subsidiary companies


Outcomes

  • Analytics migration completed in record time across global markets

  • Seamless data flow from BigQuery to Azure to Databricks for enterprise data teams

  • Standardised analytics practice adopted across 12+ subsidiaries


Stack & Tools

GCP Azure Databricks BigQuery Python Google Analytics SQL

Working on something similar?

I take on a limited number of engagements at a time. Let's see if it's a fit.

Book a Call →