Hightouch-Style Reverse ETL Build

Замовник: AI | Опубліковано: 31.10.2025
Бюджет: 750 $

I need a lean, Hightouch-like reverse ETL layer that lets the Lopay team move curated Snowflake data into our day-to-day marketing tools, then fire real-time triggers from those destinations. The focus is on connectivity, reliability, and a dead-simple UI, not on heavy in-warehouse transformation—Snowflake already holds the cleaned tables. Snowflake will be the single source, and the first two destinations to wire up are Google Analytics and HubSpot. From Snowflake’s side I only need streamlined data loading: secure credentials handling, column mapping, upsert support, and job scheduling. Once the data lands in each tool, the platform should expose a rules engine or webhook layer so our marketers can set “if/then” audience triggers (e.g., when a user crosses a spend threshold, push the segment to HubSpot and ping a webhook for downstream messaging). Key deliverables: • A production-ready reverse ETL service (API + simple web console) • Connectors for Snowflake → Google Analytics and Snowflake → HubSpot, supporting incremental loads and historical backfills • Basic trigger framework that listens for load completion events and calls a webhook with payload details • Logging, retry logic, and alerting hooks so failures never go unnoticed • Clear setup documentation plus a hand-off walkthrough I’m happy with a lightweight stack—TypeScript, Python, or Go are all fine—as long as it’s containerised and can be deployed to our existing AWS environment.