Job Summary:

We are seeking a skilled and proactive Snowflake Administrator with deep experience in Amazon Web Services (AWS) environments to manage and optimize our cloud-based data infrastructure. In this role, you will be responsible for the administration, integration, security, and performance of Snowflake, ensuring it supports the organization's evolving data analytics and business intelligence needs. The ideal candidate is detail-oriented, security-minded, and collaborative, with hands-on expertise in Snowflake and AWS services.

Job Duties & Responsibilities:

1. Administer and maintain the Snowflake cloud data platform on AWS, configuring databases, schemas, and virtual warehouses for optimal performance and availability.

2. Integrate Snowflake with AWS services such as S3, IAM, Lambda, and Glue to enable seamless, secure, and efficient data workflows.

3. Automate user and role management in Snowflake using scripting tools and AWS Lambda to support scalable, secure access control across teams.

4. Enforce data security policies including encryption via AWS KMS and Snowflake-native access controls to protect sensitive information and maintain compliance.

5. Design and manage real-time and batch data ingestion pipelines using Snowpipe and AWS Glue, supporting downstream analytics and reporting systems.

6. Monitor performance metrics using AWS CloudWatch and Snowflake monitoring tools; proactively address performance issues and system reliability.

7. Deploy infrastructure using Infrastructure-as-Code tools like Terraform for consistent and automated provisioning of Snowflake and AWS resources.

8. Configure data protection features such as Snowflake Time Travel and AWS S3 backups to support data recovery and ensure business continuity.

9. Analyze and manage costs associated with Snowflake and AWS using tools like AWS Cost Explorer; implement cost optimization strategies.

10. Collaborate with data engineers, business analysts, and stakeholders to gather requirements and deliver solutions using agile methodologies and tools like Jira.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).

• 3+ years of hands-on experience administering Snowflake in a production environment.

• Strong working knowledge of AWS services including S3, IAM, Lambda, Glue, CloudWatch, and KMS.

• Experience with scripting languages (e.g., Python, Bash) for automation and integration tasks.

• Proficiency with Infrastructure as Code (IaC) tools such as Terraform or AWS CloudFormation.

• Solid understanding of data security best practices and compliance (e.g., encryption, RBAC).

• Experience with cost management tools and optimization strategies in cloud environments.

• Excellent problem-solving, communication, and collaboration skills.