Senior Snowflake Integration Architect

Latent Bridge Pvt Ltd; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

LatentBridge is hiring a hands-on Snowflake engineer/architect for a remote role in the United States. You will design and implement integration and transformation patterns, evaluating Snowflake-native options over external platforms and delivering migration PoCs.

The role emphasizes performance, cost optimization, and observability across ELT workflows, with preference for Openflow experience and Informatica migration expertise.

Qualifications

• Strong hands-on Snowflake engineering experience.
• Advanced SQL skills.
• Strong understanding of Snowflake architecture and performance characteristics.
• Experience with tasks, streams, stored procedures, file formats and stages, data sharing, security and role design.
• Experience designing production-grade batch and micro-batch processing.

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 database/data movement, batch processing, micro-batch processing, ELT transformations.
• Evaluate and implement Snowflake Openflow where appropriate.
• Optimize workloads for performance, concurrency and consumption cost.
• Design error handling, restart/recovery, reconciliation and observability.
• Support 15-minute micro-batch processing scenarios where appropriate.
• Evaluate when processing should remain within Snowflake instead of routing through middleware.
• Participate in architecture reviews and document reusable implementation patterns.

Skills

Snowflake engineering

Advanced SQL

Snowflake architecture

Data orchestration

Monitoring

Recovery

Openflow

Batch processing

CDC replication

Tools

Snowflake Openflow

Job description

LatentBridge is hiring a hands-on Snowflake engineer/architect for a remote role in the United States. You will design and implement integration and transformation patterns, evaluating Snowflake-native options over external platforms and delivering migration PoCs.

The role emphasizes performance, cost optimization, and observability across ELT workflows, with preference for Openflow experience and Informatica migration expertise.