Snowflake administrator

Tekgence Inc; Montreal (administrative region); On-site; CAD 80,000 - 100,000; Part time

Job summary

A leading data solutions company in Montreal, Quebec, is looking for a skilled Snowflake Administrator to manage and optimize their Snowflake Data Cloud environment. Responsibilities include user management, security, performance tuning, and cost governance. The ideal candidate should possess a strong understanding of Snowflake architecture, SQL expertise, and experience with automation tools. This contract role offers the opportunity to ensure scalable and secure data operations.

Qualifications

• Strong understanding of Snowflake architecture and multi-cloud concepts.
• Expertise in SQL, query tuning, and warehouse optimization.
• Deep knowledge of RBAC, security policies, and compliance frameworks.
• Experience with automation using CI/CD tools.
• Familiarity with data ingestion tools like Snowpipe, Streams, and Tasks.

Responsibilities

• Manage user, role & access management.
• Ensure security & compliance across the Snowflake environment.
• Optimize warehouse and compute resource usage.
• Monitor performance and optimize queries.
• Govern costs and resources effectively.

Skills

Snowflake architecture

SQL

Query tuning

RBAC

Security policies

Compliance frameworks

Automation with CI/CD tools

Data ingestion tools

User management

Performance Monitoring

Tools

Git

Azure DevOps

Jenkins

Job description

Snowflake Administrator

A Snowflake Administrator is responsible for managing, securing, optimizing, and governing an organization’s Snowflake Data Cloud environment. The role focuses on user management, access control, warehouse configuration, performance tuning, automation, and cost governance to ensure smooth, secure, and scalable data operations.

Responsibilities

• Strong understanding of Snowflake architecture and multi-cloud concepts.
• Expertise in SQL, query tuning, and warehouse optimization.
• Deep knowledge of RBAC, security policies, and compliance frameworks.
• Experience with automation using CI/CD tools (Git, Azure DevOps, Jenkins, etc.).
• Familiarity with data ingestion tools like Snowpipe, Streams, and Tasks.
• User, Role & Access Management
• Security & Compliance
• Warehouse & Compute Resource Management
• Performance Monitoring & Query Optimization
• Cost & Resource Governance
• Data Governance & Metadata Management
• Automation & DevOps Integration
• Monitoring & SnowSight Administration

Seniority Level

• Mid-Senior level

Employment Type

• Contract

Job Function

• Information Technology, Administrative, and Business Development
• IT Services and IT Consulting, Software Development, and Information Services