Companies you'll love to work for

Analytics Engineer

OTA Insight

OTA Insight

Data Science
Ghent, Belgium
Posted on Tuesday, April 2, 2024

At Lighthouse (formerly OTA Insight), we’re on a mission to reimagine commercial strategy for the hospitality industry. Our commercial platform simplifies data, transforming complexity into confidence with actionable market insights, business intelligence, and pricing tools that maximize revenue.

We successfully raised 80 million in series of B funding, we welcomed four companies to our organization and want to grow over 100 million in ARR in 2024. With more than 560 teammates illuminating the way, representing 34 nationalities living in 35 different countries of which 175 in Belgium alone, we are a fun, collaborative and committed team that works hard to achieve amazing results. Ready to take off and join this rocketship in revolutionizing the hospitality sector? 🚀

What you will do:

As an Analytics Engineer you will help our employees make better decisions by providing trustworthy data analytics. The 3 building blocks for this role are: requirements gathering, data modelling and supporting the business in getting the insights from the data through the use of data visualization.

Where you will have impact:

  • Build analytics in code by writing highly-performant SQL and creating optimized data models
  • Contribute to our dbt code by developing on our dimensional data models
  • Collaborate through version control and peer reviews
  • Gather requirements from different internal business units (Product, Sales, Operations, Marketing, …)
  • Translate business requirements into performant, reusable, tested and documented data models which provide actionable insights
  • Maintain and grow our data catalogue
  • Guide reporting analysts and business users in deciding which data points and metrics are relevant to track progress on their objectives
  • Own the design, implementation and maintenance of advanced analytics dashboards and KPI reports in our BI tool
  • Support our transition to become more data-driven by enabling functional teams to explore data marts in self-service mode so they can answer their own questions
  • Improve our product by performing A/B tests and analyzing how ideal customers use our product features
  • Research and follow recent industry and technology trends so we can continue reaping the benefits of being a fast-moving technology adopter. You'll always be on the lookout for the best solution.

About our team:

The Lighthouse Analytics Engineering team is the internal data team within our wider engineering organization. Our mission is to ensure internal stakeholders can make the right decisions by providing timely data insights and empowering the functional team themselves with easy to use access to our internal data. The team works in close collaboration with experts from all departments to build compelling reports on their objectives, as well as with a highly talented group of software engineers to drive initiatives forward and continuously improve our analytics stack.

Today we maintain a growing cloud data warehouse containing information coming from multiple sources, ERP systems, billing tools, application usage data , etc. All of that using modern technologies. Being a growth company ensures us to keep adding additional sources and continue enriching our internal data insights.

Technologies you will work with:

Postgres (SQL), MySQL, BigQuery, dbt, Looker, Google Cloud, GitLab, Airflow, Jira, Meltano, Python, PipelineWise, Rundeck, Stitch, Terraform

(feel free to ask us why these are the best fit for us)

What's in it for you:

  • A flexible working environment where you can work from home or, if you live nearby, at one of our seven offices around the world
  • Unlimited time off: we believe in providing our employees with the flexibility and autonomy to manage their work-life balance effectively
  • A motivation to deliver your best work as we have built a high-bar and very talented team of individuals that are friendly, creative, open-minded, and passionate about what they do
  • Workshops and frameworks that help employees realise their full career potential
  • A mandate to operationalize and democratise research through tools, training, and processes
  • The opportunity to shape the products that more than 85,000 users rely on worldwide
  • A mobility approach that fits your personal situation, with a mobility budget or company car
  • Extensive health insurance packages for you and your dependents prioritising our employees' holistic well-being and healthcare needs
  • Private pension funding through group insurance
  • A compensation that values your work and which we will proactively keep competitive
  • A referral bonus scheme when you bring new talent to our #bestteamever!

Who you are:

  • Minimum of 2-4 years of working experience as a Data professional
  • Familiarity with data structures and data models, e.g. ERDs, and a good understanding of data warehousing
  • Proficient in writing highly-performant SQL queries and eager to learn more about it
  • Experience with dimensional modeling and a good understanding of data warehouse design
  • Experience in stakeholder management and requirement gathering
  • Experience visualizing datasets using BI tools (such as Looker, Tableau, PowerBI, etc.)
  • Experience with ELT/ETL tools (such as Fivetran, Stitch, etc.) and data transformation tools (such as dbt, Dataform, Terraform, etc.)
  • Familiarity with software engineering best practices like version control and continuous integration
  • Strong problem-solving and analytical skills
  • Highly organized, detail-oriented, and have a customer service mentality
  • Ability to work cross-functionally and collaborate with stakeholders from different business units
  • Self-driven and motivated with a strong work ethic
  • Fluent in English, both written and spoken, any other language used within our company network is a plus

Thank you for considering a career with Lighthouse. We are committed to fostering a diverse and inclusive workplace that values equal opportunity for all. We welcome candidates from all backgrounds, regardless of age, gender, race, religion, sexual orientation, and disability. Our commitment to equality is not just a policy; it's part of our culture.

If you share our passion for innovation and teamwork, we invite you to join us in shaping the future of the hospitality industry. At Lighthouse, our guiding light is to be an equal opportunity employer, and we encourage individuals from all walks of life to apply.

We value the unique perspective and talents that you bring, and we're excited to see how your light can shine within our team. We can't wait to meet you and explore how we can grow and succeed together, illuminating the path towards a brighter future for the industry.