Job Title: Snowflake Administrator
Location: Hyderabad, India
Experience Required: 5+ Years
Technical Knowledge:
Snowflake (Administration, Security, Resource Monitors, Tasks, Streams), SQL, Python, Azure Data Factory (ADF), Azure Synapse Analytics, AWS S3, AWS Glue, Google Cloud Storage, GitLab, CI/CD Pipelines, Power BI/Tableau, Data Governance, Data Cataloging, Data Quality Tools, RBAC, OAuth, SSO, Okta, ITSM tools (e.g., ServiceNow)
Role Summary:
We are looking for a Snowflake Administrator with over 5 years of experience in managing Snowflake environments across multi-cloud platforms. In this role, you will oversee Snowflake administration including security, access controls, performance optimization, monitoring, and automation. You will collaborate with data engineers, analysts, and cloud teams to ensure the platform runs securely, efficiently, and in alignment with organizational standards. This role is ideal for someone who excels in a fast-paced environment and brings strong knowledge in Snowflake infrastructure, governance, and automation practices.
Key Responsibilities:
Administer and manage all aspects of the Snowflake platform, including user access, RBAC, resource monitors, and warehouses.
Implement and maintain security policies, including SSO integration, MFA, OAuth, data masking, and row-level security.
Monitor Snowflake performance and usage; tune virtual warehouses and queries for cost optimization and efficiency.
Manage Snowflake objects (schemas, roles, databases) and control access based on least privilege principles.
Set up and automate alerts for platform health, resource usage, failed tasks/streams, and other system anomalies.
Support data backup, recovery, and time travel configurations for critical datasets.
Automate admin operations using Python scripts, Snowflake Procedures, and scheduled Tasks.
Collaborate with cloud teams on integrating Snowflake with platforms like ADF, S3, Glue, and GCS.
Implement and manage CI/CD pipelines for promoting admin/configuration changes across environments.
Ensure compliance with data governance, audit requirements, and regulatory standards.
Maintain documentation for access policies, configurations, and standard operating procedures.
Participate in troubleshooting and provide L2/L3 support for Snowflake-related issues.
Work closely with vendors and Snowflake support for platform improvements and issue resolution.
Mentor junior team members and guide best practices in Snowflake administration.
Requirements:
5+ years of hands-on experience as a dedicated Snowflake Administrator in managing enterprise-scale Snowflake environments.
Strong knowledge of Snowflake administration, including RBAC, resource monitors, security configurations, and storage/compute tuning.
Proficient in SQL and Python for automation and scripting.
Hands-on experience with user provisioning, SSO (Okta, Azure AD), OAuth, and access policies.
Familiarity with ADF, Glue, or GCS for Snowflake integration and data movement.
Experience setting up and managing Streams, Tasks, and materialized views for administrative workflows.
Understanding of data governance, compliance frameworks, and audit logging in Snowflake.
Experience with CI/CD pipelines using GitLab, GitHub Actions, or similar tools for infrastructure deployment.
Excellent problem-solving and troubleshooting skills for Snowflake platform issues.
Strong communication and documentation skills.
Bachelor's or Master’s degree in Computer Science, Information Systems, or a related field.
Preferred Skills:
Hands-on experience with Snowflake SSO integrations (Okta, Azure AD) and OAuth configurations.
Expertise in automating administrative tasks using Snowflake stored procedures, Tasks, and Python scripts.
Familiarity with cross-cloud data sharing, replication, and Snowflake Business Continuity (BCDR) setups.
