Snowflake Data Engineer

About KPI Partners

KPI Partners is a 5 times Gartner recognized data, analytics, and AI consulting company. We are leaders in data engineering on Azure, AWS, Google, Snowflake and Databricks. Founded in 2006, KPI has over 400 consultants and has successfully delivered over 1,000 projects to our clients. We are looking for skilled professionals who want to work with the best team.

Title: Senior Snowflake Data Engineer

Location: 100% Remote

Key Skills: Snowflake, IICS, and DBT.

Summary

Direct connectivity into DEV Workstreams, this role designs and builds complex ELT pipelines and leads technical design and code review within the team.

Key Responsibilities:

• Designs and builds complex ELT pipelines across Stage, ODS, and Silver layers using IICS, Snowpipe, SnowSQL, DBT, and Airflow.
• Lead technical design discussions and drive code review standards within the team
• Connect directly into DEV Workstreams as an onshore-based resource, enabling close coordination with client-side teams
• Own pipeline reliability and data quality across the layers you build.

Must Haves:

• Strong hands-on experience with Snowflake (Snowpipe, SnowSQL)
• IICS (Informatica Intelligent Cloud Services) for data integration
• DBT for transformation and modeling
• Airflow for orchestration
• Demonstrated experience leading technical design and conducting code reviews
• Must be based onshore with ability to connect to DEV Workstreams& Customer Teams
• SQLDBM for data modeling
• Experience with Medallion architecture (Stage/ODS/Silver/Gold layers)
• Prior mentoring or team-lead experience on data engineering projects