Satyarth Jaiswal

Analytics Engineer · Data Analyst · Marketing Data Analyst

SATYARTH2.jpeg

I build automated data systems that turn messy multi-channel marketing data into clear, decision-ready insights — saving teams 40+ hours a month and eliminating manual reporting.

With 10+ years across marketing and analytics, I specialise in BigQuery, dbt, SQL, and Looker Studio — designing ETL/ELT pipelines, data models, and dashboards that connect ad spend directly to business outcomes like leads, pipeline, and revenue.

Currently open to Analytics Engineer, Data Analyst, and Marketing Data Analyst roles where data directly drives growth strategy and business performance. Based in Toronto, Canada — open to remote.

✉️ Get in touch LinkedIn → 📄 Resume →

What I Specialise In

🔧
ETL / ELT Pipelines
End-to-end data ingestion from Google Ads, Meta Ads & CRM into BigQuery — automated, scheduled, and reliable.
🧱
Data Modelling
Staging, intermediate, and mart layers using dbt — clean schemas, tested models, and reusable transformation logic.
📊
BI Dashboards
Live dashboards in Looker Studio & Power BI that translate KPIs into campaign decisions — for teams and C-suite alike.
🎯
Campaign Attribution
Connecting ad clicks (GCLIDs, UTMs) to CRM lead records — mapping spend to leads, pipeline stages, and wins.
🤖
Automation & AI
Python scripts, OCR pipelines, and GPT-powered document processing — turning manual workflows into zero-touch systems.
📈
Marketing Analytics
Cross-channel performance analysis across Google, Meta, CRM — CPL, ROAS, device, geo, and keyword-level insights.

Selected Work

DATA ENGINEERING · dbt · BIGQUERY
Marketing Analytics Pipeline & Live Dashboard
Saved ~50 hrs/month — 20+ campaigns, 20 US cities, real-time Looker Studio dashboard for client & internal teams.
BigQuery dbt Looker Studio
DATA ENGINEERING · SQL · BIGQUERY
Digital Ads Data Pipeline & Dashboard
Saved ~40 hrs/month — automated Google & Meta Ads ingestion into BigQuery with live Looker Studio reporting.
BigQuery SQL Looker Studio
AI & AUTOMATION · PYTHON · GPT-4o
OCR & AI-Powered Care Note Pipeline
20,000+ pages processed in minutes — OCR extraction, GPT-4o rephrasing, and PDF generation for a US NGO.
Python GPT-4o Tesseract OCR
View all projects →

How I Work

1️⃣ Define the Question Business first, data second 2️⃣ Model the Data Staging → Mart layers 3️⃣ Automate Everything Scheduled, incremental 4️⃣ Surface the Insight Dashboards for every audience 5️⃣ Drive the Decision Data changes what happens next

Core Tools

DATA WAREHOUSE & TRANSFORMATION
🔷 BigQuery 🔶 dbt Cloud 📋 SQL 🐍 Python
BI & DASHBOARDS
📊 Looker Studio 📊 Looker 📊 Power BI 📊 Tableau
DATA SOURCES & INTEGRATIONS
🔵 Google Ads API 🔵 Meta Ads API 🟢 Google Sheets 🗂 CRM Systems
AI & AUTOMATION
✨ GPT-4o / OpenAI 🎈 Streamlit ⚙️ Scheduled Queries