Job Description
Job Overview: We are looking for a Snowflake Administrator to manage and enhance our Snowflake data platform, with a heavy focus on using Python to automate and streamline administrative tasks. This role requires a skilled professional capable of independently handling moderately complex Snowflake operations, ensuring scalability and performance while collaborating with data teams.
Primary Roles & Responsibilities:
· Configure and optimize Snowflake environments, including virtual warehouses, storage, and compute resources.
· Develop and maintain Python scripts to automate Snowflake administration tasks, such as resource scaling, user provisioning, and usage monitoring.
· Implement data integration workflows in Snowflake using Python, leveraging libraries like snowflake-connector-python or pandas for ETL processes.
· Monitor and tune Snowflake performance, using Python to analyze usage patterns and optimize costs.
· Manage Snowflake security, including role-based access control (RBAC) and encryption, with Python-driven automation.
· Troubleshoot and resolve Snowflake issues, ensuring high availability and data integrity.
· Collaborate with data engineers and analysts to support data pipelines and reporting needs in Snowflake.
· Document Snowflake setups, Python automation scripts, and operational procedures.
Preferred Skills:
· Experience with Snowflake features like data sharing or zero-copy cloning.
· Familiarity with CI/CD tools or version control (e.g., Git) for managing Python scripts.
Qualifications & Skills:
· Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
· 3-5 years of experience in data platform administration or a related role, with at least 1-2 years using Snowflake.
· Strong proficiency in Snowflake administration, including SQL, Snowpipe, and resource management.
· Advanced Python skills, with experience in automation, data manipulation (e.g., pandas, numpy), and Snowflake integration.
· Solid understanding of cloud platforms (e.g., AWS, Azure) and their integration with Snowflake.
· Good problem-solving skills and ability to work independently.
· Effective communication skills for collaborating with technical and business teams.
