Design and implement scalable cloud data platforms and end-to-end ETL/ELT pipelines, migrate legacy infrastructure to Snowflake/AWS, optimize data warehouses, build transformations with dbt and Dagster orchestration, develop data processing with Python and SQL, implement IaC and CI/CD, and ensure data observability and governance while collaborating with stakeholders.