Cameron Spilker
Analytics engineer · building with AI

Hi, I'm Cameron.
I like building things.

At Typeform I build the data that people and AI agents rely on. In my spare time I make side projects, one of them with my brother. Here's what I've been working on.

See my projects Say hi

Projects

Things I've made

They're all live, so feel free to poke around.

Made with my brother Ethan

Cardtacular

Digital greeting cards you make in the browser and send with a link.

Make a card

A weekly newsletter

Plainstocks

A few AI agents run a simulated portfolio and try to beat the S&P 500, then write up what they changed each week.

Get the newsletter
Side project · College basketball, from raw data to dashboard

Full Data Stack Lab

A college basketball model I run in the open. It tracks every Division I men's team, simulates the tournament 20,000 times, and keeps score on how its own picks did.

Open the lab

20+

dbt models

150+

tests

20,000

simulated brackets

365

teams tracked

Next update in

--:--:--

Nightly at 06:00 Mountain

Tools

Little tools

Small things I made because I needed them. Most run entirely in your browser and upload nothing. The gift list is the exception, because sharing a list means saving it somewhere.

All tools

Experience

Where I've worked

Analytics engineering at Typeform, Apollo.io and Gopuff, with data engineering and analytics before that. The common thread is building sources of truth: data that a dashboard, a person asking a question, and an AI agent can all rely on.

  1. Typeform

    Senior Analytics Engineer

    Oct 2024 to Present

    • Launched conversational analytics on governed metrics
    • 650+ dbt models moved to Snowflake, zero downtime
    • Feature reporting from 7 features to 145
    Show details
    • Launched conversational analytics on the Omni semantic layer, giving stakeholders natural language access to governed metrics. Built reusable components into the dbt repo and run evals on the context behind them to keep answers accurate.
    • Co-led a zero-downtime migration of 650+ dbt models and 600+ Looker assets, seven years of reporting and operational data, from Redshift to Snowflake.
    • Led the Looker to Omni migration of 400+ dashboards and 75+ Explores, prioritized by real usage and delivered with an external team. Now the Omni admin for access, permissions, and user content.
    • Built feature-level reporting end to end: consolidated eventing data, defined the key properties, and shipped the dbt models, semantic layer, and dashboards. Scaled from an MVP of 7 features to 145 in production.
    • Introduced macros, DRY doc blocks, PR templates, and CI/CD with automated summaries and data diffs, cutting review cycles ~25% across a four person analytics engineering team.
    dbtSnowflakeOmniSemantic layerAICI/CD

  2. Apollo.io

    Senior Analytics Engineer

    Sep 2023 to Oct 2024

    • CI/CD runtime from 60 minutes to 6
    • Reverse ETL syncs from 30+ hours to under 1
    • dbt docs coverage from 46% to 85%
    Show details
    • Cut CI/CD runtime from 60 minutes to 6 through code diffing and smart caching, accelerating PR feedback for 10+ analytics engineers.
    • Re-engineered 50+ dbt models and 150+ Looker assets after major Salesforce architecture changes, restoring accuracy across 20+ dashboards used by Sales, Finance, Customer Success, and Marketing.
    • Streamlined reverse ETL syncs, reducing processed records from 6 million to 1.8 million and sync duration from 30+ hours to under 1, lowering compute cost and improving freshness.
    • Led a company wide doc-a-thon that raised dbt documentation coverage from 46% to 85%, improving discoverability and onboarding.
    dbtSnowflakeLookerCensusSalesforce

  3. Gopuff

    Analytics Engineer

    Mar 2022 to Sep 2023

    • $300K+ a year saved on Snowflake
    • Shared models behind 10+ core metrics
    • ~25% fewer ad hoc report requests
    Show details
    • Achieved $300K+ in annualized savings by optimizing Snowflake queries and pipelines across core analytics workloads.
    • Designed centralized subject area models for the Growth and Product Analytics teams covering search, ads, impressions, marketing performance, and competitive pricing, increasing consistency across 10+ core metrics.
    • Built and maintained Looker and Sigma dashboards enabling self serve analytics for hundreds of internal users, reducing ad hoc report requests ~25%.
    dbtSnowflakeLookerSigma

Before that

  • 2025Brigham Young University · Adjunct Professor, IS 515 Advanced Spreadsheets
  • 2021 to 2022Lendio · Data Engineer
  • 2019 to 2021American Express · Data Analytics & Innovation Analyst
  • 2019Xerva, an Eide Bailly company · Business Intelligence Developer
  • 2017 to 2019Brigham Young University · Associate Audit Analyst
  • 2018KPMG · Advisory Intern
Full history on LinkedIn

About

A bit about me

I'm an analytics engineer in Utah. The way I see the job, it's building sources of truth: well modeled data with clear definitions, so a dashboard, a person with a question, and an AI agent all get the same answer.

AI is a big part of how I work. I use it to build faster, and more of what I build is for it now, like the semantic layer and the evals behind conversational analytics at Typeform.

Outside of work I make side projects, one of them with my brother Ethan, and I run a college basketball model in public. I studied information systems at BYU and later went back to teach a spreadsheets class there.

A few other things

Based in
Utah
Started out in
Audit analytics, at BYU
Studied
Information Systems, BYU (BS + MS)
Taught
IS 515, Advanced Spreadsheets, at BYU
Side projects
Four live, one with my brother
Usually using
dbt · Snowflake · Omni · Claude Code · Python

Contact

Say hi

Happy to chat about data, AI, side projects, or anything on this page.