Specialist Administrator - Snowflake

Yochana; Markham; Hybrid; CAD 110,000 - 170,000; Full time

Job summary

Yochana IT Solutions Inc. in Markham, Ontario is seeking a Specialist Administrator - Snowflake to lead hands-on Snowflake administration and platform operations in a hybrid onsite model (3 days on-site).

The role focuses on Snowflake architecture, RBAC and security, production environment management, performance tuning, cost optimization, and identity integration with SSO/SCIM, Entra ID, and Terraform-based deployments.

Qualifications

• 7+ years of hands-on Snowflake administration or cloud data operations.
• Deep understanding of Snowflake architecture: accounts, databases, warehouses, stages, and shares.
• Experience with RBAC, access controls, and least-privilege security.
• Experience in production Snowflake environments in enterprise or regulated settings.

Responsibilities

• Administer Snowflake environments and manage platform operations.
• Optimize performance and costs, monitor warehouses, troubleshoot queries.
• Implement security controls including network policies, masking, auditing.
• Manage identity integrations (SSO, SCIM, Entra ID) and MFA configurations.
• Use Terraform for IaC and automated deployments.

Skills

Snowflake administration

Snowflake architecture

RBAC & security

Production environment admin

Query performance tuning

Cost optimization

Identity integration

SSO / MFA

Tools

Terraform

Job description

Position Name – Specialist Administrator - Snowflake

Type of hiring – Fulltime

Location – Markham, ON - Hybrid (3 Days Onsite (Mon/ Tues/ Wed)

Job Description:

• 7 or more years of hands on experience with Snowflake administration, platform engineering, or cloud data platform operations.
• Strong understanding of Snowflake architecture, including accounts, organizations, databases, schemas, warehouses, stages, tasks, streams, shares, integrations, and account usage views.
• Strong experience with Snowflake RBAC, role hierarchy design, access management, security administration, and least privilege access patterns.
• Experience administering production Snowflake environments in an enterprise or regulated environment.
• Experience with Snowflake warehouse management, workload monitoring, query troubleshooting, performance tuning, and cost optimization.
• Experience with Snowflake security features such as network policies, authentication policies, masking policies, row access policies, object tagging, auditing, and service account controls.
• Working knowledge of identity integration patterns such as SSO, SCIM, Entra ID groups, MFA, service accounts, and key pair authentication.
• Experience with Terraform or infrastructure as code practices for platform configuration and automated deployments.