Joel Rothrock

Data, AI &
partnerships.

Turning a Snowflake platform into attribution products, AI orchestration, and revenue at Community Impact. Previously $46M+ of operational impact at Applied Materials.

Platform Snowflake medallion warehouse AI layer Apollo · MCP orchestrator Revenue Attribution + partnerships

One unified system — designed and built that way from day one.

What I do.

I'm a data and AI leader focused on collapsing the silos between infrastructure, applied AI, and revenue. I build end-to-end data ecosystems — from foundational warehousing through AI orchestration to the revenue products that use both.

At Community Impact, I lead the data and AI function for a hyper-local media company serving 50+ communities. In under a year, I've moved the organization from a zero-base to a production-grade data ecosystem: a Snowflake medallion warehouse built from scratch, an MCP-based AI orchestrator (Apollo) that lets Claude reason across the entire data layer, the company's first attributed-revenue product, and technical lead on inaugural data-partnership deals. I also serve as CI's designated Texas data point of contact under the TDPSA.

Previously, four years at Applied Materials as a BI Analyst and Data Scientist, where I delivered $46M+ in operational and financial impact through ML models, Python automations, and Tableau dashboards across supply chain, finance, and engineering.

The throughline of my work: the platform, the AI layer, and the revenue motion are one unified system — designed and built that way from day one.

Project 01

Apollo

AI orchestrator for a data ecosystem

An MCP server letting Claude reason across a Snowflake warehouse, an ad-management system, and a CMS. Built on Anthropic's Model Context Protocol — designed so the data layer, the tool surface, and the model are all first-class. Extended with retrieval-augmented context over a document corpus.

MCPClaudeAnthropicPythonSnowflake
Project 02

CI Data Platform

Snowflake medallion warehouse, zero to production

Designed and built Community Impact's first data warehouse: a Bronze/Silver/Gold medallion architecture ingesting CIIMS, Broadstreet, Beehiiv, and CMS data into one unified, governed source of truth. The substrate every other CI data product runs on.

SnowflakedbtPythonMedallionData Engineering
Project 03

CI Attribution

First attributed-revenue product

A Streamlit application matching subscriber identity to ad exposures and transactions. Live in production at Community Impact and the technical foundation for the company's first paid data partnerships.

StreamlitSnowflakeIdentity ResolutionAttribution
Project 04

Customer Data Platform

Identity resolution at scale

CI's CDP layer with custom Snowflake UDFs (NAME_HASH, PHONE_HASH) consolidating subscriber identity across CRM, newsletter, and CMS systems — the substrate that makes attribution possible.

Snowflake UDFsSQLIdentityCDP
Project 05

Applied Materials

$46M+ in operational impact over four years

Four years as BI Analyst and Data Scientist at Applied Materials. ML forecasting models, 20+ Tableau dashboards, and 10+ Python automations across supply chain, finance, and engineering. Cut manual review time by 80%+; recovered hundreds of operating hours per year.

PythonSQLTableauMachine LearningSAP

Where I've been.

Community Impact

Austin, TX

Senior Data Engineer

2025 — present

Applied Materials

Austin, TX

BI Analyst · Data Scientist · Inventory Analyst

2021 — 2025

FirstService Residential

Austin, TX

General Manager · Assistant GM

2018 — 2021

Education

M.S. Analytics, Texas A&M · B.S., Texas State