Senior BI Engineer

Location: Jerusalem

Department: G&A

Lightricks is an AI-first company creating next-generation content-creation technology for businesses, enterprises, and studios, with a mission to bridge the gap between imagination and creation. At our core is LTX-2, an open-source generative video model, built to deliver expressive, high-fidelity video at unmatched speed. It powers both our own products and a growing ecosystem of partners through API integration.

The company is also known globally for pioneering consumer creativity through products like Facetune, one of the world’s most recognized creative brands, which helped introduce AI-powered visual expression to hundreds of millions of users worldwide. We combine deep research, user-first design, and end-to-end execution from concept to final render, to bring the future of expression to all.

What you’ll be doing

As a BI Engineer on our team, you'll collaborate with talented professionals dedicated to pushing boundaries and creating advanced solutions. You'll also play a key role in pioneering the adoption of cutting-edge AI-driven tools and processes, proactively advocating for innovative solutions, LLM-based scripting, and efficient AI workflows. Your early-adopter mindset will be essential in shaping the future of data-driven excellence at Lightricks.

• Collaboration and Communication: Work closely with data analysts, data scientists, tech, finance and business stakeholders to understand their data requirements to build and deliver data infrastructure, reports and insights that meet their needs. 

• ETL Processes: Develop highly scalable complex data pipelines to integrate data from multiple sources, ensure that data is accurately extracted from source systems, transformed into the required format, and loaded into the data warehouse (DWH) (using DBT, Git). It also includes verification and monitoring of data quality (Elementary).

• Implement GenAI solutions: As part of the job, you will implement new solutions and tools to improve the efficiency of the teams, support self-service for the users and provide insights easily, automatically and quickly.

• Data modeling: Responsible for the model, design, implementation, maintenance and improvement of the data warehouses, as well as ensuring the integrity and security of data. Support users needs, including performance and monitor cost

• Business Analytics Tools: Design and implement BI tools across the company. Troubleshooting and optimizing the tools and systems to improve performance. This includes ensuring that the reports and dashboards are running efficiently and meeting the user's needs (using ThoughtSpot, Hex)

• Staying Updated with Industry Trends: Keep up with the latest trends and technologies in data solutions, analytics and business intelligence to ensure that lightricks stays ahead in leveraging data for business decisions. Continuously questioning assumptions, processes, and outcomes to uncover hidden opportunities or potential issues

Your skills and experience

• 5+ years as a BI Engineer, Analytics Engineer, or Data Engineer

• Advanced SQL skills are essential

• Demonstrated expertise in designing, constructing, and maintaining efficient data pipelines using DBT or similar tools for ETLs and orchestration

• Advanced SQL skills and hands-on experience with cloud data warehouses

• Experience with data visualization tools (e.g., ThoughtSpot, Tableau, Hex)

• Solid Python programming skills

• High level of English proficiency

• An academic degree in a quantitative discipline is a plus

Highly Valued Experience:

• Experience in LLM-Based Mini-App or Script Development: Experience creating mini-apps or scripts that leverage large language models (LLMs) as a core functionality component

• Experience Using AI-Tools for Efficient Development: Using generative AI tools (e.g., Cursor IDE, Claude, MCP) to accelerate scripting, streamline workflows, and efficiently prototype ideas

Why Join Us

We’re here to push the boundaries of what’s possible with AI and video - not for the buzz, but for the craft, the challenge, and the chance to make something genuinely new.

We believe in an environment where people are encouraged to think, create, and explore. Real impact happens when people are empowered to experiment, evolve, and elevate together.

At Lightricks, every breakthrough starts with great people and a collaborative mindset. If you're looking for a place that combines deep tech, creative energy, and zero buzzword culture, you might be in the right place.

We got you covered

• We run daily door-to-door shuttles, offering Car-to-go subscriptions from several locations in central Israel, plus free parking and train-station pickups.
• We’re proud to have 2 chef-led restaurants on site by the legendary Machneyuda Group (yes, that Machneyuda!), plus a bakery nestled in the heart of our office, filled daily with the scent of fresh pastries.
• We empower employees with cutting-edge tools and learning opportunities to grow and succeed through workshops, access and training on platforms, subscriptions, and clear guidelines for responsible AI use.