Snowflake Tech Lead: Data Platform & CI/CD Architect

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

Job summary

Quantum Technologies LLC in Portland, OR is seeking a Snowflake Tech Lead to guide design, development, and integration of the Kraken data platform. You will lead complex data solutions and help shape the architecture and standards for scalable analytics.

The role emphasizes refactoring legacy SQL and ETL into dbt models, optimizing Snowflake performance, and establishing CI/CD pipelines with GitHub and Snowflake Cortex.

Qualifications

• Lead design, development, and integration activities for the Kraken platform and 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.

Responsibilities

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

Skills

Snowflake

dbt

SQL

Python

GitHub

Snowflake Cortex

CI/CD

Data Modeling

Enterprise Integrations

Cloud Architecture

Agile Delivery

Tools

Snowflake Cortex

GitHub

dbt

Job description

Quantum Technologies LLC in Portland, OR is seeking a Snowflake Tech Lead to guide design, development, and integration of the Kraken data platform. You will lead complex data solutions and help shape the architecture and standards for scalable analytics.

The role emphasizes refactoring legacy SQL and ETL into dbt models, optimizing Snowflake performance, and establishing CI/CD pipelines with GitHub and Snowflake Cortex.