< Back

Business Intelligence Data Engineer

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.


  • 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!


Help Lightricks gather and extract business insights gathered from our product, user acquisition and marketing channels. As a business intelligence data engineer 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.
  • Translate requirements into BI solutions that are effective, easy to use and well performing.
  • Work closely with our developers and infrastructure team to improve the design and implementation of our analytics backend.
  • Evangelize and support the adoption of self-service BI across the company.


  • Strong experience in writing complex SQL queries.
  • Experience working with cloud data warehouses and OLAP (analytics) data.
  • Intimate knowledge of Amazon Redshift (or PostgreSQL) - a plus.
  • Understanding of data visualization principles.
  • Experience with designing database schemas.
  • Highly independent and able to produce accurate and reliable results.
  • Familiarity with common reporting metrics such as retention and CPA - 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.