Snowflake Consultant

Job Description
We are looking for an experienced Snowflake Consultant with strong hands-on technical expertise, a client-centric approach, dynamic problem-solving ability, and a consultative mindset. The consultant will provide technical leadership, establish Snowflake best practices, drive a Snowflake Center of Excellence (CoE) across the Data Engineering organization, and lead the adoption of Snowflake Cortex AI capabilities to accelerate data and AI innovation

Base Compensation Range: 100,000 - 150,000

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process.

Responsibilities
Key Responsibilities

Design and implement scalable, secure, and high-performance Snowflake data solutions.
Define and drive Snowflake architecture, development standards, best practices, governance, and optimization.
Develop and present a comprehensive Snowflake CoE roadmap covering governance, adoption, enablement, optimization, and capability development.
Conduct monthly Snowflake training and knowledge-sharing sessions for the Data Engineering organization.
Create and maintain a monthly Snowflake cost dashboard covering consumption trends, warehouse utilization, cost drivers, and optimization opportunities
Design and implement AI-powered data solutions using Snowflake Cortex, including text analytics, summarization, classification, semantic search, and Generative AI use cases.
Drive performance and cost optimization through warehouse sizing, workload management, query optimization, clustering, and resource monitoring.
Establish standards for data modeling, ELT/ETL, security, RBAC, data governance, and environment management.
Provide technical mentoring and consulting to Data Engineering teams and review solutions against established standards.
Stay current with Snowflake features and industry trends and proactively recommend improvements.
Partner with clients, architects, engineering teams, and business stakeholders to understand requirements and translate them into effective Snowflake solutions.
Develop reusable frameworks, accelerators, reference architectures, and technical best practices.
Support technical branding and thought leadership through client presentations, technical showcases, demos, case studies, blogs, and knowledge-sharing forums.
Track CoE KPIs, Snowflake adoption, training effectiveness, optimization initiatives, and platform maturity.

Client & Consulting Expectations

Demonstrate a strong client-centric mindset, building trusted relationships and understanding client business and technical objectives.
Bring a consultative approach, proactively identifying opportunities, challenges, and areas where Snowflake can deliver additional business value.
Adapt quickly to changing client priorities and demonstrate a dynamic, solution-oriented approach to problem solving.
Communicate complex technical concepts effectively to both technical and non-technical stakeholders.
Lead technical discussions, workshops, assessments, and solutioning sessions with clients and internal leadership.
Challenge existing approaches constructively and recommend innovative, practical, and scalable solutions.
Represent the organization professionally in client-facing discussions and contribute to strengthening the company's Snowflake technical brand and market positioning.

Required Technical Skills

Strong hands-on expertise in Snowflake architecture and development.
Advanced SQL and strong data warehousing knowledge.
Expertise in Snowflake performance tuning and cost optimization.
Hands-on experience with Snowflake Cortex, Cortex Analyst, Cortex Search, and AI/GenAI use cases.
Strong knowledge of Virtual Warehouses, Resource Monitors, Clustering, Query Profiling, Time Travel, Streams, Tasks, Dynamic Tables, Snowpipe, and Snowpark.
Experience with Snowflake security, RBAC, governance, masking, and data sharing.
Experience with modern cloud data engineering and ELT/ETL architectures.
Experience with AWS, Azure, or GCP data platforms.
Exposure to ADF, Airflow, dbt, Databricks, or similar data engineering technologies.
Experience with Snowflake usage, cost monitoring, and FinOps practices.

Qualifications
Qualifications

10+ years of experience in Data Engineering, Data Architecture, or Cloud Data Platforms.
8+ years of strong hands-on Snowflake experience.
Snowflake certification preferred.
Excellent communication, presentation, stakeholder management, and mentoring skills.
Demonstrated experience driving CoE, technical standards, communities of practice, or enterprise enablement initiatives.
Strong client-facing, consultative, and solutioning experience.
P&C Insurance domain is preferred
Bachelor's in engineering or computer science