Skip to main content
Back to Jobs

Forward Deployed Data Engineer (Integration)

Build data bridges between Clickhouse and customer warehouses using Dagster and Airbyte

As a Forward Deployed Data Engineer at Hilbert's AI, you will architect data integration solutions that enable AI agents to access high-fidelity business views across environments. You will work with Clickhouse, Snowflake, BigQuery, Dagster, and Airbyte to build pipelines and implement Warehouse-Native logic. Your role includes building semantic translators for custom datasets and partnering with a Data Discovery Agent to automate integration ...

Why This Role?

Partner with a Data Discovery Agent to automate integration workflows and slash pipeline development time

Key Responsibilities

  • Build data pipelines using Dagster and Airbyte to ingest data into Clickhouse managed warehouse
  • Implement Warehouse-Native transformations directly in Snowflake or BigQuery using native SQL
  • Develop semantic translators to map custom customer data columns to Hilbert's canonical models
  • Partner with the Data Discovery Agent to analyze data, suggest mappings, and generate initial pipeline versions
  • Optimize queries in Clickhouse and write native Snowpark or BigQuery SQL for performance
  • Ensure Reasoning Consistency so AI produces identical insights regardless of data residency

Requirements

  • Proficiency in Clickhouse query optimization
  • Experience writing native Snowpark (Snowflake) or BigQuery SQL
  • Skills in Python for data orchestration scripting
  • Experience with Dagster and Airbyte for data orchestration
  • Understanding of data modeling and semantic layer design for AI systems
  • Ability to work with enterprise data warehouses like Snowflake and BigQuery

Required Skills

sqlpythondata engineeringClickhouseSnowflakeBigQueryDagsterAirbyte

Keywords

data integrationwarehouse-nativesemantic layerAI agentsForward DeployedDagster Airbyte
View Original Description from Ashby Job Boards

Original description from Ashby Job Boards

Hilbert is a scalable, data science-first growth engine that gives B2C teams predictive clarity into user behavior, revenue drivers, and the actions that drive sustainable growth. Fully agentic by design, Hilbert shrinks months-long decision cycles to minutes. From Fortune 10 enterprises to beloved brands like FreshDirect, Blank Street, and Levain Bakery, operators run their growth on Hilbert. THE MISSION: ARCHITECT THE GROUND TRUTH At Hilbert we shorten "months" to "minutes." We build the AI Growth Engine that Fortune 500 enterprises and iconic B2C brands use to navigate their revenue drivers in real-time. We are expanding our deployment model. Whether we are ingesting data into our high-performance Clickhouse managed warehouse or implementing Warehouse-Native logic directly within a customer’s own data warehouse solution like Snowflake or BigQuery, the goal is the same: providing our AI Agents with a perfect, high-fidelity view of the business. We need a Forward Deployed Data Engineer who can architect these bridges in any environment. THE HARD PROBLEM: ARCHITECTURAL HYBRIDITY & SEMANTIC CLARITY The challenge isn't just moving rows; it’s ensuring "Reasoning Consistency." You are responsible for making sure our AI produces the same high-quality insights regardless of where the data resides. OUR CURRENT HURDLES: - The Dual-Track Challenge: We are building a system that can either pipe data into our Clickhouse stack using Dagster and Airbyte, or execute "Zero-Extract" transformations natively in the customer's warehouse. You’ll need to master both worlds. - The AI Semantic Layer: For customers with custom datasets that don't fit our canonical models, you will build the "Translator." You’ll define the metadata and business logic so our agentic flows can "understand" custom columns without hallucination. - Agent-Assisted Integration: We are building a Data Discovery Agent to automate the "messy" part of your job. You will prompt and partner with this agent to analyze customer data, suggest mapping alternatives, and generate the first version of pipelines automatically, slashing integration time significantly. WHO YOU ARE (THE PROFILE) - The Pragmatic Polyglot: You are equally comfortable optimizing a Clickhouse query as you are writing native Snowpark (Snowflake) or BigQuery SQL and comfortable implementing data orchestration scripts using python.. - The Data Ontologist: You understand that an AI needs more than just a table; it needs context. You have the discipline to define the "meaning" behind the data. - The "Translator": You can earn technical trust with a customer's Data Architect in minutes, extracting the logic of custom tables and mapping them to Hilbert reasoning engine. - The "Pilot" Mindset: You are excited to use and improve AI agents that handle the heavy lifting of data discovery and pipeline scaffolding. WHAT YOU’LL OWN - Hybrid Integration: Own the technical lifecycle of new customers, choosing and implementing the best deployment path (Managed Clickhouse vs. Warehouse-Native). - Accelerated Onboarding: Use Hilbert internal Discovery Agent to create reports and suggest mappings, moving from raw data to a working v1 pipeline in record time. - AI Semantic Layer Construction: Architect the semantic definitions for custom enterprise data, ensuring our agentic conversation engine has the "Ground Truth" for every query. - Canonical Modeling: Transform diverse source data into Hilbert unified growth models to power our generic ML systems. - Enterprise Deployment: Act as the lead technical resource for high-stakes enterprise implementations, ensuring our stack is "packaged" and performant in their specific infra. BONUS POINTS - Deep experience with dbt for warehouse-native modeling. - Having worked with more than one state of the art data warehouse solutions and knowing the optimization strategies. - Experience with Semantic Layer frameworks (Cube, MetricQL, etc.). - Background in E-commerce/Retail (understanding Revenue Metrics, Order lifecycle, LTV, CAC, and Attribution etc.). - Having built an agentic workflow before. LOCATION OPEN TO CANDIDATES BASED IN TÜRKIYE AND ACROSS EUROPE   COMPENSATION Competitive salary + equity package, commensurate with experience. Performance-based bonuses tied to project milestones and customer impact. THE HIRING JOURNEY Short form → Intro Call → Technical working session → Team conversations → Offer Fast, human, no bureaucracy.

Salary Context

Similar Engineering roles on LokerDollar pay around $170k/yr (range $11.194k–999.999k/yr, n=491 active listings).

Hiring at Hilbert's AI

Hilbert's AI has 5 other active roles on LokerDollar and has been hiring here since Jul 5, 2026 — across Engineering, Marketing.

View all Hilbert's AI openings →
Track this application + get a follow-up reminder

Free account · no credit card · Log in

Pro $9/mo · unlimited applies + AI resume

Source
Ashby Job Boards
Job Type
full time
Location
Remote
Category
Seniority
mid
Posted
Jun 23, 2026

Share this job

Help a friend find their next remote role.

Frequently asked questions

Is Forward Deployed Data Engineer (Integration) at Hilbert's AI a remote job?
This role is based in Remote. See the listing for remote/onsite details.
What type of employment is Forward Deployed Data Engineer (Integration) at Hilbert's AI?
This is a full time position.
How do I apply?
Click the "Apply" button on this page to go to the official application at Hilbert's AI.

Explore related

Market data & reports

Salary & skill-demand research built from our own listings data.

From the blog

Track this application + get a follow-up reminder

Free account · no credit card · Log in

Pro $9/mo · unlimited applies + AI resume