Senior BI Engineer

Who we are

Lightricks, an AI-first company, is revolutionizing how visual content is created. With a mission to bridge the gap between imagination and creation, we're bringing cutting-edge technology to the creative and business worlds. Our advanced AI photo and video generation models, including our open-source LTX-2 model, power products such as Facetune and the LTX Platform, giving brands, creators, and AI enthusiasts limitless control over their creative potential. Our influencer marketing platform, Popular Pays, helps creators scale and monetize their work while enabling brands to expand their reach through tailored creator partnerships.

The Team & Role

The BI team is at the forefront of innovation, leveraging cutting-edge technologies and integrating AI into our development processes to deliver impactful insights and drive strategic decisions. We are also dedicated to empowering users across the organization with self-service BI solutions, enabling them to explore data independently and make informed decisions.

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.

What you will be doing

• 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