2026 - Present
Marketing data platform
One reporting system for paid media and first-party data
- BigQuery
- Dataform
- Cloud Run
- MCP
I built the agency's reporting system, bringing paid-media and first-party data into one reporting model.
Role: Sole engineer and AI workflow engineer
Account teams use the system to review performance and decide where to move budget.
What I owned
- Built and operated the ingestion jobs, transformations, quality checks, and reports as one production system.
- Added freshness checks that stop stale data before account teams see it in a report.
- Added a restricted chat interface for the campaign questions account teams ask every week.