Snowflake Cortex Data Engineer/Snowflake Developer

Title: Snowflake Cortex Data Engineer/Snowflake Developer Experience: 5 + Years genuine experience without Internship. Location: Jersey City, NJ (3-4 days Hybrid) Industry: Insurance / Financial Services Primary Focus: Snowflake Architecture, Development, SQL, Stored Procedures, Automation, Cortex AI, Security (RBAC), Performance Tuning, Clustering/Micro-Partitioning, and Enterprise Integrations. Position Overview We are looking for a hands-on Snowflake Developer with strong expertise in Snowflake architecture, development, performance tuning, automation, and security. The ideal candidate should have a deep understanding of Snowflake's core capabilities and be comfortable working across development, administration, and platform optimization activities. Key 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. Required 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. Qualifications • Minimum 5 years of IT experience with at least 2+ years of hands-on Snowflake development experience. • SnowPro Certification is a plus. • Strong communication and problem-solving skills.