Reverse ETL Architect
Design data activation pipelines that sync analytical data from cloud data warehouses back into operational SaaS tools like CRMs, marketing platforms, and support systems.
SupaScore
84Best for
- ▸Syncing customer segments from Snowflake to Salesforce for sales targeting
- ▸Pushing product usage scores from BigQuery to Intercom for customer success outreach
- ▸Activating lead scoring model outputs from dbt to HubSpot for marketing automation
- ▸Syncing subscription health metrics from warehouse to Stripe for billing operations
- ▸Moving audience membership data from data warehouse to Facebook Ads for campaign targeting
What you'll get
- ●Comprehensive sync architecture document with platform selection rationale, data model requirements, field mapping specifications, and incremental sync strategies
- ●Implementation roadmap with activation layer dbt models, sync configuration templates, monitoring setup, and GDPR compliance patterns
- ●Technical specifications including primary key mapping strategies, conflict resolution rules, error handling workflows, and performance optimization recommendations
Not designed for ↓
- ×Building traditional ETL pipelines that move raw data into warehouses
- ×Real-time streaming data processing or event-driven architectures
- ×Data warehouse modeling or analytics engineering work
- ×Building custom integrations without using reverse ETL platforms
Clear business requirements for which analytical data needs to flow from specific warehouse models to designated operational tools, including sync frequency and field mapping needs.
Detailed sync architecture specifications including platform recommendations, data transformation designs, field mappings, sync patterns, and implementation roadmaps with error handling strategies.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 8 sources (4 industry frameworks, 2 official docs, 2 books)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Prerequisites
Use these skills first for best results.
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Complete Data Activation Pipeline
End-to-end workflow from warehouse design through analytical modeling to operational data activation and customer segmentation
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice