Snowflake Tech Lead

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Snowflake Tech Lead
Location: Portland, OR
Duration: 11 Months + Extension
Bill Rate: $84/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:
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 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.

Core Skills: Snowflake, dbt, SQL, Python, GitHub, Snowflake Cortex, CI/CD, Data Modeling, Enterprise Integrations, Cloud Architecture, Agile Delivery

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.