Snowflake Integration Engineer / Senior Engineer (Openflow, dbt & Native Snowflake)
SKILLS
FULL DESCRIPTION
Snowflake Integration Engineer / Senior Engineer (Openflow, dbt & Native Snowflake)
[Employer hidden — sign up to reveal] | Full time | Remote | Posted on 10/08/2026
About Us
At [Employer hidden — sign up to reveal], we make digital transformation work—without the noise. We help enterprises simplify the complex, using AI orchestration and intelligent automation to solve real operational challenges. Our focus is on the parts of the business that are often overlooked—compliance, audit, policy, and risk—where precision, scalability, and accountability matter most. Our products—Epic AI and IntellixCore—are built for this depth. In 2024, we were named one of the Deloitte UK Technology Fast 50, recognised for our growth and the tangible impact we deliver.
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.
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.
I'm interested