Customer Success Stories | Pythian®

Data-enabled retail: Stand Out For Good leverages BigQuery to improve marketing and customer experience

Written by Pythian Marketing | Aug 25, 2023 1:38:27 PM

What we did

By talking to different stakeholders and gaining an understanding of SOFG’s marketing and data warehouse pain points, we were able to find a way to unlock the most value from the company’s data. Our teams built SOFG an Enterprise Data Platform (EDP) on Google Cloud:

  • Removing SnapLogic and other redundant cloud vendors from their existing tech stack
  • Ingesting data into Google Cloud Storage
  • Moving from SQL DataVault to BigQuery to support exporting and analyzing key marketing metrics
  • Adopting an Extract, Load, Transform (ELT) model to accelerate development and create a new data model that supports business metrics
  • An accelerated 6-month timeline to help them get to value faster

Pythian designed and built a modern data platform that addressed SOFG’s key needs and pain points. This allowed the retailer to further optimize and personalize their marketing efforts by providing a richer and more accurate view of SOFG’s customers.

 
 

Technologies used

  • Cloud VPN
  • Google BigQuery
  • Cloud Composer
  • Google Compute Engine
  • Google Cloud Operations Suite
  • Google Cloud SQL
  • Google Cloud Storage
  • Cloud Data Fusion
  • Google IAM
  • Google Workspace
  • Secret Manager
  • Virtual Private Cloud

"Pythian is an extension of our team. I trust them because they understand what we are and what we need. This is very valuable as we move away from managing technology and enabling business outcomes.”

Joergen Scheuer-Larsen, CIO