Senior BI Engineer

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