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