Dorian T.

I help data-driven companies get AI-ready. I build the data foundations, dashboards and AI systems their teams run on: cloud warehouses, dbt modeling, reliable ingestion pipelines, and reporting and AI they can actually run their business on. I've worked with performance marketing agencies, DTC e-commerce brands, Shopify agencies, real estate lead-gen companies, SaaS startups, B2B service businesses, media and creator-led agencies, professional services firms, and subscription-based businesses — supporting 7-figure ad budgets, multi-channel attribution setups, financial and operational reporting, and environments where executives make real revenue decisions on the numbers. Accuracy isn't optional in any of those contexts, and that's the bar I build to. Most of the teams I work with come to me after struggling with conflicting KPIs across platforms, fragile "Frankenstein" automations, manual reporting bottlenecks, dashboards they can't fully trust, or AI pilots that gave wrong answers because the data underneath wasn't ready. Beyond technical depth, I'm a clear communicator with both engineers and non-technical founders. I'll explain why your numbers don't reconcile across platforms in language your CEO understands — and I'll fix it. Services I Offer: → Data Warehouse Architecture: Designing and building production data warehouses on BigQuery, Snowflake, or Postgres — schema modeling, dbt projects, and the foundations that make every dashboard downstream trustworthy. → ETL & Data Pipelines: Replacing fragile Supermetrics/Zapier sprawl with reliable, auto-refreshing ingestion via Airbyte, Fivetran, or custom Python pipelines. Marketing, CRM, revenue, and ops data — unified in one place. → Analytics & Reporting Systems: Building multi-page Looker Studio, Power BI, or Metabase dashboards that read from a modeled warehouse, not raw API pulls — fast, accurate, and reconciled across every report. → Business Automation & Workflow Engineering: n8n and Make automations that handle data syncing, lead routing, enrichment, internal notifications, and operational workflows — reliably, with monitoring and alerting built in from day one. → AI Systems & Agents: AI analysts that answer questions from your warehouse in Slack, lead scoring and enrichment written back to your CRM, anomaly alerts, and LLM-powered workflows. Built on clean, governed data, so the answers are right. My core stack and expertise: → Programming Languages: Python (Pandas, Polars, PySpark), SQL, Bash → Data Modeling & Transformation: dbt, SQL, Python — clean staging → intermediate → mart architecture with tests and documentation → Cloud & Warehousing: BigQuery, Snowflake, PostgreSQL, DuckDB, S3 + Delta Lake → Data Ingestion / ETL: Airbyte, Fivetran, Meltano, custom Python connectors → Orchestration: Airflow, Dagster, Mage, Cloud Functions, GitHub Actions → Analytics & Tracking: GA4, Mixpanel, event-based analytics, server-side tracking → Visualization & BI: Looker Studio, Power BI, Metabase, Superset, Tableau → Automation & AI: Make, n8n, Claude API, OpenAI API, LLM-powered workflows → DevOps: GitHub Actions, Docker, Terraform, CI/CD pipelines