Senior Analytics Engineer, Lighthouse

• Expert-level SQL and hands-on, production-level dbt experience, including incremental models, testing, configuration, and performance tuning
• A track record of owning reliable data models or products in production, with strong data-modeling skills and experience working with large, complex datasets
• Strong data-warehouse fluency with BigQuery or an equivalent platform, including the ability to diagnose query cost and performance issues
• Experience using Python for data analysis or data-product development, alongside a practical approach to testing, documentation, data quality, governance, and correctness
• Strong stakeholder-management skills and the judgment to explain technical decisions, manage trade-offs, and move ambiguous work forward
• A direct, pragmatic, and collaborative working style, with concrete examples of using AI to improve how you work independently and with a distributed team
• Excellent communication skills in both written and spoken English
• Not ticking every box? No problem! We value diverse backgrounds and unique skill sets, and we encourage individuals from all walks of life to apply. If your experience looks a little different from what we've described, but you're passionate about what we do and are a quick learner, we'd love to hear from you!

Desirable

• We’re looking for a Senior Analytics Engineer to help us build reliable, scalable data products for enterprise customers and internal teams
• This is a hands-on role with a strong focus on SQL, dbt, data modeling, data-product development, and practical AI integration—not traditional dashboarding alone
• You’ll own work from a stakeholder question through analysis, modeling, quality assurance, and delivery
• You’ll also help strengthen how the team works with dbt and contribute to our shift toward scalable data delivery
• You will take on direct customer-facing responsibilities, with support from the team as you build that experience
• Design, build, and improve reliable production data models and products using SQL, dbt, Python, and BigQuery
• Turn business and customer questions into scalable solutions, owning delivery from scoping and analysis through modeling, testing, documentation, QA, and actionable insights
• Diagnose and improve data quality, query performance, and cost across large, complex datasets
• Partner with Product, Data Science, Engineering, Commercial, and Account Management to define requirements, explain trade-offs, and manage expectations on feasibility and timelines
• Use AI to accelerate development, analysis, scoping, and documentation, and help explore AI-powered capabilities such as automated quality checks and agentic customer or sales tooling
• Share your dbt expertise, strengthen team development practices, contribute to enterprise and internal initiatives, and eventually join the evolving on-call rotation for enterprise data products
• About our team:
• Lighthouse is not only a data-driven company, we are a data company
• The heart of all our products is data. It enables hotels to make the right decisions and fuel our analytical solutions
• Being a growth company enables us to regularly attract new and interesting datasets, which can unlock new product directions
• Today we process billions of data points and +100TB of data on a daily basis, containing hotels' pricing information, search data, hotel bookings, etc. All of that using modern technologies
• The data solutions team is part of our Enterprise vertical within engineering:
• Teams, originally from different companies and acquisition being brought together and integrated into 2 product areas: Data solutions and Distribution
• It’s focused on data we have, leveraging it in a different way, and using the vastness of datapoints Lighthouse can offer, to support our Enterprise customer in the best way possible
• It’s ‘a few’ customers being served by a product roadmap. We build and we iterate
• Technologies you will work with:
• SQL (Google’s BigQuery), python, GCP, Looker / Tableau, terraform, airflow, Claude