Snowflake Tech Lead - Data Platform & Architecture

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

Job summary

Ethereum Technologies seeks a Snowflake Tech Lead in Portland to drive design, develop, and optimize data solutions on the Snowflake platform. The role focuses on refactoring legacy SQL and ETL into scalable dbt models, tuning performance, and building robust CI/CD pipelines.

The candidate will guide architecture decisions, conduct code reviews, and mentor teams while collaborating with stakeholders to ensure secure, scalable, and high-performing data systems.

Qualifications

• Lead the design, development, and integration activities for the Kraken platform and related data solutions.
• Refactor legacy SQL views and ETL into scalable dbt models with SCD Type 1.
• Optimize Snowflake performance via query tuning, sizing, clustering, and incremental processing.
• Establish CI/CD pipelines for dbt projects using GitHub and Snowflake Cortex Code.

Responsibilities

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

dbt

GitHub

Snowflake Cortex

Job description

Ethereum Technologies seeks a Snowflake Tech Lead in Portland to drive design, develop, and optimize data solutions on the Snowflake platform. The role focuses on refactoring legacy SQL and ETL into scalable dbt models, tuning performance, and building robust CI/CD pipelines.

The candidate will guide architecture decisions, conduct code reviews, and mentor teams while collaborating with stakeholders to ensure secure, scalable, and high-performing data systems.