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

🔒 Confidential Employer
Posted 11 October 2026
LOCATION
Remote
TYPE
Full-time
LEVEL
Mid-Senior level
CATEGORY
Data & Analytics
This employer holds a UK Home Office sponsor license — sponsorship for this specific role is at the employer’s discretion

SKILLS

Snowflake SQL dbt Snowflake Openflow Data orchestration Batch processing Python CI/CD

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

Sign up free — access 45,000+ UK sponsor-licensed jobs