The Snowflake Admin position at Cognizant involves designing, developing, and maintaining scalable data solutions using Snowflake's cloud-based data platform. The role focuses on optimizing performance, managing data workflows, and integrating Snowflake with various data sources and tools, while also leveraging Databricks and DBT for data processing and transformation.