Tel Aviv, Israel
Open 5 months, first seen by us 160 days agoEmployment type in the employer’s posting: FullTimeFrom the employer’s posting
Design and develop scalable data warehouse solutions for multiple products
Set the technical roadmap and guide the Data Warehouse team's execution
Establish data contracts with R&D, Analytics, and external data providers
Build resilient pipelines for unstructured data and an evolving schema registry
Set data quality checks for schema changes, anomalies, completeness and freshness
design and develop scalable data warehouse solutions that support multiple products
set strategy and guide execution for the Data Warehouse team
establishing clear data contracts with R&D, Analytics, and external data providers
build resilient systems capable of handling unstructured data and managing an evolving schema registry across diverse data sources
build processes for schema evaluation, anomaly detection, and monitoring data completeness and freshness across all sources
7+ years as a BI Engineer or Data Engineer, with 2+ in a technical leadership or architect role
Python and software development experience (a strong plus)
Proven experience managing complex data warehouses that serve multiple products and entire organizations
Excellent communication skills — you can mentor technical team members and explain complex data concepts to business stakeholders
Strong expertise in data modeling, ELT development, and data warehouse methodologies
Open 5 monthsWe first saw this posting 160 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 160
Up longer than most. Similar jobs usually come down between day 7 and day 55.
Well past Lemonade’s usual: its jobs come down by about day 13.
From 8,580 similar postings that came down, and 5 of Lemonade’s. Coming down is not always a hire.
4 open jobs
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- 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
- 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
- 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)
Complete your application on jobs.ashbyhq.com. The employer’s form will show what is required.
Already applied? Track this application
New Data Leadership postings at the employers we follow are about the same over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Leadership, by the work the posting describes.
Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.
Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.
Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.
The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.
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.
We believe three things matter for every role at Lemonade: drive to push through challenges, efficiency that keeps standards high while moving fast, and adaptability that lets you pivot with data and AI insights. These aren't buzzwords, they're how we actually work.
Our AI-first approach isn't just a tagline either. We're building the future of insurance with AI at the center, and we need people who are genuinely excited to learn and grow alongside these tools.
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
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
Ready to work in an office environment most days of the 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
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Tel Aviv, Israel
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.