Omm2916J

Omm IT Solutions; New York (NY); On-site; USD 180,000 - 260,000; Full time

Job summary

Omm IT Solutions seeks a Lead Snowflake Data Engineer to design, own, and deliver end-to-end data engineering solutions in modern cloud environments. This onsite role in New York focuses on building scalable pipelines using Snowflake and Cortex AI, with full lifecycle ownership from ingestion through modeling to consumption.

Responsibilities include end-to-end pipeline design, performance tuning, and governance, ensuring scalable solutions that balance cost and maintainability for enterprise

Qualifications

• 10+ years of experience in production-grade data platforms.

Responsibilities

• Design, own, and deliver end-to-end data engineering solutions in cloud environments.
• Build scalable, high-performance data pipelines using Snowflake and Cortex AI, from ingestion to consumption.
• Provide architectural guidance and defend decisions, ensuring scalability and cost efficiency.

Skills

Snowflake data modeling

Python

PySpark

Advanced SQL

End-to-end data pipelines

AWS cloud

Snowflake Cortex AI

React.js knowledge

Data governance

Tools

Snowflake Cortex AI integration

AWS

Job description

Omm IT Solutions | Permanent W-2 Employee / Corp2Corp Contractor

New York, United States | Posted on 07/06/2026

• Job Type Permanent W-2 Employee / Corp2Corp Contractor
• Compensation Negotiable
• State/Province New York
• City New York
• Country United States
• Work Authorization USC/GC/H1B/H4-EAD
• Job Opening ID Omm2916J

Job Description

PLEASE NOTE:

• It is a 100% Onsite position in New York, NY

JOB DESCRIPTION:

• We are seeking a Lead Snowflake Data Engineer to design, own, and deliver end-to-end data engineering solutions in modern cloud environments.
  
• This role focuses on building scalable, high-performance data pipelines using Snowflake and Cortex AI, with full lifecycle ownership—from ingestion and transformation to modelling, optimization, and consumption.

REQUIRED QUALIFICATIONS:

• 10+ years of experience, or equivalent ownership of production-grade data platforms
• Deep expertise in:
• Snowflake (data modeling, performance tuning, optimization)
• Python and PySpark
• Advanced SQL
• Proven ability to design and deliver end-to-end data pipelines (ingestion transformation modeling consumption) in cloud environments (AWS preferred)
• Required: Ownership of at least one production-grade Snowflake pipeline end-to-end
• Strong foundation in modern data warehousing:
• Dimensional modeling (star/snowflake schemas)
• Data marts and optimization strategies
• Experience with distributed data processing and large-scale datasets
• Hands on experience with Snowflake Cortex AI integration
• Working knowledge of React.js or similar frameworks
• Strong understanding of data governance, security, and compliance
• Ability to:
• Clearly explain and defend architectural decisions
  
• Design systems that perform reliably at scale
• Balance performance, cost, and maintainability

MUST HAVE:

• Candidates should be able to clearly explain and apply the following in real-world scenarios:
• Snowflake Performance & Scaling
• Warehouse scaling modes (auto-scale, multi-cluster) and when to use them
• Clustering keys and performance trade-offs
• Cost vs performance optimization strategies
• Snowflake Storage & Optimization
• Micro-partitioning and its impact on pruning and query performance
• End-to-End Pipeline Design
• Designing a complete ELT pipeline using Snowflake
• Deciding where transformations should occur (Snowflake vs external processing)
• Ensuring scalability, maintainability, and performance across the pipeline Engagement.
  

Education/Work Experience

10+ years of experience, or equivalent ownership of production-grade data platforms