Snowflake Admin

Key Responsibilities:

Administer and manage Snowflake environments including user roles, access control, and resource monitoring.

Develop, test, and deploy ELT/ETL pipelines using Snowflake SQL and other tools (e.g., Informatica, DBT, Matillion).

Monitor query performance and storage utilization; implement performance tuning and optimization strategies.

Manage and automate tasks such as warehouse scaling, Snowpipe ingestion, and task scheduling.

Work with semi-structured data formats (JSON, XML, Avro, Parquet) using VARIANT and related functions.

Set up and manage data sharing, replication, and failover across Snowflake accounts.

Implement and manage security best practices including RBAC, masking policies, and object-level permissions.

Collaborate with Data Engineers, Architects, and BI teams to support analytics use cases.

Required Skills:

Strong hands-on experience with Snowflake architecture, SQL, and performance tuning.

Experience with Snowflake features such as Streams, Tasks, Time Travel, Cloning, and External Tables.

Proficiency in working with SnowSQL and managing CLI-based operations.

Knowledge of cloud platforms (AWS / Azure / GCP) and integration with Snowflake.

Experience with data ingestion tools and scripting languages (Python, Shell, etc.).

Good understanding of CI/CD pipelines and version control (Git).