Snowflake Integration Engineer / Senior Engineer (Openflow, dbt & Native Snowflake)
- Hiring from
- Probably Worldwide
- Work type
- Remote
- Posted
510,719 remote jobs, straight from company career pages
100% free · New jobs every hour
Show job descriptionHide job description
About Us
Job Description
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.