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. * 6–12 years of core IT/Database Operations experience, with a minimum of 4–8+ years operating explicitly as on 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](https://blueyonder.com/about/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.