Description

Manage and optimize Snowflake data warehouse environments to ensure security, performance, and availability.

Administer Snowflake environments, including setup, configuration, monitoring, and optimization. Manage user access, roles, and permissions to maintain security and compliance. Monitor query performance, resource utilization, and storage management to drive tuning. Oversee data integration processes, including loading, transformation, and extraction. Implement backup and recovery strategies and maintain detailed system documentation.

Responsibilities

• Administer Snowflake environments, covering setup, configuration, and performance tuning.
• Manage user access, roles, and permissions to enforce security and compliance standards.
• Monitor query performance, resource utilization, and storage to optimize system efficiency.
• Oversee data integration processes, including loading, transformation, and extraction workflows.
• Implement backup and recovery strategies while maintaining comprehensive system documentation.

Required Skills

• 3+ years of hands-on experience managing and administering Snowflake environments.
• Strong proficiency in Snowflake architecture, features, and capabilities.
• Advanced SQL skills with expertise in Snowflake-specific query optimization.
• Experience with Snowflake security features, including access control, authentication, encryption, and masking.
• Experience working in AWS cloud environments.
• Proficiency in Python and PowerShell scripting.
• Experience with ETL tools, data pipelines, and data integration processes.
• Strong database design and data modeling experience.

Preferred Skills

• Snowflake certification (e.g., SnowPro Core or Advanced).
• Experience with Power BI and other data visualization tools.
• Knowledge of DevOps practices and T-SQL.

Key Skills

Education

Bachelor's Degree