Case Study: Bloomington Public Schools achieves 90% faster data loads and zero breakdowns with Matillion ETL for Snowflake

Bloomington Public Schools and DataDrive modernize data strategy in a rapidly changing environment

Bloomington Public Schools, a suburban Minneapolis district serving over 11,000 students, faced a legacy data architecture that caused 6–8 hour overnight loads, weekly failures, and a reporting bottleneck due to heavy reliance on Filemaker Pro and a single database administrator. To modernize its analytics while maintaining existing Tableau reports, BPS adopted Matillion (Matillion ETL for Snowflake) to provide cloud-native integration and transformation capabilities.

Working with consultant DataDrive, Matillion ingested and transformed data into the Snowflake Data Cloud using a low-code, drag-and-drop interface that integrated with BPS’s AWS instance. Matillion connected eight disparate applications (including the student information system), cut overnight load times from 6–8 hours to 30 minutes, and reduced weekly breakdowns to zero, enabling accurate Tableau reporting, broader staff access to analytics, fewer errors, and significant time savings.

Bloomington Public Schools

Emmy Moody

Data and Web Integration Specialist