Snowflake Data Engineer

KPI Partners; United States; Remote; USD 100,000 - 150,000; Full time

Job summary

KPI Partners is seeking mid-to-senior Snowflake Data Engineers to design, build, and optimize data pipelines for enterprise clients with a focus on data profiling and load validation.

The role involves supporting pipeline development and testing, performing data profiling to understand source data structure and quality, and conducting load validation to ensure data completeness and accuracy. Basic transformation work and bug fixes are also part of the responsibilities.

Qualifications

• Solid understanding of Snowflake data platform concepts and SQL
• Experience with profiling data to identify structure, quality, and anomalies
• Familiarity with data reconciliation and validation processes
• Basic scripting ability (Python or similar) for validation utilities
• Prior internship/junior data engineering experience is a plus

Responsibilities

• Support pipeline development and testing tasks
• Perform data profiling to understand source data structure, quality, and anomalies
• Perform load validation and reconciliation counts to confirm data completeness/accuracy
• Assist with basic transformation logic and bug fixes

Skills

Snowflake proficiency

SQL proficiency

Data profiling

Data validation

Basic scripting

Tools

Snowflake

SQL

IICS

DBT

Airflow

Job description

Job Description

We're looking for mid-to-senior Snowflake Data Engineers to design, build, and optimize data pipelines for enterprise clients.", with a focus on data profiling and load validation.

What you'll do:

Support pipeline development and testing tasks

Perform data profiling to understand source data structure, quality, and anomalies

Perform load validation and reconciliation counts to confirm data completeness/accuracy

Assist with basic transformation logic and bug fixes

Mandatory Skills: Working knowledge of Snowflake and SQL

Solid SQL fundamentals: joins, aggregations, filtering, basic window functions

Attention to detail for data profiling and validation work

Nice to Have Skills: Exposure to IICS, DBT, or Airflow

Prior internship/junior experience in data engineering

Familiarity with data-reconciliation practices

Basic scripting experience (Python or similar) for validation utilities"

Preferred candidate profile