Episode 195:

Supply Chain Data Stacks and Snowflake Optimization Pro Tips with Jeff Skoldberg of Green Mountain Data Solutions

June 26, 2024

This week on The Data Stack Show, Eric and John chat with Jeff Skoldberg, Principal Consultant, Data Architecture and Analytics at Green Mountain Data Solutions. Jeff has been a data consultant specializing in supply chain analytics and cost optimization and shares his journey from starting as a business analyst at Keurig in 2008 to becoming an independent consultant. They discuss the evolution of the data landscape, including shifts from Microsoft SQL Server to SAP HANA and later to Snowflake. Jeff emphasizes the importance of cost optimization, detailing strategies for managing data costs effectively. The group also discusses two frameworks for using data to control business processes and create actionable dashboards, and more.

Notes:

Highlights from this week’s conversation include:

  • Jeff’s Background and Transition to Independent Consulting (0:03)
  • Working at Keurig and Business Model Changes (2:16)
  • Tech Stack Evolution and SAP HANA Implementation (7:33)
  • Adoption of Tableau and Data Pipelines (11:21)
  • Supply Chain Analytics and Timeless Data Modeling (15:49)
  • Impact of Cloud Computing on Cost Optimization (18:35)
  • Challenges of Managing Variable Costs (20:59)
  • Democratization of Data and Cost Impact (23:52)
  • Quality of Fivetran Connectors (27:29)
  • Data Ingestion and Cost Awareness (29:44)
  • Virtual Warehouse Cost Management (31:22)
  • Auto-Scaling and Performance Optimization (33:09)
  • Cost-Saving Frameworks for Business Problems (38:19)
  • Dashboard Frameworks (40:53)
  • Increasing Dashboards (43:29)
  • Final thoughts and takeaways (46:28)

 

The Data Stack Show is a weekly podcast powered by RudderStack, the CDP for developers. Each week we’ll talk to data engineers, analysts, and data scientists about their experience around building and maintaining data infrastructure, delivering data and data products, and driving better outcomes across their businesses with data.

RudderStack helps businesses make the most out of their customer data while ensuring data privacy and security. To learn more about RudderStack visit rudderstack.com.