Snowflake Administrator Job at CloudHive, Irvine, CA

WmZDTnlXM2R2RjRxV1kvR0tFbjB3RFRy
  • CloudHive
  • Irvine, CA

Job Description

Snowflake Administrator – Performance & Optimization Focus

  • Locations: Southern California or Austin, TX
  • Work Model: Hybrid (3–4 days per week on-site)

Overview

We are seeking an experienced Snowflake Administrator to support and optimize a highly scaled, enterprise-grade data platform within a leading global investment management organization. This role is heavily focused on query performance tuning, workload optimization, and cost efficiency , supporting analytics and data workloads used across investment, risk, and business teams.

The ideal candidate brings deep expertise in Snowflake administration, a strong background in SQL optimization, and a proactive approach to improving performance and scalability in complex, high-demand environments.

Snowflake Performance & Optimization

  • Drive query performance tuning initiatives, including optimization of complex analytical SQL, joins, subqueries, and aggregations.
  • Analyze execution plans, query profiles, and system metrics to identify performance bottlenecks.
  • Optimize warehouse sizing, multi-cluster strategies, concurrency management, and workload isolation.
  • Apply best practices around clustering, micro-partition pruning, caching, and data access patterns.

Platform Administration & Operations

  • Administer Snowflake environments across development, test, and production.
  • Manage users, roles, access controls, resource monitors, and security configurations.
  • Ensure platform reliability, availability, and operational excellence.
  • Partner with data and analytics engineering teams to improve data models and query design.

Cost & Resource Governance

  • Monitor and optimize Snowflake usage and spend across teams and workloads.
  • Establish usage reporting, performance dashboards, and optimization standards.
  • Recommend architectural improvements to balance scalability, performance, and cost.

Collaboration & Enablement

  • Serve as a Snowflake subject matter expert, advising teams on performance best practices.
  • Collaborate with engineers and analysts to improve query patterns and platform efficiency.
  • Support enablement efforts through documentation, standards, and guidance.

Required Qualifications

  • 5+ years of experience with cloud data platforms, including significant hands-on Snowflake administration .
  • Expert-level SQL skills with demonstrated experience in query optimization and performance tuning.
  • Strong understanding of Snowflake architecture (warehouses, micro-partitions, caching, clustering).
  • Experience supporting high-concurrency, large-scale analytical workloads.
  • Proven ability to troubleshoot and resolve performance issues in production environments.

Preferred Qualifications

  • Experience in financial services, asset management, or other data-intensive, regulated industries.
  • Familiarity with modern analytics and BI tools (e.g., Tableau, Power BI, Looker).
  • Experience working alongside data engineering teams and transformation frameworks such as dbt.
  • Exposure to major cloud platforms (AWS, Azure, or GCP).

Job Tags

3 days per week,

Similar Jobs

Phillips Brothers Real Estate

Junior Real Estate Project Manager Job at Phillips Brothers Real Estate

 ...Job Title : Junior Real Estate Project Manager Location: Alpharetta, GA Office requirements : In-office Monday through Thursday 8:00 AM to 4:00 PM. Work from Home Fridays. Unlimited PTO. Infrequent site visits on an as-needed basis. About us: Phillips Brothers...