We’re looking for an experienced Data Engineer to join our DataWarehouse team in TLV.

In this role, y...">

Back to Jobs

Data Engineer

Remote, USA Full-time Posted 2025-07-27

We’re looking for an experienced Data Engineer to join our DataWarehouse team in TLV.

In this role, you will play a pivotal role in the Data Platform organization, leading the design, development, and maintenance of our data warehouse. In your day-to-day, you’ll work on data models and Backend BI solutions that empower stakeholders across the company and contribute to informed decision-making processes all while leveraging your extensive experience in business intelligence.

This is an excellent opportunity to be part of establishing Lemonade’s state-of-the-art data stack, implementing cutting-edge technologies in a cloud environment.

In this role you’ll
  • Lead the design and development of scalable and efficient data warehouse and BI solutions that align with organizational goals and requirements

  • Utilize advanced data modeling techniques to create robust data structures supporting reporting and analytics needs

  • Implement ETL/ELT processes to assist in the extraction, transformation, and loading of data from various sources into the semantic layer

  • Develop processes to enforce schema evaluation, cover anomaly detection, and monitor data completeness and freshness

  • Identify and address performance bottlenecks within our data warehouse, optimize queries and processes, and enhance data retrieval efficiency

  • Implement best practices for data warehouse and database performance tuning

  • Conduct thorough testing of data applications and implement robust validation processes

  • Collaborate with Data Infra Engineers, Developers, ML Platform Engineers, Data Scientists, Analysts, and Product Managers

What you’ll need
  • 3+ years of experience as a BI Engineer or Data Engineer

  • Proficiency in data modeling, ELT development, and DWH methodologies

  • SQL expertise and experience working with Snowflake or similar technologies

  • Prior experience working with DBT

  • Experience with Python and software development, an advantage

  • Excellent communication and collaboration skills

  • Ability to work in an office environment a minimum of 3 days a week

Apply to this Job

Similar Jobs