(404) 585-8001 [email protected]

Case Study: Circle K

Rocket Partners Architects a Cost-Effective, Integrated Data Warehouse Solution, Leveraging Modern Cloud-Based Technologies

THE CHALLENGE

Circle K is one of the world’s largest convenience store operator with over 10,000 locations in
20 countries.  As one of its many market leading initiatives, Circle K has adopted in-store digital
technologies that engage consumers and drive sales.

In 2016, with 5000 stores already deployed, Circle K purchased the technology assets of the LIFT
Retail (LIFT) interactive digital signage network.  LIFT is an interactive display that sits on a retail
counter top, integrates with the point of sale to monitor purchase data in real time, and
engages shoppers with customized offers, discounts, and loyalty programs.

As part of the acquisition, Circle K had to migrate the technology infrastructure off of a legacy
third party cloud/on-prem hybrid to a Circle K owned Amazon AWS cloud environment.  One of
the first challenges was figuring out how to replace/migrate an IBM Netezza data warehouse
appliance. The Netezza EDW was collecting data on 50MM LIFT advertising impression and 5MM
retail transactions each day.

Circle K is the largest global convenience store operator with more than 10,000 locations in 20 countries.

ROCKET PARTNERS SOLUTION

After a detailed evaluation, Rocket Partners recommended Amazon’s Redshift cloud enterprise data warehouse (EDW) as a replacement solution.  Since the majority of business reports were compatible from one platform to the other, the primary challenge was moving all of the data to the cloud while continuing to catch multiple terabytes of inbound data each day.

Rocket Partners solution was to decouple inbound streaming telemetry from the 10,000 deployed LIFT devices from the ETL process. Telemetry that had previously been “trickle fed” into the Netezza would be collected and cleaned and stored in large aggregate files in S3. Each aggregated day would then be efficiently loaded from S3 into Redshift in an overnight batch process. With this pipeline in place new data could be loaded at the same time old “days” were exported from the Netezza to Redshift S3 files.

“After the LIFT acquisition, the path forward for our digital architecture was not clear. The Rocket Partners team came in as true subject matter experts in custom enterprise cloud solutions and led our team through the decision-making process of how to leverage modern Amazon Web Services (AWS) solutions in the most cost-effective manner.”

Todd Isaacs

Sr. Director of Loyalty, Digital & Payments, North America, Circle K

OUTCOME

The architecture proposal met all of the key criteria of Circle K, including lowering the overall cost of operating the solution once integration was complete.

By leveraging the Amazon solution, Circle K was able to change the telemetry from being “trickle fed” into the Netezza solution to a modern, scalable cloud-based solution.

With the successful implementation of the Rocket Partners solution, Circle K was able to take full advantage of the LIFT acquisition.

THE RESULTS

 

  • Provided a comprehensive multi-phase cloud-architecture solution
  • Introduced a lower-cost operating model, leveraging Amazon Web Service solutions including Redshift and S3.
  • The Tech Services operating costs were lowered by 50 percent

TOOLS USED

  • AWS S3
  • AWS Aurora
  • AWS Redshift
  • AWS ELB (Elastic Load Balancer)
  • AWS Lambda
  • AWS Route 53
  • AWS Dynamo
  • AWS Cloudwatch

What can we do?

Let us help you achieve success!