GA4 data modeling across e-commerce and financial services clients using dbt and Dataform. Medallion architecture with specialized marts for user behavior and product interactions. FinOps optimization for cost and performance.
Refactoring GA4 workloads in BigQuery: query optimization, partitioning, clustering, and governance implementation.
Technical lead for migration from Dataroma to Modern Data Stack. Multi-source integration (Catchr, Couchdrop) and DSP data extraction. dbt standards implementation, platform documentation, and client team training.
Refactoring and optimization of multi-store dashboard platform. Dashboard architecture redesign, Row-Level Security (RLS) implementation, consolidated global dashboard, and automated Slack alerting.
Medallion architecture with Kestra orchestration and Airbyte ingestion. Modular dbt models with marts layer. Automated retry mechanisms, error handling, and data quality framework. Integrated with Funnel for marketing analytics.
Slack monitoring system for dbt pipelines and business KPIs. Automated alerts for failures and errors. Scheduled KPI reporting with thresholds. Interactive Slack commands for data access. Delivered across 3 industries.
RAG chatbot helping cat owners evaluate pet food for renal and urinary conditions. Semantic search over a veterinary knowledge base with URL analysis, OCR label reading, and an AI expert chat.
Automated content aggregation and analysis from email and RSS sources to build a continuous intelligence pipeline.