Data Analytics & BI Engineer

Job description

Do you want to join us on a journey to change the trillion dollar travel industry? We are looking for the best and brightest who share our passion for travel, data and product. FindHotel believes travel is the one thing that really opens minds to new ideas, cultures and ways of thinking. Our mission is to get every traveller in the world the best accommodation deal. From adventure travel and backpacking to honeymoons and family vacations, we deeply care so that every traveller can make the best informed accommodation choice at the absolute best conditions for every trip. 

In the last 12 months we helped travellers book 1 million nights, while growing profitably at +100% a year, a unique achievement in the accommodation industry today. To make this possible we are collecting and analysing a vast amount of data. Overall, our data pipeline is currently ingesting about 80 GBs of data per hour and growing quickly as we grow. Using these large datasets effectively is a continuous challenge for our engineers and analysts.

We are looking for an enthusiastic, motivated Data Analytics & BI Engineer to help scale our data warehousing and business intelligence capabilities across our product teams. Your mission is to enable analysts and product teams to easily & intuitively interact with data and dashboards to understand user behaviour and generate insights. 

You will have end-to-end ownership from deciding on the events to be fired on the website, to designing the data model around them, to owning the ETL process, to making the data available in our BI platform and building dashboards and to sometimes even helping the team with data analysis. It's a great challenge for the right analyst/engineer to have a huge impact on our business while getting exposed to all aspects of our product.

We work with a modern tech stack including Snowflake and Looker and we work in a flexible, mission-oriented team structure, focused on shipping value in a collaborative fashion.

What you will be doing

  • Design and implement data models to track user behaviour across our product.
  • Build ETL and Business Intelligence environment and dashboards used widely by the product teams.
  • Be the Looker advocate of the product teams, making sure we use the tool effectively, sharing knowledge continuously with other team members.
  • Optimise performance of Looker dashboards and data warehouse processes so that queries, reports & dashboards response times are fast.
  • Relentlessly improve the way that data is delivered & visualised whether it's gathering requirements for a new dashboard or inventing a new, better way of presenting multi-dimensional data.
  • Coach BI users in product teams to make them as capable and independent as possible so that you can focus on bigger things.
  • Analyse user behaviour and price dynamics to generate insights for our product teams, focusing on delivering the best prices to our customers.

Our team

You will collaborate with team members with a wide range of expertise, including engineers, analysts and product owners. Our Hybrid team operates from different locations - many are based in Amsterdam, but we have a growing number of full-time remote team members. What really matters is that you are the right person for the job, not where you do it, but due to the nature of the role and the way our team operates, we need you to be based within UTC-4 to UTC+6

What a working day might look like

You start with a quick look at the overnight ETL summary to make sure that the product teams will get the most recent and fault-free data. During a daily stand-up you discuss the progress on the week's priorities. You sync with them and chat about ingesting data generated by a new feature on our website. Next, you move on to building a Looker dashboard to expose data from new KPIs to our product teams- let's experiment a bit here and provide data using few different visualisations and data presentation methods, the most important objective is to allow them to explore data as seamlessly as possible. 

After lunch it's a good moment to think about how to validate data from the new feature - the nature of ETL or complex SQL calculations is that they like to lose some data points - but you're here to understand and prevent such situations. At the end of the day, you analyse how good the prices from a potential new inventory partner are compared to our existing partners as we want to work only with the partners that deliver the best prices to our customers.


People we love

  • You have several years experience in business intelligence and data warehousing.
  • You are an SQL & data modelling master
  • You have experience with e-commerce, clickstream data and event tracking
  • Ideally you have worked with Looker Data Platform in the past
  • Experience or interest for data analysis is a plus
  • Experience with Python, R, MATLAB or any other programming or scripting language is a plus.
  • You can identify the right balance between excellence and good-enough - and know when good-enough won’t scale any further and will push for a longer term solution.
  • You are flexible, curious and data-guided in deciding what to work on.
  • You have a keen eye for detail
  • You’re autonomous and self directed, but love working in a team and know that what a group of motivated people can achieve is bigger than the sum of its parts. 
  • You’ve worked remotely or as a freelancer before, know how to manage your time, when to go on your own and when to ask for help.

Do you want to know if FindHotel is the right place for you? Find out by reading our CEO's blog post

What we offer

  • Lots of chances to learn and grow – you’ll be surrounded by passionate and talented colleagues, part of a culture which values sharing knowledge every day, and given a budget to attend conferences and develop yourself
  • A profitable company with fast growth and a great scale opportunity
  • We offer a competitive compensation package which includes Stock Appreciation Rights
  • You will be part of a highly international team in a fun work environment
  • You can choose your work style and work from anywhere {as long as you overlap with 4 hrs CET}
  • Once a year we invite all team members to a team retreat