Services · AI-Augmented

End-to-End Data Automation

From raw API data to actionable dashboards — fully automated, AI-augmented, zero manual steps. Four ways I plug into your stack.

Dashboards & Reporting

Custom Looker Studio dashboards built on top of your data warehouse. Real-time visibility into sales, advertising, inventory, and growth metrics — designed for decision-making, not just data display.

What’s Included

  • Looker Studio dashboards connected to BigQuery
  • Sales performance, PPC/advertising, and inventory views
  • Multi-brand and multi-marketplace roll-ups
  • Scheduled email reports and PDF exports
  • GA4 and Shopify integration where needed
  • Ongoing maintenance and iteration
Looker Studio BigQuery GA4 SQL

Looker Studio · Sample Layout

Revenue
$5.34M
▲ 14.8%
Orders
199.8K
▲ 11.2%
ROAS
3.96×
▲ 0.4×
TACOS
6.0%
▼ 0.8 pts
Revenue Trend · Stacked by Channel
Amazon Instacart Walmart Criteo
Channel Scoreboard
Amazon$4.31M3.34×
Instacart$871K7.27×
Walmart$87K4.37×
Criteo$74K8.26×
Claude Code · brand-data-workspace
YO
You
What’s our weekly ACOS trend per brand on Amazon US?
V
Vin
Reading schema · building SQL · querying BigQuery…
V
Vin
Here’s the trailing 4-week ACOS by brand on Amazon US:
Brand W-4 W-1 Δ
Brand A22.1%24.8%+2.7
Brand B18.4%16.2%−2.2
Brand C31.0%28.7%−2.3
Takeaway: Brand A’s ACOS climbed 2.7 pts — the only brand trending wrong way. Worth flagging for PPC review.
Ask Vin anything about your business…

AI-Integrated Workspaces

Give your team their own AI VA — pre-wired to your data warehouse, briefed on your business, ready to answer questions in plain English. No SQL knowledge needed. Meet Vin — a custom Claude Code workspace that gets sharper every week as you brief it.

Dashboards for the questions you already know to ask. Vin for everything else — ad-hoc reports, anomaly digs, weekly takeaways in plain English, delivered as clean HTML.

What’s Included

  • Claude Code workspace pre-configured for your data stack
  • Custom skills for your common reports (weekly P&L, PPC, inventory)
  • MCP integration — read-only, scoped access to your BigQuery
  • Memory architecture so the AI learns your business over time
  • Slash commands for recurring workflows your team runs weekly
  • Onboarding flow so your team is productive on Day 1
Claude Code MCP BigQuery Python

Data Pipeline Engineering

I build automated pipelines that pull data from your selling platforms and consolidate everything into a clean, queryable data warehouse. No more downloading CSVs or copy-pasting between spreadsheets.

What's Included

  • Amazon SP-API integration (orders, inventory, advertising, finance)
  • Multi-marketplace consolidation (NA, EU, and more)
  • Walmart, Instacart, Criteo, and retail platform connectors
  • BigQuery data warehouse setup and optimization
  • Scheduled ETL — data refreshes automatically, daily or hourly
  • Data validation and error alerting
Python BigQuery SP-API n8n

Pipeline Architecture

Amazon SP-API
Walmart MP
Instacart Ads
Criteo · GA4
BigQuery
Curated tables
Partitioned
Scheduled ETL
Looker Studio
n8n Alerts
Claude Code
Sheets / API

One warehouse, many surfaces — dashboards, alerts, and AI agents all read from the same curated layer.

Workflow Automation

If you’re doing it manually and repeatedly, I can automate it. Using n8n (open-source workflow automation), I build systems that run 24/7 — pulling data, syncing platforms, generating reports, and increasingly using AI agents inside the workflow to flag anomalies and draft alerts before they fire.

What's Included

  • n8n workflow design and deployment
  • Scheduled data pulls and cross-platform syncs
  • Slack/email alerts on KPI thresholds
  • Google Sheets and Apps Script integrations
  • Webhook-based triggers and API integrations
  • Self-hosted on your infrastructure or mine
n8n Python Claude Code Apps Script Webhooks

n8n Workflow · Sample

Trigger
Schedule · daily 6am
Pull
SP-API · orders
Transform
Python · clean
Load
BigQuery · upsert
AI Check
Claude · anomaly
Alert
Slack / Email

Runs 24/7 without you. AI agents inside the workflow flag anomalies and draft the Slack message before sending.

How I Work

1

Discovery

Understand your data sources, goals, and pain points

2

Build

Set up pipelines, warehouses, and dashboards

3

Automate

Eliminate manual work with scheduled workflows

4

Maintain

Ongoing support, iteration, and optimization

Let’s Build Your Data Stack

Whether you need a full pipeline from scratch, want to automate what you already have, or want to hand your team an AI VA that already knows your business — I can help.

Get in Touch