Job Opportunities API

What We Do: Triple Whale is the AI operating system built for modern ecommmerce. We help you see what's actually working in your business, what's not, and what to do next. Then we take action for you — pausing the underperforming ad, generating the next batch of creative, flagging the inventory risk before it bites. We pull every signal in your business into one place, and put it on the most trusted measurement foundation in the industry. And on top of that, we give you the most actionable AI in commerce — Moby 2 — letting you tap any LLM you want, grounded in the full context of your business. Moby 2 doesn't just surface insights, it executes decisions for you, with automations that make the rest of your stack smarter. The result: more than 60,000 brands like Pressed Juicery, OUAI, and True Classic turn mountains of complex data into actions that actually grow profit, at a speed and scale that is not humanly possible. Why Triple Whale Needs You: We're looking for a  Data Engineer with 4+ year experience to join our Data Engineering team and help us build and scale our production-grade data platform. You'll work on high-performance systems built on self-hosted ClickHouse, optimize complex data pipelines, and collaborate closely with Product, Analytics, and Infrastructure teams to deliver reliable, fast, and scalable data solutions. This is a hands-on technical role where you'll have a significant impact on how we ingest, model, store, and serve data that powers our analytics and AI-driven products. You’ll play a key role in shaping the direction of our data platform and have meaningful ownership over critical components of our architecture. What You'll Do: Data Modeling & Architecture Design and evolve data models that reflect business logic and support analytical use cases Collaborate with the BI and Analytics teams to understand data requirements and translate them into efficient schemas Performance Optimization Optimize ClickHouse schemas, partitioning strategies, indexing, and compression Profile and tune slow queries to improve performance and reduce costs Implement systems that ensure data quality, consistency, and operational efficiency (e.g., deduplication, validation, anomaly detection) Monitor pipeline health, data freshness, and query performance with appropriate alerting mechanisms SQL Compiler Development Develop and maintain the SQL Compiler layer that translates high-level queries into optimized ClickHouse execution plansImplement query optimization and rewriting strategies to improve performanceDebug and resolve compiler issues to ensure accurate and efficient query translation Data Pipeline Development & Collaboration Review and advise the Integration team on pipeline architecture, performance, and best practices. Provide guidance on data modeling, schema design, and optimization for new data sources. Troubleshoot and maintain existing pipelines when issues arise or optimization is needed Ensure data freshness, reliability, and quality across all ingestion pipelines. Collaboration & Support Work closely with the Integration team to ensure smooth data ingestion from new sources. Partner with Infrastructure to support high availability and disaster recovery Support other teams across the company in accessing and using data effectively. What You'll Bring: Required Excellent communication and collaboration skills English at a high level, written and spoken required Ability to work from our Jerusalem office (located in the Central Bus Station next to the train) 2 times a week (Monday & Wednesday) is required Strong attention to detail, ownership mentality, and ability to work independently Quick learner who can dive into new codebases, technologies, and systems independently Hands-on mentality - not afraid to roll up your sleeves, dig into unfamiliar code, and work across the