Snowflake Administrator Job at CloudHive, Irvine, CA

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

RDY Advisors, LLC

Personal/Executive Assistant Job at RDY Advisors, LLC

 ...RDY Advisors, LLC, a boutique real estate investment and advisory firm based in Fort Lauderdale, is looking to hire an executive/personal assistant for approximately 5-7 hours per day, Monday to Friday. Tasks will vary day-to-day and span personal assistant tasks (booking... 

American Income Life

Online Call Agent Representative Job at American Income Life

 ...and make practical business decisions. What We Offer: ~ World-Class Training: Top-tier training to ensure your success. ~100% Remote Work: Work from anywhere with full flexibility. ~ Vested Renewals for Life: Long-term earnings that continue to grow. ~... 

Old Town Design Group

Construction Assistant Job at Old Town Design Group

OLD TOWN DESIGN GROUP CONSTRUCTION ASSISTANT JOB DESCRIPTION Old Town Design Group is seeking a Construction Assistant to join our team in Carmel, IN. We are a dynamic and growing custom home builder, known for developing outstanding locations with timeless home ...

The TJX Companies, Inc.

HVAC Technician Job at The TJX Companies, Inc.

 ...and make an impact. Come join our TJX familya Fortune 100 company and the worlds leading off-price retailer. Job Description: HVAC Technician The Opportunity: Contribute To The Growth Of Your Career. The HVAC Technician troubleshoots equipment,... 

Brightpath Associates LLC

Welding Engineer Job at Brightpath Associates LLC

 ...Job Description Welding Engineer provides technical leadership in support of manufacturing operations specifically in welding and brazing, assembly, and manufacturing environment. This position has a strong focus in welding and manufacturing engineering in day-to-day...