Lead Snowflake Data Engineer

Elios AI; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Elios AI is seeking a senior Lead Data Engineer for a fully onsite contract engagement in New York, NY. This role requires ownership of production-grade data platforms using Snowflake, covering ingestion, transformation, and delivery.

The ideal candidate will have deep expertise in query tuning, clustering, and data governance, along with experience in AWS and Python. This senior-level position entails significant technical leadership and collaboration with various stakeholders.

Qualifications

• Deep hands-on expertise with Snowflake, specifically with query tuning and clustering strategies.
• Experience in building end-to-end data platforms with Snowflake in a cloud environment.
• Ability to explain and defend architecture decisions in client-facing scenarios.

Responsibilities

• Architect scalable ELT pipelines for large-scale cloud data workloads.
• Design and optimize dimensional models and data marts.
• Mentor engineering teams and take active coding responsibilities.

Skills

Snowflake

Python

PySpark

AWS

Data governance

Data security

Query optimization

Client-facing delivery

Dimensional modeling

React

Job description

Snowflake Cortex AI PySpark ELT Dimensional modeling Query optimization Clustering keys Micro-partitioning Warehouse scaling Data marts Distributed processing Data governance Data security AWS Client-facing delivery Python SQL React

Job Description

We are seeking a senior Lead Data Engineer for a fully onsite contract engagement in New York, NY with a global consulting firm serving large financial services and enterprise clients. This role owns the end-to-end design, development, and delivery of production-grade data platforms in Snowflake, from ingestion through transformation, modeling, and consumption. The engineer will architect scalable ELT pipelines, design dimensional models and data marts, build backend data services in Python and PySpark, and optimize performance across large-scale cloud data workloads. The role requires deep hands-on expertise with Snowflake, including query tuning, clustering strategy, warehouse scaling, micro-partitioning, and cost-performance tradeoff decisions, along with hands-on experience integrating Snowflake Cortex AI for advanced analytics and intelligent data products. This person will also enforce data governance, security, and compliance standards, partner with analytics, business, and engineering stakeholders, and operate in a client-facing capacity where they must clearly explain and defend architecture decisions. AWS experience is preferred, and working knowledge of React is helpful for collaboration on user-facing data products. This is a senior technical leadership role with meaningful architectural ownership, active coding responsibility, and mentorship of engineering teams.