E-commerce data migration for a global beauty company

The work

A global beauty company was moving 11 brand-region storefronts to Shopify. The data migration had to support new commerce data without breaking the historical trends that teams used to run the business.

I led the data migration work across brands and regions, coordinated cutovers with the delivery team, and built data marts and Looker dashboards as new requirements came into scope. The models had to account for multiple brands, regions, and currencies.

The result

Phase one landed on schedule, and reporting stayed continuous through the cutovers. The work expanded to additional brands and data types after the initial migration.

Tools: Python, SQL, Google Cloud, BigQuery, Looker, Shopify data