Snowflake Data Engineer - Snowpark

Duration

9+ months

$80-100/hr W2

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.

• 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.

• 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.).

• 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.