Snowflake Administrator Job at CloudHive, Irvine, CA

WGovQkEwUVhWeFFRd0JoSi83RlB6ZGNR
  • 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

Sloane Boutique (business in Moultre Plaza Coleman blvd)

PART TIME SALES ASSOCIATES Job at Sloane Boutique (business in Moultre Plaza Coleman blvd)

 ...Sloane Boutique is now actively looking for FALL/HOLIDAY PART TIME SALES ASSOCIATES in our MOUNT PLEASENT area store location Key Responsibilities: Customer Interaction: Assisting customers with finding merchandise, providing product information, and creating a... 

Topa Group, Inc.

Fire Alarm/Sprinker Inspector Job at Topa Group, Inc.

 ...Fire Sprinkler / Alarm Inspector Experienced Fire Sprinkler / Alarm Inspector needed in Fort Myers, FL and surrounding areas. Responsible for inspecting and testing fire sprinkler and alarm systems, identifying deficiencies, completing reports, and ensuring code compliance... 

ALLY CONSTRUCTION SERVICES

Construction Sales Manager Job at ALLY CONSTRUCTION SERVICES

 ...salary paid by ALLY)~ Short term disability insurance ~ Employee referral program incentives ~ Volunteer program ~ Tuition reimbursement ~ Great team environment with fun, caring, hardworking people We are a Veteran-Owned business and encourage our... 

StaffDash

Paramedic Job at StaffDash

 ...We are seeking an experienced Paramedic for a short-term 68 week assignment with a new client in the Atlanta area. Assignment Details...  ...and their families in homes and community settings. Travel to patients homes or community locations to address acute, episodic... 

Industrial Talent Group

Multi-Axis Lathe Programmer Job at Industrial Talent Group

 ...Lathe Programmer to support continued growth and increasingly complex work. This shop is known for its commitment to quality, process improvement, and long-term customer partnerships. If you take pride in precision machining and enjoy owning your programs and processes,...