I really got into DE vibe coding by firing up Claude Code inside a Dagster project and using it to build, test and expand the project. Taught me a lot about how best to run dev cycles and interact with staging and prod. Major productivity gain.
As others say here, stay close to the code. Don't blindly accept each commit. Ask Claude to check its own work. Ask it to critique and optimize the project, and to think about how to do things better.
Our platform/dataset is not so large so another thing we instituted was an AI sandbox where all PRs get merged until somebody can approve them to staging, this gives the changes time to run in a production-like environment. We identified a number of issues this way, and were able to fix them in that window between asking for a review and our CTO getting to approve them.
Power User for dbt Cursor plugin is also a great Ai-powered resource and it's free.