Job description

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 Data Engineer - (Customer 360)

Location:

Scottsdale, AZ (Hybrid) / 100% Remote – MST Time Zone

Job Type:

Contract – 3 Months

Key Skills:

Snowflake, IICS, and DBT.

Note:

May require limited travel as per the project needs (Expenses Paid)

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