Snowflake Data Engineer - Snowpark

The Brixton Group; Florham Park (NJ); Remote; USD 110,208 - 137,760; Full time

Job summary

A consulting firm is seeking a Senior Data Engineer with extensive experience in building and optimizing data pipelines using Snowpark and Snowflake. The role is 100% remote but requires candidates to reside in the Eastern or Central Time Zone. Successful candidates will have over 7 years of Data Engineering experience and hands-on Snowpark expertise. Key responsibilities include developing scalable ELT pipelines, managing ingestion workflows, and ensuring data quality. This is an exciting opportunity for someone looking to support pharma/life sciences client initiatives.

Qualifications

• 7+ years of experience as a Data Engineer.
• 3+ years hands-on Snowflake production experience.
• 2+ years production experience with Snowpark (Python).
• Experience implementing ingestion workflows using Snowpipe.

Responsibilities

• Develop scalable ELT pipelines in Snowflake.
• Build data transformation logic using Snowpark (Python).
• Implement and manage ingestion workflows using Snowpipe.
• Optimize Snowflake warehouse performance and query tuning.

Skills

Hands-on Snowpark (Python) experience

Strong SQL skills in Snowflake

Client-facing or consulting environment experience

Experience building ELT pipelines

Tools

Snowflake

Airflow

AWS

Azure

GCP

Job description

Duration

9+ months

Pay

$80-100/hr W2

Location

100% REMOTE – East Coast U.S. only (Must reside in Eastern or Central Time Zone)

We are seeking a Senior Data Engineer with hands‑on Snowpark (Python) experience to build and optimize scalable data pipelines within Snowflake. This role will support pharma/life sciences client initiatives and requires strong technical execution in a consulting environment.

Requirements

• 7+ years of experience as a Data Engineer
• 3+ years hands‑on Snowflake production experience
• 2+ years production experience with Snowpark (Python). Not just Python – specifically Snowpark in Snowflake.
• Experience implementing ingestion workflows using Snowpipe.
• Strong SQL skills in Snowflake.
• Experience building ELT pipelines directly in Snowflake (using Tasks, Streams, or Snowpipe)
• Experience in client‑facing or consulting environments.

Preferred

• Pharma / Life Sciences industry experience.
• Experience working with analytics or commercial datasets.
• Cloud platform experience (AWS, Azure, or GCP).
• Experience with orchestration tools (Airflow, etc.).

Responsibilities

• Develop scalable ELT pipelines in Snowflake.
• Build data transformation logic using Snowpark (Python).
• Implement and manage ingestion workflows using Snowpipe.
• Optimize Snowflake warehouse performance and query tuning.
• Ensure data quality and reliability.Collaborate directly with client stakeholders and project teams.