Snowflake Tech Lead - Data Platform & CI/CD Champion

Valiant Technologies LLC; Portland (OR); Presencial; USD 95 000 - 136 000; Tempo integral

Resumo da oferta

Valiant Technologies LLC in Portland, OR is seeking a Snowflake Tech Lead to guide design, development, and integration of the Kraken platform and data solutions.

You will refactor legacy SQL views into scalable dbt models with SCD Type 1, optimize Snowflake performance, and establish CI/CD pipelines using GitHub and Snowflake Cortex. You’ll drive architecture decisions and mentor teams, ensuring security and reliability.

Qualificações

• Lead design, development and integration of the Kraken platform and 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 micro-batch processing.
• Establish CI/CD pipelines for dbt projects using GitHub and Snowflake Cortex Code.
• Drive architecture decisions and code quality across data teams.
• Collaborate with business, product and engineering stakeholders to deliver reliable, high-performing solutions.
• Mentor development teams and uphold security, scalability and operational excellence.

Responsabilidades

• 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.

Conhecimentos

Snowflake

dbt

SQL

Python

GitHub

Snowflake Cortex

CI/CD

Data Modeling

Enterprise Integrations

Cloud Architecture

Agile Delivery

Ferramentas

GitHub

Snowflake Cortex

CI/CD

dbt

Descrição da oferta de emprego

Valiant Technologies LLC in Portland, OR is seeking a Snowflake Tech Lead to guide design, development, and integration of the Kraken platform and data solutions.

You will refactor legacy SQL views into scalable dbt models with SCD Type 1, optimize Snowflake performance, and establish CI/CD pipelines using GitHub and Snowflake Cortex. You’ll drive architecture decisions and mentor teams, ensuring security and reliability.