Snowflake Data Engineer - Pipelines, Profiling & Validation

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

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.