Snowflake Tech Lead

PortlandJobs.net, LLC; Portland (OR); On-site; USD 140,000 - 200,000; Full time

Job summary

PortlandJobs.net, LLC is seeking a Snowflake Tech Lead to steer design, development, and integration for the Kraken platform and related data solutions. The role emphasizes refactoring legacy SQL views and ETL into scalable dbt models, implementing SCD Type 1 patterns, and optimizing Snowflake performance through careful tuning and resource sizing.

You will establish and manage CI/CD pipelines for dbt projects, utilizing GitHub and Snowflake Cortex Code to streamline deployments and ensure

Qualifications

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

Responsibilities

• Lead design and implementation of data pipelines for Kraken platform.
• Refactor legacy SQL views and ETL to dbt models with SCD Type 1.
• Tune Snowflake queries and optimize warehouse resources for performance.
• Set up and maintain CI/CD workflows for dbt projects.

Tools

Snowflake

dbt

GitHub

CI/CD

Job description

Description:

Snowflake Tech Lead 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 Snow

Description: Snowflake Tech Lead Key Responsibilities & Experience: Lead design, development, and integration ... SCD Type 1 patterns. Optimize Snowflake performance through query tuning, warehouse ... dbt projects using GitHub, Snowflake Cortex Code, and Snow

Description: Snowflake Tech Lead Key Responsibilities & Experience: Lead design, development, and integration ... SCD Type 1 patterns. Optimize Snowflake performance through query tuning, warehouse ... dbt projects using GitHub, Snowflake Cortex Code, and Snow

Description: Snowflake Tech Lead Key Responsibilities & Experience: Lead design, development, and integration ... SCD Type 1 patterns. Optimize Snowflake performance through query tuning, warehouse ... dbt projects using GitHub, Snowflake Cortex Code, and Snow

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