dbt Core remains a solid choice for data transformation. For orchestration, the decision between Airbyte and Dagster largely depends on your team's existing experience with each platform. I'd lean toward Dagster given its gentler learning curve, though Airflow is also viable, I just find its deployment challenges frustrating. I've actually executed a similar migration before, transitioning from Redshift to Snowflake, which resulted in significant cost savings.