Snowflake Technical Lead

Xoriant Corporation; Portland (OR); On-site; USD 120,000 - 170,000; Full time

Job summary

Xoriant Corporation in Portland, OR is seeking a Senior Data Engineer to lead design, development and integration of the Kraken platform and related data solutions.

You will refactor legacy SQL views and ETL into scalable dbt models, optimize Snowflake performance, establish CI/CD pipelines, drive architecture decisions, mentor teams, and collaborate with business, product and engineering stakeholders to ensure reliable, high-performing data solutions.

Qualifications

• Experience leading design and development of data platforms.
• Ability to refactor legacy SQL and ETL into scalable dbt models.

Responsibilities

• Lead design, development, and integration activities for the Kraken platform and associated data solutions.
• Refactor legacy SQL views and ETL processes into scalable, reusable dbt models implementing SCD Type 1 patterns.
• Optimize Snowflake performance through query tuning, warehouse sizing, clustering, and micro-batch incremental processing.
• Establish and manage CI/CD pipelines for dbt projects using GitHub, Snowflake Cortex Code, and Snowflake Tasks orchestration.
• Drive architecture decisions, code reviews, and best practices across data engineering and analytics teams.
• Collaborate with business, product, and engineering stakeholders to deliver reliable, high-performing solutions.
• Mentor development teams and ensure adherence to security, scalability, and operational excellence standards.

Skills

Snowflake

dbt

SQL

Python

GitHub

Snowflake Cortex

CI/CD

Data Modeling

Enterprise Integrations

Cloud Architecture

Agile Delivery

Job description

Job Requirements

Key Responsibilities & Experience:

• Lead design, development, and integration activities for the Kraken platform and associated data solutions.


• Refactor legacy SQL views and ETL processes into scalable, reusable dbt models implementing SCD Type 1 patterns.


• Optimize Snowflake performance through query tuning, warehouse sizing, clustering, and micro-batch incremental processing.


• Establish and manage CI/CD pipelines for dbt projects using GitHub, Snowflake Cortex Code, and Snowflake Tasks orchestration.


• Drive architecture decisions, code reviews, and best practices across data engineering and analytics teams.


• Collaborate with business, product, and engineering stakeholders to deliver reliable, high-performing solutions.


• Mentor development teams and ensure adherence to security, scalability, and operational excellence standards.

Work Experience

Core Skills:

Snowflake, dbt, SQL, Python, GitHub, Snowflake Cortex, CI/CD, Data Modeling, Enterprise Integrations, Cloud Architecture, Agile Delivery