Senior BI Engineer

Tel Aviv, Israel | Engineering | Full-time
Not your everyday company

Lemonade completely reinvented how insurance works. As a customer-centric tech company, we created an insurance experience that is smart, instant, and delightful.

At Lemonade, you’ll be working with a group of like-minded makers, who get a kick out of moving fast and delivering great products. We surround ourselves with some of the smartest, most motivated, creative people who are filled with positive energy and good karma.

Unlike most publicly traded companies, we’re nimble and efficient. We take pride in the fact that we still think and operate like a startup. We don’t care much about titles and hierarchy and instead focus on innovation, bold moves, and challenging the status quo.

We’re built as a lean, data-driven organization that relies on a common understating of objectives and goals to provide teams with autonomy and ownership. We don’t like spending our days in meetings and we skip committees altogether. At Lemonade, there’s no such thing as going over someone’s head. We have zero tolerance for bureaucracy, office politics, and lean-back personalities.

As a Public Benefit Corporation and a certified B-Corp, we deliver environmental and social impact using our products and tech. Through our Giveback program, we partner with organizations such as the ACLU, New Story, The Humane Society, Malala Fund, American Red Cross, 360.org, charity: water, and dozens of others, and have donated millions towards reforestation, education, animal rights, LGBTQ+ causes, access to water, and more.

Awarded ‘best workplace’
Best Workplace and Best-Led Company by Inc. Magazine
“World Changing” by Fast Company
Recognized as a World Changing Idea by Fast Company Magazine
Ranked #1 Home insurance in America
Won best renters and homeowners insurance in America by US News, and others
Best Pet Insurance in America
Rated “Best Overall Pet Insurance” by Better Homes & Gardens
Rated 4.9 on the App Store
Among the highest rated apps of all time
What you’re applying for

We’re looking for an experienced Senior BI Engineer to join our BI Data Platform team in TLV.

As a Senior BI Engineer, you will play a pivotal role in the organization's data platform and analysis. You will lead the design, development, and maintenance of BI solutions that empower stakeholders across the company and contribute to informed decision-making processes while leveraging your extensive experience in business intelligence.

This is an excellent opportunity to be part of establishing Lemonade’s BI data platform, implementing cutting-edge technologies in a cloud environment.

In this role you’ll

Lead the design and development of scalable and efficient 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 processes to ensure the extraction, transformation, and loading of data from various sources into the BI platform

Identify and address performance bottlenecks within BI solutions, optimize queries, and enhance data retrieval efficiency

Implement best practices for DWH and database performance tuning

Conduct thorough testing of BI applications and implement robust validation processes

Collaborate with data engineers, developers, ML engineers, data scientists, analysts and product managers

Share knowledge with other team members and promote BI standards

What you’ll need

5+ years of prior experience as a BI Engineer or Data Engineer

Prior experience working with DBT and Airflow

Proficient in data modeling, ETL development and DWH methodologies and best practices

Strong SQL skills and experience working with Snowflake or similar DB

Experience with Python and software development is an advantage

Leadership skills, with the ability to guide and mentor other team members

Excellent communication and collaboration skills

Ability to work in an office environment a minimum of 3 days a 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

Things 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.