Regional Data Warehouse for Collective Impact

Overview

Using Google BigQuery, my team designed a regional data warehouse that unified voter outreach data from over 80 partner organizations and voter turnout data from 6 counties. The system standardized submissions from VAN, EveryAction, Impactive, and alternate submission types to create a single, source of truth for engagement and turnout analysis. This project transformed fragmented data into an integrated infrastructure supporting over 2 million incoming records and real-time insight across the network.

Challenge

Before this project, organizations across the region were submitting voter contact data in different formats and through multiple tools. The lack of consistency made it difficult to track progress, measure turnout, and demonstrate collective impact to funders. Partners worked in silos without a shared understanding of who was being reached or how their efforts connected.

Approach

I led the design and implementations of a regional data warehouse built on Google BigQuery. Our team collaborated with The Movement Cooperative (TMC) to align warehouse architecture and ensure compatibility. We developed partner submission templates, validation checks, and equity-centered governance framework to ensure accuracy and security across all participating organizations. Working closely with partners, we connected field data to geographic and voter file information, creating a unified system that linked outreach data across counties and tactics.

Outcome

The warehouse now integrates over 2 million voter records, from 80+ organizations, across multiple years, providing a shared foundation for learning and accountability.

Tech Stack