Snowflake Consultant

EXL•Jersey City, NJ

About The Position

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.

Requirements

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.
10+ years of experience in Data Engineering, Data Architecture, or Cloud Data Platforms.
8+ years of strong hands-on Snowflake experience.
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.
Bachelor's in engineering or computer science

Nice To Haves

Snowflake certification preferred.
P&C Insurance domain is preferred

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.
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.