Job description
Lightricks creates award-winning apps - in the field of image, video and sound processing - used by hundreds of millions of content creators all over the world.

Join the BI team to build top notch solutions and provide advanced analytics to the business users and management. You’ll design, build and maintain BI solutions in both backend and frontend and work closely with managers at Lightricks to provide the most out of the data.

Responsibilities
Design, build and deploy BI solutions and dashboards to support business needs.
Translate business requirements to technical specifications.
Collaborate with different teams at Lightricks to integrate data from different systems to enable universal solution.
Perform business and data analysis.
Troubleshoot BI-related issues, identify, and resolve any data discrepancies.
Requirements
4 years of experience as BI developer.
2 years of experience with data modeling.
At least 2 years of experience with design and development of dashboards using data visualization tools such as Tableau - Must.
2 years of experience writing complex SQL.
Analytical skills and ability to transform data into actionable insights.
Background in mobile industry – A big advantage.
Hands-on programming skills in Python or other scripting languages - Advantage.
Experience with big data cloud solutions like BigQuery/RedShift/Snowflake – Advantage.
Experience with DBT - Advantage.