Design and implement scalable Snowflake data architectures, optimize platform performance, develop data processing workflows with Snowpark, Python, and PySpark, and lead Hadoop-to-Snowflake migrations. The role defines target-state data warehouse architectures, establishes design standards, improves query and warehouse efficiency, ensures data integrity, and provides architectural guidance for enterprise cloud data modernization initiatives.