Job Description:
Extensive hands-on experience in Snowflake design, implementation and management
Manage and maintain Snowflake environments by handling provisioning, configuration, and monitoring, implementing security best practices for data access, user roles, and encryption, and performing regular database maintenance tasks including backups, data purging, and archiving
Monitor and optimize Snowflake performance through query tuning, workload management, and storage optimization, identifying and resolving performance bottlenecks to ensure efficient resource utilization
Support data integration processes by handling ETL activities using Azure Data Factory, AWS Glue, and Snowflake's capabilities, collaborating with data engineering teams to design and implement data pipelines and workflows
Manage and optimize Azure and AWS cloud resources supporting the Snowflake environment, including virtual networks, storage accounts, and compute resources, ensuring high availability, disaster recovery, and business continuity for Snowflake on both Azure and AWS
Ensure compliance with data governance, security policies, and regulatory requirements by implementing and managing data encryption, access controls, and auditing mechanisms
Provide technical support for Snowflake-related issues, including incident management and root cause analysis, collaborating with support teams to resolve issues and implement preventive measures
Collaborate with cross-functional teams such as data engineers, analysts, and business stakeholders to address data requirements, and maintain comprehensive documentation of Snowflake configurations, processes, and procedures
Qualifications
Bachelor's degree in computer science, Information Technology, or a related field
Proven experience as a Snowflake Administrator or similar role, with hands-on expertise in managing Snowflake environments
Strong knowledge of Azure and AWS cloud services, including Azure Data Factory, AWS Glue, Azure/AWS Storage, and Azure/AWS Virtual Networks
Proficiency in SQL and experience with performance tuning and query optimization
Familiarity with data integration tools and ETL processes
Experience with data security and compliance best practices
Excellent problem-solving skills and ability to troubleshoot complex issues
Strong communication and collaboration skills
Bachelor's degree