We're built as a lean, data-driven organization that relies on a common understating of objectives and goals to provide teams with autonomy and ownership. We don't like spending our days in meetings and we skip committees altogether. At Lemonade, there's no such thing as going over someone's head. We have zero tolerance for bureaucracy, office politics, and lean-back personalities.

As a Public Benefit Corporation and a certified B-Corp, we deliver environmental and social impact using our products and tech. Through our Giveback program, we partner with organizations such as the ACLU, New Story, The Humane Society, Malala Fund, American Red Cross, 360.org, charity: water, and dozens of others, and have donated millions towards reforestation, education, animal rights, LGBTQ+ causes, access to water, and more.

Awarded 'best workplace'

Best Workplace and Best-Led Company by Inc. Magazine

"World Changing" by Fast Company

Recognized as a World Changing Idea by Fast Company Magazine

Ranked #1 Home insurance in America

Won best renters and homeowners insurance in America by US News, and others

Best Pet Insurance in America

Rated "Best Overall Pet Insurance" by Better Homes & Gardens

Rated 4.9 on the App Store

Among the highest rated apps of all time

What you're applying for

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 or similar tools, an advantage
• 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

Things to know...

Lemonade is an equal opportunity employer committed to diversity and inclusivity. We never discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. If you require reasonable accommodations due to religious beliefs, pregnancy, or disabilities, let us know at any time.