Data Warehouse Tech Lead
- Level
- Lead
Not stated in the posting: salary, work type, visa.
Open. First seen 2 October 2026.
About the role
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.
lemonade's standard text
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.
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
- 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
What this role asks for
Standard for data engineering roles
Data Warehousing · ETL · Python · SQL · Snowflake · dbt
Common in data engineering postings at any company.
84% of this description is written for the role. The rest is lemonade's standard text, folded away below.
Compared with lemonade's other open jobs.
The team: Engineering HIRES STEADILY
This role is one of 10 open in Engineering. 3 were posted in the last 30 days and the oldest in February: a team that hires all year rather than one being built.
WHAT THE TEAM WORKS WITH, ACROSS ITS POSTINGS
Python (7 of 10), Machine Learning (5 of 10), TypeScript (5 of 10), AWS (4 of 10), Kubernetes (4 of 10), LLM (4 of 10), Microservices (4 of 10)
OTHER ROLES ON THIS TEAM
- Automation Engineer, Billing Platform posted Nov 18
- Senior Backend Engineer, Pricing Platform posted Nov 5
- Senior Backend Engineer, Growth Platform posted Nov 3
- Sr. Data Scientist posted Sep 24
- Backend Engineer - ML Platform posted Aug 13
- Senior Backend Engineer, GenAI posted Jul 21
- Senior Backend Engineer - Python posted Jul 9
- Senior Backend Engineer - ML Platform posted May 27
- Senior Backend Engineer posted Feb 4
From the team and dates on lemonade's own job board.
Similar jobs
- Engineering Manager, Enterprise Data Warehouse & Analytics at Machinify
Shares 6 skills: dbt, Data Warehousing, ETL… · Lead level - Data Engineer at Addepto
Shares 6 skills: dbt, Data Warehousing, ETL… - Director of Data Engineering at Ruggable
Shares 6 skills: dbt, Data Warehousing, ETL… · Lead level - Manager, Data Engineering at Fanatics Commerce
Shares 6 skills: dbt, Data Warehousing, ETL… · Lead level - Data Engineering Manager at Trella Health
Shares 6 skills: dbt, Data Warehousing, ETL… · Lead level - Director of Business Technology & AI Ops at lemonade
Also at this company
More jobs like this
Is this your posting? Email [email protected] to have it removed.