Snowflake Consultant

EXL; Jersey City (NJ); On-site; USD 100,000 - 140,000; Full time

Job summary

EXL is hiring an experienced Snowflake Consultant to lead a Center of Excellence across its Data Engineering organization. You will design scalable Snowflake solutions, set governance and development standards, and drive a cohesive CoE roadmap with enablement and optimization initiatives.

The role includes training teams, delivering cost dashboards, and mentoring engineers while staying current with Snowflake features and industry trends.

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.
• Experience driving CoE, technical standards, communities of practice, or enterprise enablement initiatives.

Responsibilities

• Design and implement scalable, secure Snowflake data solutions.
• Define and drive Snowflake architecture, standards, governance, and optimization.
• Develop a Snowflake CoE roadmap for governance, adoption, enablement, and capability development.
• Conduct monthly Snowflake training for the Data Engineering organization.

Skills

Snowflake architecture

Advanced SQL

Performance tuning

RBAC & governance

ELT/ETL architectures

Cloud platforms (AWS/Azure/GCP)

dbt & Airflow

FinOps practices

Education

10+ years in Data Engineering/Data Architecture

8+ years Snowflake experience

Snowflake certification preferred

Tools

Databricks

Snowpipe

Snowpark

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, and drive a Snowflake Center of Excellence (CoE) across the Data Engineering organization.

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

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

• 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

Base Compensation Range: 100,000 - 140,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.

For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits