Technical Consultant - Snowflake Admin

Blue Yonder; Coimbatore District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Blue Yonder is seeking a Senior Snowflake Platform Administrator to join the Platform Administration team. You will secure a highly available Snowflake environment across Dev, UAT, Pre-Prod, and Prod, participating in a 24x7 rotation as the primary L3 escalation contact.

You will automate platform operations, manage DR failovers, enforce SCIM-based user provisioning, and guide L1/L2 engineers in performance and monitoring practices.

Qualifications

• Bachelor's degree in Computer Science, Engineering, IT or a related field.
• 5+ years of IT/Operations experience with 5+ years in Snowflake platform administration and architecture.
• Experience in 24x7 rotational shift environments and ITIL change/incident management (ServiceNow/Jira).
• Deep proficiency in RBAC, SCIM provisioning, and enterprise FinOps strategies.

Responsibilities

• Design and maintain hierarchical RBAC and SCIM-based user provisioning for automated onboarding/offboarding.
• Automate routine platform administration using Python and Snowflake REST APIs; deploy Snowflake infrastructure via Terraform and CI/CD pipelines.
• Own platform FinOps: set up resource monitors, right-size warehouses, enforce auto-suspend/resume, generate chargeback reports.
• Act as primary L3 escalation across shifts to triage incidents, manage cross-region DR, and coordinate vendor support and telemetry exports to Datadog/Splunk.

Skills

Snowflake admin

RBAC design

SCIM provisioning

FinOps

Python scripting

SnowSQL

Terraform IaC

CI/CD pipelines

ITIL processes

Vendor support

Education

Bachelor's degree in CS/Engineering

Tools

Okta/Entra ID

SAML SSO

Datadog

Splunk

ServiceNow

Jira

GitHub Actions

GitLab

Job description

• The Platform Administration team partners with engineering and business groups to ensure a secure, highly available, and cost-efficient enterprise Snowflake environment across Dev, UAT, Pre-Prod, and Prod environments.
• This role operates within a 24x7 rotational shift model (Day, Afternoon, Night), serving as the primary L3 escalation contact and ensuring zero information gaps across global follow-the-sun coverage.
• The position focuses heavily on executing automated platform operations—managing disaster recovery failovers, optimizing platform FinOps, enforcing automated identity lifecycles (SCIM), and guiding L1/L2 platform support engineers.

Scope

• The Platform Administration team partners with engineering and business groups to ensure a secure, highly available, and cost-efficient enterprise Snowflake environment across Dev, UAT, Pre-Prod, and Prod environments.
• This role operates within a 24x7 rotational shift model (Day, Afternoon, Night), serving as the primary L3 escalation contact and ensuring zero information gaps across global follow-the-sun coverage.
• The position focuses heavily on executing automated platform operations—managing disaster recovery failovers, optimizing platform FinOps, enforcing automated identity lifecycles (SCIM), and guiding L1/L2 platform support engineers.

Technical Environment

• Snowflake Platform Administration: Multi-Cluster Warehouses, Resource Monitors, Storage & Compute Optimization, Time Travel, Fail-safe, Zero-Copy Cloning, Organization & Account Management, Replication Groups.
• Security & Identity Management: Hierarchical RBAC models, SCIM Provisioning, SSO/SAML Integrations (Okta, Microsoft Entra ID), Network Policies (PrivateLink), OAuth, Key Pair Authentication.
• Governance & Compliance: Dynamic Data Masking, Row Access Policies, Object Tagging for data classification, Secure Data Sharing, routine audit logging (ISO 27001 compliance).
• Platform Resilience & Integrations: Account Replication, Cross-Region Failover/Disaster Recovery (DR), integration with observability/SIEM tools (Datadog, Splunk).
• Infrastructure & Operations (DataOps): Terraform (Infrastructure-as-Code), CI/CD pipelines for object deployment (GitHub Actions/GitLab), ITIL/ITSM incident management (ServiceNow/Jira).
• Automation & Scripting: Python (admin automation, REST APIs), SnowSQL, Shell Scripting for automated user lifecycle management.

What You’ll Do

• Design & Architect: Implement and maintain robust hierarchical RBAC models and Identity Provider integrations (Okta/Entra ID) for SCIM-based automated user provisioning and SSO. Enforce strict Network Policies restricting access to approved corporate IP ranges and private endpoints.
• Automate & Deliver: Automate routine platform administration, such as user lifecycle management (onboarding, role changes, offboarding), using Python scripts invoking Snowflake REST APIs. Deploy Snowflake infrastructure and object changes utilizing Terraform modules via GitLab/GitHub CI/CD pipelines.
• Guide & Govern: Own the platform FinOps practice by configuring resource monitors with credit-cap alerts, right-sizing virtual warehouses, enforcing auto-suspend/resume policies, and producing chargeback reports. Mentor L1/L2 support engineers on performance interpretation and native monitoring techniques.
• Operate & Optimize: Act as the primary L3 escalation contact across rotating shifts to triage and resolve critical platform incidents (e.g., warehouse concurrency saturation, replication failures, SCIM sync errors). Execute cross-region DR drills, manage Snowflake vendor support tickets, and configure platform telemetry exports to Datadog and Splunk for real-time alerting.

What We Are Looking For

• Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related technical field.
• 5 + years of overall IT/Operations experience, with a minimum of 5 years explicitly dedicated to deep Snowflake platform administration and architecture.
• Proven experience operating in a 24x7 rotational shift environment, managing strict ITIL change/incident management processes (ServiceNow/Jira), and authoring structured shift handoff documentation.
• Deep proficiency in designing complex RBAC models, SCIM automated user provisioning, and implementing robust FinOps cost-reduction strategies at an enterprise scale.
• Hands‑on expertise utilizing Infrastructure-as-Code (Terraform) for database deployments and scripting (Python/SnowSQL) for administrative automation.
• Certifications: SnowPro Core required. SnowPro Advanced: Administrator is highly preferred. Additional certifications in Terraform, AWS/Azure, or ITIL 4 are a significant plus.

Our Values

If you want to know the heart of a company, take a look at their values. Ours unite us. They are what drive our success – and the success of our customers. Does your heart beat like ours? Find out here: Core Values

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.