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,