Data Warehouse Tech Lead

Tel Aviv, Israel | Tech Development | Full-time
Not your everyday company

Lemonade completely reinvented how insurance works. As a customer-centric tech company, we created an insurance experience that is smart, instant, and delightful.

At Lemonade, you’ll be working with a group of like-minded makers, who get a kick out of moving fast and delivering great products. We surround ourselves with some of the smartest, most motivated, creative people who are filled with positive energy and good karma.

Unlike most publicly traded companies, we’re nimble and efficient. We take pride in the fact that we still think and operate like a startup. We don’t care much about titles and hierarchy and instead focus on innovation, bold moves, and challenging the status quo.

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 a Data Warehouse Tech Lead to drive the technical vision and execution of our data infrastructure that powers decision-making across all of Lemonade.

You'll lead both the technology and the business coordination for our data warehouse — architecting scalable solutions while working closely with stakeholders and data providers to ensure our platform serves the entire organization's needs. This role combines deep technical leadership with strategic business partnership as we build Lemonade's next-generation data stack.

In this role you'll

Lead technical architecture — design and develop scalable data warehouse solutions that support multiple products and serve the entire organization's analytics needs

Manage the technical roadmap — set strategy and guide execution for the Data Warehouse team, ensuring our platform evolves with business requirements

Drive business process coordination — translate business needs into technical requirements while establishing clear data contracts with R&D, Analytics, and external data providers

Establish and implement best practices — set technical standards for data warehouse architecture, performance tuning, and development methodologies that guide the entire team's approach to building scalable data solutions

Create and maintain sustainable data pipelines — build resilient systems capable of handling unstructured data and managing an evolving schema registry across diverse data sources

Implement advanced data modeling — create robust data structures using methodologies like dimensional modeling, and optimize ETL/ELT processes for our semantic layer

Establish data quality standards — build processes for schema evaluation, anomaly detection, and monitoring data completeness and freshness across all sources

Lead cross-team collaboration — work directly with Data Engineers, ML Platform Engineers, Data Scientists, Analysts, and Product Managers to align technical solutions with business goals

What you'll need

7+ years as a BI Engineer or Data Engineer, with 2+ in a technical leadership or architect role

Proven experience managing complex data warehouses that serve multiple products and entire organizations

Strong expertise in data modeling, ELT development, and data warehouse methodologies

Advanced SQL skills and hands-on experience with Snowflake or similar cloud-native data warehouse platforms

Extensive experience with dbt for data transformation and modeling

Python and software development experience (a strong plus)

Excellent communication skills — you can mentor technical team members and explain complex data concepts to business stakeholders

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

Enthusiasm about learning and adapting to the exciting world of AI – a commitment to exploring this field is a fundamental part of our culture

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.