Data Engineer

What You’re Applying ForWe’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.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’llLead the design and development of scalable and efficient data warehouse and BI solutions that align with organizational goals and requirementsUtilize advanced data modeling techniques to create robust data structures supporting reporting and analytics needsImplement ETL/ELT processes to assist in the extraction, transformation, and loading of data from various sources into the semantic layerDevelop processes to enforce schema evaluation, cover anomaly detection, and monitor data completeness and freshnessIdentify and address performance bottlenecks within our data warehouse, optimize queries and processes, and enhance data retrieval efficiencyImplement best practices for data warehouse and database performance tuningConduct thorough testing of data applications and implement robust validation processesCollaborate with Data Infra Engineers, Developers, ML Platform Engineers, Data Scientists, Analysts, and Product Managers What you’ll need3+ years of experience as a BI Engineer or Data EngineerProficiency in data modeling, ELT development, and DWH methodologiesSQL expertise and experience working with Snowflake or similar technologiesPrior experience working with DBT Experience with Python and software development, an advantageExcellent communication and collaboration skillsReady to work in an office environment most days of the weekEnthusiasm about learning and adapting to the exciting world of AI – a commitment to exploring this field is a fundamental part of our cultureThings to know…Lemonade is an equal opportunity employer committed to diversity and inclusivity. We never discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. If you require reasonable accommodations due to religious beliefs, pregnancy, or disabilities, let us know at any time.