Technical Consultant - Snowflake Administrator , Cloud DBA, Python, FinOps & SnowPro Advanced
Scope:
This is a highly strategic, pure operations and infrastructure leadership role. It does not involve building data pipelines, ETL, or data models.
You will act as the ultimate technical authority for platform reliability, security, and governance, administering the underlying Snowflake infrastructure that supports globally distributed, multi-tenant SaaS applications operating at petabyte scale.
The role demands deep expertise in systems administration, securing network perimeters, managing automated identity lifecycles, and engineering massive-scale cost-governance frameworks across dozens of federated Snowflake accounts.
Technical Environment:
Platform Infrastructure: Multi-Org/Multi-Account management, Multi-tenant Data-as-a-Service (DaaS) sharding topologies, Serverless Compute governance, Snowflake Cortex & Snowpark Container Services (SPCS) compute administration.
Identity & Access Lifecycle: OAuth 2.0 (External & Custom Clients), Machine-to-Machine (M2M) Authentication, Identity Provider (IdP) integration (Azure AD B2C, Okta, Entra ID), SCIM provisioning, Automated Key-Pair rotation, Tri-Secret Secure administration.
Enterprise Security & Network Posture: Zero-Trust Network Rules, AWS PrivateLink / Azure Private Link / Google Cloud Private Service Connect, Attribute-Based Access Control (ABAC), Hierarchical RBAC, Dynamic Data Masking, Row Access Policies, Audit Logging & Access History forensics.
Global Business Continuity (BC/DR): Account-level Replication, Client Redirect, Cross-Region/Cross-Cloud Failover Groups, strict RPO/RTO SLA enforcement, Storage fail-safe and Time Travel retention management.
FinOps & Compute Governance: Enterprise-wide compute right-sizing, programmatic Object Tagging for cost attribution, Organization Account Usage analytics, Resource Monitor enforcement, and concurrency scaling parameters.
Platform Operations (DataOps): Terraform (IaC) for account and object provisioning, system-level automation scripting (Python/SnowSQL), Notification Integrations, External Storage Integrations (AWS IAM/Azure Managed Identities).
What you’ll do:
Design & Architect: Define scalable, petabyte-scale data lakehouse architectures. Establish enterprise coding standards, hierarchical RBAC models, and data security best practices.
Develop & Deliver: Architect multi-cluster compute topologies for high-concurrency workloads. Build low-latency integrations with external compute engines and catalogs.
Guide & Govern: Provide technical leadership to data engineers. Lead technical whiteboarding sessions and data strategy workshops with business stakeholders.
Operate & Optimize: Implement robust FinOps monitoring, compute quotas, and warehouse right-sizing routines. Perform deep root-cause analysis on chronic platform contention issues.
What we are looking for:
Bachelor’s degree in Information Technology, Systems Engineering, Computer Science, or a related field.
9–12 years of core IT/Database Operations experience, with a minimum of 5–7+ years operating explicitly as a Lead Snowflake Administrator or Cloud DBA in a Fortune 500 or multi-tenant SaaS environment.
Strictly Admin Focused: This role requires a background in systems administration, database administration (DBA), or cloud infrastructure. Candidates whose primary background is Data Engineering or ETL development will not be a fit.
Mastery of Snowflake’s security models, specifically concerning programmatic API access, Oauth 2.0 configuration, SCIM, and automated credential rotation.
Deep expertise in resolving complex Snowflake concurrency issues, managing queuing logic, and debugging systemic infrastructure bottlenecks via query profiling.
Advanced scripting skills (Python, bash, SnowSQL) specifically utilized for systems administration, platform automation, and integrating with CI/CD pipelines (Terraform).
Certifications: SnowPro Advanced: Administrator is heavily preferred. Active cloud administration certifications (AWS SysOps/Azure Administrator) 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.
Skills Required
- 9-12 years of core IT/Database Operations experience
- 5-7+ years operating as a Lead Snowflake Administrator or Cloud DBA
- Mastery of Snowflake's security models and programmatic API access
- Advanced scripting skills in Python, bash, SnowSQL
- SnowPro Advanced Administrator certification
Blue Yonder Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Blue Yonder and has not been reviewed or approved by Blue Yonder.
-
Leave & Time Off Breadth — PTO is described as generous or “unlimited” in the U.S., alongside paid holidays, sick time, and two paid volunteer days. These policies are often highlighted as strengths that support work–life balance.
-
Flexible Benefits — Remote-work options and flexible arrangements are emphasized as part of the package. This flexibility is valued alongside compensation and can help offset middling pay for some roles.
-
Healthcare Strength — Medical, dental, and vision coverage are provided, with mental health/EAP support and HSA/FSA options referenced. These core coverages are portrayed as solid and comprehensive.
Blue Yonder Insights
What We Do
Blue Yonder is the world leader in digital supply chain and omni-channel commerce fulfillment. Our intelligent, end-to-end platform enables retailers, manufacturers and logistics providers to seamlessly predict, pivot and fulfill customer demand. With Blue Yonder, you can make more automated, profitable business decisions that deliver greater growth and re-imagined customer experiences. Blue Yonder - Fulfill your Potential Blue Yonder’s tagline “Fulfill Your Potential” reflects the company’s mission to empower every organization and person on the planet to fulfill their potential. Each day, our global teams of associates and business partners work together to accelerate global economic growth, increase sustainability and prosperity with a Sonoran Spirit.
