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, Lightricks is dedicated to bringing cutting-edge technology to the creative and business spaces.

Our advanced AI photo and video generation models, including our open-source LTXV model, power our apps and platforms including Facetune, Photoleap, Videoleap, and LTX Studio, allowing creators and brands to leverage the latest research breakthroughs, offering endless control over their creative potential. Our influencer marketing platform, Popular Pays, provides creators the ability to monetize their work and offers brands opportunities to scale their content 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, maintanance 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, Redash)
• 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.

Your skills and experience

• Minimum 3 years of professional experience in BI or Data Engineering roles
• Advanced SQL skills are essential
• Demonstrated expertise in designing, constructing, and maintaining efficient data pipelines using DBT or similar tools for ETLs and orchestration
• Experience in designing, building, and optimizing big data solutions (GCP is an advantage)
• Skilled in using Git
• Experience with data visualization tools (e.g., ThoughtSpot, Tableau, Looker)
• Advanced 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