AI-Native Principal Data & Marketing Analytics Architect.
We architect high-trust BigQuery, Snowflake & dbt data platforms, CM1→CM3 contribution margin attribution, Statsig / AB Tasty / Optimizely experimentation, and Self-Updating Enterprise AI Agent Skills that turn raw telemetry into board-verified profit.
Thin-Client + Cloud-Brain
Zero-PII MCP Execution
Self-Updating Skills
Auto-Diffs dbt & Schemas
CORE ARCHITECTURE PRACTICE // THREE PILLARS
Full-Stack Data Engineering, Marketing Science & Agentic Automation
Every engagement bridges warehouse engineering with board-level commercial outcomes-eliminating data fanout, attribution blind spots, and manual analyst toil. Click any pillar for its full architecture playbook, SQL blueprints, and benchmarks.
Enterprise Data Platforms & Analytics Engineering
Production-grade lakehouse and warehouse architectures engineered for sub-second executive BI, zero-fanout semantic modeling, and 99.9% event reliability.
- ✓BigQuery & Snowflake dbt marts with dynamic watermark incremental insert_overwrite strategies
- ✓Server-Side Google Tag Manager (sGTM), Elevar, Segment & Ampli unified event schemas
- ✓Automated Python/Cloud Run KPI variance monitors with owner-routed Slack anomaly alerts
- ✓Executive Power BI (TMDL / DAX V2 / Deneb Vega-Lite), Looker & Tableau semantic layers
Marketing Attribution, CM3 Profitability & Experimentation
Move beyond inflated ad-platform ROAS. Unify backend order economics, COGS, shipping, refunds, and offline conversions into true CM1-CM3 contribution margin and rigorous A/B testing.
- ✓SKU- & order-level CM1 → CM2 → CM3 profit waterfalls joining Shopify/ERP, Refunds & Paid Ads
- ✓Multi-Touch Attribution (MTA), Incrementality-Adjusted MER, nCAC & Cohort LTV:CAC decay curves
- ✓Full-funnel experimentation governance across Statsig, AB Tasty, Optimizely & Amplitude
- ✓XGBoost & ML lead-scoring pipelines (AWS SageMaker / Vertex AI) & Klaviyo RFM retention flows
Production AI Agent & Enterprise Skill Systems
Turn scattered tribal knowledge, warehouse schemas, and repetitive weekly analytics workflows into deterministic, privacy-safe AI Agent Skills and remote MCP servers.
- ✓Custom Enterprise Workflow Skills encoding in-house KPI dictionaries, SQL dialects & SOPs
- ✓Self-Updating Companion Meta-Skill (enterprise-skill-updater) that auto-diffs dbt manifest.json & INFORMATION_SCHEMA
- ✓Multi-model Gemini 3.x routing (Flash-Lite → Flash → Pro) with hierarchical Firestore/BigQuery caching
- ✓Zero-PII, Zero-Row-Data telemetry loops and Computer Vision creative performance scoring
CONFIDENTIALITY-FIRST PROOF OF WORK // VERIFIED ARCHITECTURES
Production & Applied AI Systems Across Nutrition Intelligence, FinTech, Telecom & Civic AI
Owned AI platforms include public synthetic demonstrations, while client engagements enforce zero-disclosure brand anonymity as they detail warehouse contracts, dbt watermarks, experimentation gates, and multi-stage Gemini topologies.
AI Nutrition & Ingredient Intelligence: Built From Care, Guided by Evidence
Challenge: Built to help my wife better understand how meals, ingredient quality, preparation, sleep, physical activity, and daily routines relate to how she feels. Everyday observations rarely arrive as clean rows, making weeks of overlapping habits hard to summarize for healthcare conversations.
- ▹Built multimodal conversational capture across Telegram (text, voice memos, plate photos, barcodes) and React 19 with a 3-stage Gemini Gatekeeper that asks one concise follow-up when missing prep or timing context matters (0 partial rows written in tests).
- ▹Paired FatSecret OAuth 2.0 lookups and deterministic FDA/Monash additive rules (polyols, gums, emulsifiers) with shared Zod contracts and tenant-partitioned dbt Bronze -> Silver -> Gold 1 PRECEDING lag windows (410/410 synthetic SQLite parity).
- ▹Combined exploratory BigQuery ML (XGBoost and ARIMA_PLUS) chronological holdouts, modeled baseline intervals, abs(r) >= 0.35 collinearity warnings, and Semantic Scholar MeSH literature references to surface honest questions for clinician review.
Cross-Platform Experimentation Telemetry, Read-Only Audit Automation & Statistical Decision Pipelines
Challenge: High-velocity acquisition funnels running concurrent client-side and feature-flag experiments across AB Tasty and Statsig suffered from fragmented targeting rules, manual QA bottlenecks, and disconnected downstream enrollment attribution.
- ▹Built deterministic read-only API inspection and governance skills for AB Tasty and Statsig to automatically extract active test variations, JS/CSS code modifications, URL targeting scopes, and audience triggers.
- ▹Standardized Cloud metric definitions, experiment hypothesis documentation, and automated executive decision synthesis connecting front-end variant exposure to qualified backend financial consultations.
- ▹Integrated multi-channel communication triage and technical project management playbooks that convert meeting transcripts directly into sprint-ready engineering specifications.
Automated Product & CRO Tracking Architecture (-50% Manual Tagging) + Offline Call-Center LTV/CAC Unification
Challenge: Rapid subscriber growth required unifying high-volume GA360/GA4 web and mobile app telemetry with offline call-center conversions (Invoca) while eliminating the 6-month engineering bottleneck caused by manual element tagging for product analytics and A/B tests.
- ▹Led a cross-functional initiative with Engineering and Product to embed an automated site tracking wrapper (Ampli / server-side GTM) that enabled product analytics and Optimizely/Amplitude experimentation without manual element tagging-cutting manual effort by 50%.
- ▹Owned the GA360/GA4-to-BigQuery and Snowflake dbt modeling strategy, flattening nested event structures and joining offline call-center conversions to map the full subscriber lifecycle from lead to renewal.
- ▹Built executive Looker dashboards and cohort LTV/CAC models across segmented B2C subscriber plans to guide C-suite (CPO/CRO) budget allocation.
Serverless Multi-Model Gemini 3.x Legislative Impact Engine with Two-Tier BigQuery → Firestore Caching & Self-Learning Ontology
Challenge: Full congressional bills run hundreds of pages of dense legal text. Citizens need an unbiased, personalized breakdown of how a bill impacts their household and community (ZIP/City/State), plus an NPS-style alignment score comparing their section-by-section votes against their Representative and Senators-without incurring runaway LLM compute costs.
- ▹Engineered a Two-Tier Lakehouse-to-Storefront architecture: BigQuery (bill-analyzer-3ccad.discover_vote) stores legislative roll-call votes, legislator profiles, BLS/EIA economic indicators, and US Census ACS 5-Year demographics, syncing incrementally via watermark timestamps to Firestore.
- ▹Built OntologyLearner using Stage 1 fuzzy token matching (SequenceMatcher >= 0.70) + Stage 2 Gemini semantic verification to deduplicate demographic prompts across bills, paired with a cumulative localStorage voter profile (DemographicForm.tsx) that asks each question only once and auto-populates across future bills.
- ▹Implemented 3-Tier Hierarchical Community Impact Caching ({bill}_{zip} → {bill}_{city_state} → {bill}_state_{state}) with asynchronous granular ZIP upgrade and bulk 50-state pre-fetching.
Audit Telemetry, Unblock Your Warehouse, or Deploy Enterprise AI Skills
Whether you need to reconcile a 50% tracking mismatch between ad platforms and your warehouse, model true CM1–CM3 margins in dbt, or build custom self-updating AI agent skills-work directly with Rudy Martinez to design and deploy battle-tested data infrastructure.
Marketing Telemetry & Full-Funnel Attribution Audit
Reconcile platform-reported ROAS against net-of-refunds CM3 profitability. Audit server-side GTM, CAPI deduplication, and eliminate double-counting across Meta, Google, and your CRM.
Warehouse Architecture, Incremental Marts & Semantic Modeling
Transform raw event streams into governed, incremental data models. Build production-grade dbt DAGs, semantic layers, and executive Power BI / Looker reporting.
Custom Autonomous AI Agent Skills & Model Context Protocol
Ingest your internal documentation and map your private warehouse schemas into tailored Agent Skills that perform automated diagnostics, anomaly detection, and executive reporting.
100% Principal
No junior handoffs
Strict Mutual NDA
Zero data disclosure
Rapid Scoping
1 business day response
Contact Database Marketer
Inquire about telemetry audits, modern data stack migrations, enterprise AI agent skills, or fractional principal architecture retainers.
COMMERCIAL ARCHITECTURE // FOUR REVENUE & ENGAGEMENT PILLARS
Transparent Productized Licensing, Diagnostic Sprints & Custom Enterprise Skills
Start with an initial architecture consultation or a fixed-fee 5-Day Diagnostic Sprint-and scale into self-updating enterprise Agent Skills or fractional principal ownership.
Modular Marketing Analytics Skill Suite (M1–M4 + Free Profiler)
1 Free Stack Profiler + 4 Paid Specialist Modules ($79–$129/mo or $199/mo Full Suite)
Best For: Growth Marketers, Analytics Engineers, Ecommerce Directors & CMOs
Start with the free marketing-stack-profiler (4-layer PII scrubber + context-isolated Tool Modules), then activate individual modules or the full Cloud-Brain MCP suite with transparent monthly call quotas.
- ✓Free Core Hub (marketing-stack-profiler): Skippable onboarding, 4-layer PII scrubber & strict Tool Module isolation
- ✓M1 Telemetry & Attribution Debugger ($79/mo • 1,500 MCP calls/mo, 15/min burst): 5-Stage Meta-to-GA4 50% traffic waterfall (UI + SQL)
- ✓M2 Marketing Warehouse & dbt Architect ($99/mo • 2,000 MCP calls/mo, 15/min burst): 7 Canonical Entities & L1–L3 schema adapter
- ✓M3 Ecommerce Marketing Scientist ($129/mo • 2,500 MCP calls/mo, 20/min burst): CM1→CM3 profit waterfalls & Klaviyo 4-min cannibalization
- ✓M4 Executive BI & Storyteller ($79/mo • 1,500 MCP calls/mo, 15/min burst) | Full Suite ($199/mo • 5,000 calls/mo, 30/min burst)
5-Day Ecommerce & Attribution Diagnostic Sprint
Fixed-Scope Executive Audit + 90-Day Remediation Roadmap
Best For: CMOs, VPs of Growth & Heads of Ecommerce ($10M–$150M GMV)
In 5 business days, we audit your GA4, GTM/sGTM, Shopify/CRM, and Paid Media warehouse pipeline to expose hidden tracking drops, attribution inflation, and negative-CM3 campaigns.
- ✓End-to-end GA4 + Server-Side GTM + CAPI event integrity & deduplication audit
- ✓Platform-reported ROAS vs. net-of-refunds CM3 profitability reconciliation
- ✓Executive Interactive Review Hub & Power BI / Looker diagnostic scorecard
- ✓Prioritized 90-day engineering & experimentation remediation roadmap
- ✓100% of sprint fee credited when upgrading to Custom Skill Build or Retainer
Enterprise Custom Skill + Self-Updating Meta-Skill
In-House Tribal Knowledge + Warehouse Schema + Autonomous Evolution
Best For: VPs of Data, CTOs, COOs & Heads of BI / Analytics Engineering
We ingest your Confluence/Notion docs, map your Snowflake/BigQuery/dbt schemas, and deliver a private Agent Skill suite-paired with our self-updating meta-skill or prepaid architect hours so it never goes stale.
- ✓Tier 1 Base Build ($12,500): Custom Enterprise Skill tailored to your schemas & WBR/QA SOPs
- ✓Solves schema drift: never worry about what happens when dbt models or KPI rules change in 60 days
- ✓Full InfoSec compliance: executes inside your VPC/warehouse with zero row-data egress
- ✓Includes automated regression eval suite & team onboarding workshop
Companion meta-skill that auto-scans dbt manifest.json & INFORMATION_SCHEMA diffs plus new Jira/PRD specs via /update-company-skill.
Dedicated Principal Architect hour bank (12-month validity, 24h SLA, live burn-down ledger) for new data sources, M&A schemas, or board models.
Fractional Principal Data & AI Architect
Ongoing Strategic Technical Leadership & Fractional Ownership
Best For: Series B–D FinTech, B2B2C Healthcare & Enterprise D2C Leadership
Direct principal-level ownership of your data platform architecture, experimentation governance, marketing science roadmap, and internal AI agent engineering.
- ✓ Hands-on ownership of BigQuery / Snowflake / dbt architecture & data governance
- ✓Executive C-suite & Board reporting (Power BI, Looker, automated WBR synthesis)
- ✓Experimentation velocity leadership across Statsig, AB Tasty, Optimizely & Amplitude
- ✓Team mentorship, hiring bar calibration, and vendor/cloud cost optimization
Ready to Turn Telemetry Into Board-Verified Profit?
Whether you need a rapid 5-day marketing data audit, a custom self-updating enterprise AI agent skill for your stack, or ongoing fractional principal leadership across BigQuery, Snowflake, dbt, and Power BI-let's build infrastructure that scales.