Snowflake Lead - New York, NY

Overview

On Site
$50 - $60
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Snowflake
Java
Spring Boot
Oracle
Snowpark
StreamSets
Snowflake ML
SageMaker

Job Details

We are looking for a Lead Consultant Snowflake to join our team. Please review the job description below, and let us know if you are interested and available.

If this opportunity matches your experience and career goals, we would love to discuss it more. Additionally, feel free to share your updated resume for consideration

Role: Snowflake Lead

Location: New York, NY (Hybrid 3 days onsite, flexibility on 2 days remote)

Duration: 12+ Months

Experience: 3-5 Years for Snowflake hand-on Experience

We are inviting applications for the role of Lead Consultant Snowflake We are looking for a Subject Matter Expert (SME) in Snowflake with hands-on experience in Snowpark, StreamSets, and modern data engineering practices. The ideal candidate will have a strong foundation in Snowflake-based architectures, complemented by knowledge of Java, Spring Boot, and Oracle. Experience in applying AI/ML models within a data warehouse environment is a strong plus.

Responsibilities

  • Lead the design and development of data pipelines and solutions using Snowflake, Snowpark, and StreamSets
  • Serve as the SME for Snowflake architecture, performance tuning, security, and data governance
  • Develop scalable, reusable data transformation logic using Snowpark (Scala/Java/Python) and integrate with external systems
  • Collaborate with application developers to expose and consume REST APIs for data services using Java / Spring Boot
  • Optimize data models and SQL queries within Snowflake for performance and cost
  • Integrate and manage data movement from Oracle and other data sources into Snowflake
  • Work with DevOps and platform teams to enable CI/CD for data pipeline deployment
  • If applicable, design and implement AI/ML models within Snowflake or connect external ML models into the data platform
  • Snowflake: In-depth experience with Snowflake features, architecture, performance tuning, roles & access controls
  • Snowpark: Hands-on development experience using Snowpark (Python/Java/Scala)
  • StreamSets: Expertise in designing, implementing, and managing StreamSets pipelines
  • Core Java: Ability to build and maintain backend components using Java
  • Spring Boot: Experience in building RESTful services/APIs using Spring Boot
  • Oracle: Good understanding of Oracle data structures, SQL, and PL/SQL for data extraction and transformation

Skillset

  • Experience with AI/ML workflows on data warehouse platforms (Snowflake ML, integrations with SageMaker, DataRobot, etc.)
  • Familiarity with modern CI/CD tools (Git, Jenkins, Docker, Terraform)
  • Experience in Agile/Scrum environments

Qualifications we seek in you!

Minimum qualifications

  • Computer Science

Preferred qualifications

  • BE/ B tech. / MCA / MSc. / BSc.

Thank you!

Best Regards,

Sumit Talekar

Associate Manager Talent Acquisition

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.