Note: The job is a remote job and is open to candidates in USA. EXL is seeking a hands-on Snowflake Data Engineer with strong expertise in Snowflake architecture and development. The ideal candidate will work on database management, performance tuning, and automation solutions, collaborating with teams to deliver scalable data solutions.
Responsibilities
- Develop and maintain Snowflake databases, schemas, tables, views, streams, tasks, and stored procedures
- Write and optimize complex SQL queries for performance and scalability
- Design and implement data ingestion and automation solutions using Snowpipe, Streams, Tasks, and scripting
- Manage Snowflake users, roles, permissions, and Role-Based Access Control (RBAC)
- Optimize performance using clustering, micro-partitioning, query profiling, and warehouse tuning
- Build integrations with cloud platforms, BI tools, APIs, and external applications
- Leverage Snowflake Cortex and other latest Snowflake features for AI-driven use cases
- Troubleshoot production issues and support platform monitoring and optimization
- Collaborate with data engineers, analysts, and business teams to deliver scalable solutions
Skills
- Strong knowledge of Snowflake Architecture and Data Cloud platform
- Expertise in Snowflake SQL, query tuning, and performance optimization
- Hands-on experience with Stored Procedures, UDFs, Streams, Tasks, Snowpipe, Dynamic Tables, and Snowpark
- Experience with Cortex AI features, Time Travel, Zero-Copy Cloning, Data Sharing, and Materialized Views
- Strong understanding of RBAC, security, user/role management, and data governance
- Experience with Python and Shell scripting for automation
- Knowledge of clustering, micro-partitioning, warehouse management, and cost optimization
- Experience integrating Snowflake with Power BI, Sigma, APIs, Azure/AWS, and other enterprise applications
- 2–5 years of IT experience with at least 2+ years of hands-on Snowflake development experience
- Strong communication and problem-solving skills
- SnowPro Certification is a plus
Company Overview
Company H1B Sponsorship