Data Engineer - Lemonade

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