Data Pipeline & Marketing Automation

Замовник: AI | Опубліковано: 19.03.2026

I need a hands-on specialist to jump on a two-to-three-hour working session with me today at 7:30 PM IST. During this slot we will connect marketing, sales and fulfilment data sources, automate key workflows and leave the foundations of a clear reporting layer in place. The live work will revolve around Fivetran for ingestion, Zapier for task automation and orchestration on AWS. We will be pulling events from GA4, GTM and BigQuery, unifying behavioural data from PostHog and HYROS, and blending it with revenue and engagement signals flowing in from ActiveCampaign, Webflow, Facebook Pixel, Google Ads tags, Vidalytics, Typeform, HubSpot CRM, Zoom, Stripe, Hotmart, ClickUp and Circle. Once everything lands in the warehouse I want to shape it with dbt, validate the models in SQL and surface quick insights that prove the joins are solid. Acceptance criteria • All chosen sources are connected and syncing without errors. • At least one Zapier workflow triggers correctly and writes back to the warehouse. • dbt models run green and expose a consolidated “sessions → lead → revenue” table. • A quick Looker Studio or Redash query returns the expected counts, demonstrating end-to-end accuracy. If you live and breathe modern marketing stacks, can write Python or SQL on the fly and are comfortable screen-sharing while we build, let’s lock in the slot and get it done.