Senior Snowflake Administrator and Cloud DBA Consultant

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.

Experience Level

Senior Level