Data Engineer

What We Do:

Triple Whale is the source of truth for eCommerce brands. Our platform centralises the entire analytics stack- from profit tracking and customer insights to marketing attribution and creative intelligence. We empower brands with the visibility they need to make smarter decisions, scale faster, and optimize every dollar spent.

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 stack (including backend when needed)

• 4+ years of experience as a Data Engineer

• Strong problem-solving skills for complex data challenges at scale - ability to debug performance issues, data inconsistencies, and system bottlenecks in high-volume environments

• Experience with data modeling and schema design for analytical workloads

• Strong proficiency in SQL and experience with complex analytical queries

• Hands-on experience building and maintaining data pipelines (ETL/ELT)

• Ability to troubleshoot and optimize systems handling large data volumes (millions+ rows, complex queries, high throughput)

• Knowledge of query optimization techniques and execution planning

• Familiarity with columnar databases (ClickHouse, BigQuery, Redshift, Snowflake, or similar). Columnar DB experience is a big plus.

Nice to Have

• Experience with ClickHouse specifically

• Experience with real-time or streaming data pipelines

• Familiarity with SQL compilers or query engines

• Background in data quality frameworks and observability tools

• Experience with infrastructure as code (Terraform, Ansible, Pulumi ,etc.)

• Contributions to open-source data projects

• Experience with data orchestration tools (Airflow, Dagster, Prefect, etc.)

• Experience with any scripting language for data processing

• Understanding of distributed systems and data architecture concepts at scale

Plus

• Experience working in e-commerce, analytics, or BI platforms

Our Values

•
We Are Customer Obsessed: From our mission to every detailed project, everything we do is designed to create a positive impact for our customers.

•
We Move (Very!) Quickly: The speed at which we work, iterate, and deliver value is our most competitive advantage.

•
We Are Trustworthy: Candor, directness, and honest communication helps us learn, grow and improve so we can win together.

•
We Are Curious: We extend beyond our comfort zone and ask questions that guide us towards new, creative, and bold paths.

•
We Act Like A Mensch: We act with honor, integrity and empathy, and have deep respect for our customers and each other.

What We Offer

• The opportunity to shape and own core systems that power the entire organization.

• A high-impact role with autonomy and influence across multiple teams.

• A collaborative, fast-paced, and innovative environment.

• Competitive compensation and hybrid flexibility based in Jerusalem, with at least 2 days per week in-office required. Our office is conveniently located in Jerusalem's Central Bus Station (across the street from the train station)

Join Us In Making Waves:

If you’re looking for more than just a job and want to be part of a movement reshaping the future of Ecommerce, Triple Whale is the place for you. We’re on the lookout for driven, curious, and creative individuals ready to thrive in a fast-paced environment.

Triple Whale is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.