The Customer
Ascend is a network of public K–12 charter schools serving nearly 6,000 students across Brooklyn, New York, with a mission to provide high-quality, college-preparatory education in underserved communities.
The Project
Data Estate Maturity On Snowflake
Overview
Improving partnered with Ascend, a charter school system, to modernize and mature their data estate using Snowflake. The project aimed to automate data processes, mitigate risks associated with vendor dependencies, and enable efficient data management. By implementing advanced data integration and governance strategies, we sought to streamline data operations, reduce manual workloads, and enhance data accessibility for Ascend's educational ecosystem.
The Business Challenge
Ascend faced significant challenges in managing their educational data due to manual processes and reliance on vendor systems. Their data strategy was immature, lacking automation, scalability, and ownership, leading to inefficiencies and potential risks. The absence of a consolidated data model hindered their ability to perform effective data analysis and reporting, impacting operational efficiency and decision-making capabilities.
Our Solution
Our approach involved building a parallel infrastructure to modernize Ascend's data environment. We prioritized high-risk data integration points and developed a comprehensive data strategy to bring all resources and ownership in-house. Using Snowflake, Google Cloud, DBT, and Dagster, we created an end-to-end data management solution that streamlined data ingestion, integration, and analytics. This allowed Ascend to transition from manual data processes to automated, scalable, and efficient operations.
Technologies & Methodologies Used
Snowflake: For building a consolidated semantic data model and enabling efficient data storage and analytics.
Google Cloud Platform (GCP): Utilized for data storage and integration.
DBT (Data Build Tool): Implemented for SQL-based data modeling and transformations.
Dagster: Used as an orchestrator for managing data workflows and integrations.
Python: Employed for connecting various data sources and performing data transformations.
Data Governance: Established best practices and policies for data management and quality control.