Snowflake Integration Engineer / Senior Engineer (Openflow, dbt & Native Snowflake)

This is a remote position.

Snowflake Integration Engineer / Architect - Openflow, dbt & Native Snowflake

Role Purpose

We are looking for a hands-on Snowflake engineer/architect capable of designing and implementing integration and transformation patterns that can replace appropriate Informatica PowerCenter workloads.

The role will evaluate when workloads should use Snowflake-native processing, dbt, Openflow or adjacent Snowflake capabilities rather than an external integration platform.

Key Responsibilities

• Assess Informatica workloads proposed for migration into the Snowflake ecosystem.
  
• Design Snowflake-centric ingestion, transformation and orchestration patterns.
  
• Implement representative migration POCs.
  
• Design patterns for:
  
• File-to-Snowflake ingestion
  
• Database-to-Snowflake ingestion
  
• Snowflake-to-file processing
  
• Database/data movement
  
• Batch processing
  
• Micro-batch processing
  
• ELT transformations
  
• Evaluate and implement Snowflake Openflow where appropriate.
  
• Develop transformation workloads using dbt.
  
• Develop Snowflake-native processing using relevant platform capabilities.
  
• Optimize workloads for performance, concurrency and consumption cost.
  
• Design error handling, restart/recovery, reconciliation and observability.
  
• Support approximately 15-minute micro-batch processing scenarios where appropriate.
  
• Evaluate when processing should remain within Snowflake instead of routing through MuleSoft or another middleware layer.
  
• Participate in architecture reviews and document reusable implementation patterns.
  
• Provide implementation effort and steady-state operating-cost inputs.
  

Required Skills

• Strong hands-on Snowflake engineering experience.
  
• Advanced SQL skills.
  
• Strong understanding of Snowflake architecture and performance characteristics.
  
• Experience with:
  
• Snowflake ingestion patterns
  
• Tasks
  
• Streams
  
• Stored procedures
  
• Snowpark or equivalent Snowflake-native development
  
• File formats and stages
  
• Data sharing
  
• Security and role design
  
• Strong hands-on dbt experience.
  
• Experience designing production-grade batch and micro-batch processing.
  
• Strong understanding of data orchestration, monitoring and recovery.
  
• Experience optimizing Snowflake consumption and warehouse sizing.
  

Strongly Preferred

• Hands-on experience with Snowflake Openflow.
  
• Experience migrating workloads from Informatica PowerCenter.
  
• Experience with CDC/data replication technologies.
  
• Python development experience.
  
• Experience with message/event-driven integration.
  
• Experience with Salesforce/Snowflake integration or Salesforce Data Cloud.
  
• Experience implementing CI/CD for Snowflake and dbt workloads.
  

Experience Level

7-10+ years in data engineering, with at least 4-5 years of significant Snowflake implementation experience.

Requirements

Required Skills

• Strong hands-on Snowflake engineering experience.
  
• Advanced SQL skills.
  
• Strong understanding of Snowflake architecture and performance characteristics.
  
• Experience with:
  
• Snowflake ingestion patterns
  
• Tasks
  
• Streams
  
• Stored procedures
  
• Snowpark or equivalent Snowflake-native development
  
• File formats and stages
  
• Data sharing
  
• Security and role design
  
• Strong hands-on dbt experience.
  
• Experience designing production-grade batch and micro-batch processing.
  
• Strong understanding of data orchestration, monitoring and recovery.
  
• Experience optimizing Snowflake consumption and warehouse sizing.
  

Strongly Preferred

• Hands-on experience with Snowflake Openflow.
  
• Experience migrating workloads from Informatica PowerCenter.
  
• Experience with CDC/data replication technologies.
  
• Python development experience.
  
• Experience with message/event-driven integration.
  
• Experience with Salesforce/Snowflake integration or Salesforce Data Cloud.
  
• Experience implementing CI/CD for Snowflake and dbt workloads.
  

Experience Level

7-10+ years in data engineering, with at least 4-5 years of significant Snowflake implementation experience.