Data Warehouse Tech Lead

The role

The Data Warehouse Tech Lead drives the technical vision and execution of the data infrastructure. You will architect scalable solutions and coordinate business needs to ensure the platform serves the entire organization.

What you will do

• Design and develop scalable data warehouse solutions
• Set strategy and guide execution for the Data Warehouse team
• Translate business needs into technical requirements
• Establish clear data contracts with R&D, Analytics, and external data providers
• Set technical standards for architecture, performance tuning, and development methodologies
• Build resilient data pipelines for unstructured data and schema registry management
• Create robust data structures using dimensional modeling
• Optimize ETL/ELT processes for the semantic layer
• Build processes for schema evaluation, anomaly detection, and monitoring data quality
• Collaborate with Data Engineers, ML Platform Engineers, Data Scientists, Analysts, and Product Managers

Required qualifications

• 7+ years as a BI Engineer or Data Engineer
• 2+ years 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
• Hands-on experience with Snowflake or similar cloud-native data warehouse platforms
• Extensive experience with dbt for data transformation and modeling
• Excellent communication skills to mentor technical team members and explain concepts to stakeholders

Nice to have

• Python and software development experience

About the company

Lemonade is building the future of insurance with an AI-first approach.