Snowflake Tech Lead: Data Platform & CI/CD Architect

Robotic Technologies Automation; Portland (OR); On-site; USD 95,000 - 136,000; Full time

Job summary

Robotic Technologies Automation in Portland, OR is seeking a Snowflake Tech Lead to own the design, development, and integration of our Kraken data platform. You will lead cross-functional teams to deliver scalable data solutions in a fast-paced environment.

The role focuses on refactoring legacy SQL and ETL into dbt models with SCD Type 1, tuning Snowflake performance, and building CI/CD pipelines. You will mentor engineers and collaborate with product and business stakeholders to ensure

Qualifications

• Lead design and development for Kraken data platform and integrations.
• Refactor legacy SQL views and ETL into dbt models with SCD Type 1 patterns.
• Optimize Snowflake performance via tuning, sizing, clustering, and incremental processing.
• Establish CI/CD pipelines for dbt projects using GitHub and Snowflake tools.

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

Tools

GitHub

Snowflake Cortex

CI/CD

Job description

Robotic Technologies Automation in Portland, OR is seeking a Snowflake Tech Lead to own the design, development, and integration of our Kraken data platform. You will lead cross-functional teams to deliver scalable data solutions in a fast-paced environment.

The role focuses on refactoring legacy SQL and ETL into dbt models with SCD Type 1, tuning Snowflake performance, and building CI/CD pipelines. You will mentor engineers and collaborate with product and business stakeholders to ensure