Data Pipeline Architect — ETL & Analytics Engineering Prompts

Data Pipelines That Don't Break at 3 AM

12 prompts for data engineers who are tired of brittle pipelines, missing data, and "it worked in staging."

What's Inside

• dbt Model Designer — Generates staging → intermediate → mart layer models with proper materializations and tests
• Airflow DAG Planner — Creates DAG structures with proper dependencies, retries, SLAs, and alerting
• Data Quality Framework — Generates Great Expectations / dbt tests for completeness, freshness, uniqueness, and business rules
• Schema Evolution Strategist — Plans backward-compatible schema changes with migration scripts
• Warehouse Cost Optimizer — Analyzes query patterns and recommends clustering, partitioning, and materialization changes
• + 7 more: CDC pattern selector, slowly changing dimensions handler, data lineage mapper, incremental model converter, reverse ETL designer, semantic layer builder, data mesh domain boundary definer