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 Systems Across B2B2C Biotech, FinTech, Telecom & Civic AI
Client engagements strictly enforce zero-disclosure brand anonymity while exposing the exact warehouse patterns, dbt watermarks, experimentation gates, and multi-model Gemini topologies we deploy.
Unifying B2B Healthcare Practitioner (HCP) Revenue & DTC Patient Demand Generation in BigQuery, dbt & Power BI
Challenge: Commercial leadership needed a single source of truth separating B2B clinic/practitioner purchasing (hcp.* domains & loyalty tiers) from DTC consumer demand-generation media (Meta, Google Ads, GA4clinic finder flows), while preventing many-to-many fanout bugs in executive Power BI dashboards.
- ▹Architected a multi-layered BigQuery & dbt project (staging → intermediate → marts) with strict grain enforcement (campaign-level vs. brand-level vs. GA4 event-level).
- ▹Engineered dynamic table watermark lookbacks (MAX(date) - 3) using BigQuery incremental insert_overwrite partitioning to handle late-arriving ad platform conversions at minimal slot cost.
- ▹Designed the Power BI DAX V2 Semantic Model (.SemanticModel TMDL definitions) with isolated Strategy_KPI_Mapping calculation bridges and custom Deneb (Vega-Lite) executive KPI cards.
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.