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

• 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.

Lightricks is an AI-first company creating next-generation content creation technology for businesses, enterprises, and studios with a mission to bridge the gap between imagination and creation. At our core is LTX-2, an open-source generative video model, built to deliver expressive, high-fidelity video at unmatched speed. It powers both our own products and a growing ecosystem of partners through API integration.

The company is also known globally for pioneering consumer creativity through products like Facetune, one of the world’s most recognized creative brands, which helped introduce AI-powered visual expression to hundreds of millions of users worldwide. We combine deep research, user-first design, and end-to-end execution from concept to final render, to bring the future of expression to all.

The team & role

We’re seeking a passionate, visionary Creative Director to own and build the visual foundation of LTX end-to-end. This role is about defining a clear, scalable visual system for the company and ensuring it is consistently expressed across product, brand, research, and storytelling.

This is a highly cross-functional role: you’ll work closely with product, research, engineering, marketing, and leadership to align the entire organization around a shared visual language. A core part of the role is shaping and evolving the visual identity of the LTX-2 model itself — how it looks, feels, and is visually represented to developers, partners, and the broader ecosystem.

The ideal candidate combines deep graphic design expertise with strong systems thinking and technical curiosity — someone who can translate complex AI technology into a cohesive, recognizable, and inspiring visual identity that scales with the company.

What you will be doing

• Define, build, and maintain clear visual guidelines for LTX — including brand principles, visual systems, and design standards that can scale across teams, products, and use cases.
• Own the visual identity of the LTX-2 model, shaping how the model is visually expressed across documentation, demos, product surfaces, partnerships, and storytelling.
• Lead the creative direction and visual language across product, brand, research communication, and marketing, ensuring consistency and clarity across all touchpoints.
• Work in close partnership with product, research, engineering, and marketing teams to embed the visual system deeply into how the company operates — not as an external layer, but as a shared language.
• Translate complex technical concepts and AI capabilities into clear, expressive visual narratives that make the technology accessible and inspiring.
• Stay hands-on: design, prototype, and iterate on key visuals, setting a high bar for craft and execution.
• Build, mentor, and inspire a multidisciplinary creative team, while also empowering non-design teams through strong guidelines and frameworks.
• Collaborate with company leadership to ensure the visual identity supports long-term product strategy, positioning, and brand growth.

Your skills and experience

• You are an experienced creative leader with 8+ years of hands-on design experience, shaping visual identity and creative direction across digital products, platforms, or technology-driven brands.
• You think systemically — with proven experience building visual guidelines, brand systems, and scalable design frameworks that enable consistency across large, cross-functional organizations.
• You bring deep hands-on design expertise and strong creative judgment — you are first and foremost a designer who leads through craft, not just a creative manager.
• You are comfortable working across the entire company, influencing product, research, engineering, marketing, and leadership through clear, confident visual direction.
• You have experience owning and managing wide design operations — including processes, workflows, standards, and collaboration models that allow design to scale without losing quality.
• You are technically fluent and creatively curious, with a strong interest in the intersection of design, AI, and emerging technologies. You can translate complex technical capabilities into expressive and coherent visual systems.
• You understand how generative AI and creative technology are reshaping visual design and have worked hands-on with modern design, production, and AI-powered tools.
• You are a collaborative partner and clear communicator, able to align diverse stakeholders around a shared visual language and creative vision.
• You lead by doing — setting a high bar for visual excellence and inspiring others through example.
• Proficient in Figma, Adobe Creative Suite, and modern AI and 3D design tools.

Important note:

This role requires deep, hands-on design experience and proven ownership of wide design operations. Candidates whose background is primarily in marketing execution or campaign management, without a strong foundation in visual design systems, craft, and scalable design operations, will not be a good fit.

We are looking for an experienced designer who leads through design, builds visual frameworks, establishes and runs effective design operations, and sets a consistently high creative bar across the organization.

Why Lightricks

• Join a company where creativity is the core of our mission - not a department. At Lightricks, the role of Creative Director carries unique weight and meaning, shaping how innovation itself is expressed.
• Shape the creative identity of one of the most ambitious AI companies redefining how visual creation comes to life.
• Collaborate with visionary minds across design, research, and technology - working at the intersection of creativity and innovation.
• Contribute to LTX-2 and future-generation creative models that expand the boundaries of what’s visually and technically possible.

Benefits

• Expected salary range is 225,000-270,000$ annually. Actual compensation will vary based on a candidate’s qualifications, experience, and other relevant factors.
• Stock options.
• Health/dental/vision with majority of premiums paid by the company.
• 401k with company match (up to 4%).
• $3,000 per year provided for lunch.
• $1,000 Yearly Learning, Development, and Wellness budget.
• Work from home stipend.
• 21 Days of PTO.
• Birthdays off! Take a free day off during your birthday month to celebrate.
• Talented teammates and a strong work culture supporting a healthy work-life balance.

#LI-GS1