Remote Senior Snowflake Data Engineer & ELT Lead

KPI Partners; United States; On-site; USD 110,000 - 140,000; Full time

Job summary

KPI Partners is a 5-time Gartner-recognized data, analytics, and AI consulting firm offering remote-first opportunities. This role focuses on designing and building ELT pipelines, leading technical design, and ensuring code quality within DEV Workstreams.

You will work closely with client teams from an onshore location to deliver robust data solutions. As part of the team, you will mentor peers, guide architecture choices across Stage/ODS/Silver/Gold layers, and own data quality.

Qualifications

• Strong hands-on experience with Snowflake (Snowpipe, SnowSQL).
• DBT for transformation and modeling.
• Airflow for orchestration.
• Experience leading technical design and code reviews.
• Must be onshore and able to connect to DEV Workstreams & Customer Teams.
• Experience with Medallion architecture (Stage/ODS/Silver/Gold).
• Prior mentoring or team-lead experience on data engineering projects.

Responsibilities

• Designs and builds ELT pipelines across Stage, ODS, and Silver layers.
• Lead technical design discussions and code reviews.
• Connects to DEV Workstreams as an onshore resource with client teams.
• Owns pipeline reliability and data quality across the layers built.

Skills

Leadership experience

Mentoring

Onshore coordination

Tools

Snowflake

IICS

DBT

Airflow

Snowpipe

SnowSQL

Job description

KPI Partners is a 5-time Gartner-recognized data, analytics, and AI consulting firm offering remote-first opportunities. This role focuses on designing and building ELT pipelines, leading technical design, and ensuring code quality within DEV Workstreams.

You will work closely with client teams from an onshore location to deliver robust data solutions. As part of the team, you will mentor peers, guide architecture choices across Stage/ODS/Silver/Gold layers, and own data quality.