< Back

Business Intelligence Analyst

Lightricks Uk

We want to continue our tradition of creating award-winning apps - in London! Our R&D-oriented office offers the agility and excitement of a startup while at the same time reaping the benefits of an established and successful company.

Lightricks Germany

Lightricks continues growing, with an exciting new R&D-oriented office in Munich! Following the success of the products we've developed so far, we are expanding to new turf. We invite you to enjoy the agility and excitement of a startup while reaping the benefits of a well-established & successful company.


  • An amazing option plan
  • Competitive salary
  • Generous pension
  • Subsidised private healthcare, lunch and gym membership.
  • Refreshments! Fruit, veggies, snacks & of course, lots of coffee!

We’re open to suggestions on perks!


  • Competitive salary
  • Amazing stock option plan
  • 28 days of paid vacation + 13 public holidays
  • Home Office Policy
  • Team events
  • Subsidised private healthcare and gym membership
  • Relocation allowance, if needed

We’re open to suggestions on perks!


Help Lightricks gather and extract business insights for our product, user acquisition and marketing teams. As a business intelligence analyst you will supply answers to questions that lie at the core of our business and help us make informed decisions about our marketing campaigns and existing and future product development. As part of our BI team, you’ll work cross-departmentally between marketing, product, finance, and backend teams. The solutions you supply may include reports as well as data visualizations and interactive dashboards.


  • Collaborate with performance marketing analysts and product managers to capture analytical requirements.
  • Understand nuances and structures of available data tables, and how those nuances impact our metric definitions.  
  • Analyze data, develop reports and metrics, and extract insights from our data that allow our teams to make better and more informed decisions. 
  • Communicate findings through data visualizations, written reports and face-to-face meetings. 
  • Work closely with our developers and infrastructure team to improve the design and implementation of our analytics backend.
  • Evangelize and support the adoption of BI across the company.


  • Strong experience in writing complex SQL queries.
  • Understanding of data visualization principles.
  • Ability to think critically about data and develop new empirical metrics. 
  • Highly independent and able to produce accurate and reliable results.
  • High-level of English, strong communication skills. 
  • Intimate knowledge of Amazon Redshift (or PostgreSQL) - a plus.
  • Familiarity with common reporting metrics such as retention and ROAS- a plus.
  • Knowledge of statistics - a plus.
  • Experience with designing database schemas - a plus.
  • Experience working with cloud data warehouses and OLAP (analytics) data - a plus.


If you believe you're the right fit and are interested in joining the team - please fill out the following form:

Other (CV / Portfolio / Cover Letter)
By clicking "Submit" you agree to our Privacy Policy
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

We’d like to have your permission to use third party statistics and marketing cookies. Statistics cookies help us understand how visitors interact with the website. Marketing cookies are used to track visitors across websites, so as to display ads that are relevant for the user. To find out more about these cookies, see our Privacy Policy.