Senior Analytics Engineer

Lighthouse; Barcelona; Presencial; EUR 90.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible time off

Alan Flex benefits

Flexible retribution

Health insurance

Impactful work

Referral bonuses

Descripción de la vacante

Lighthouse is seeking a Senior Analytics Engineer to build scalable data products for enterprise customers and internal teams. You will own from questions to delivery, employing SQL, dbt, Python, and BigQuery, while partnering across Product, Data Science, and Engineering to deliver insights at scale.

Join a data-driven company powering hospitality with AI, contributing to data solutions that impact thousands of hotels worldwide.

Formación

• Expert-level SQL and hands-on, production-level dbt experience, including incremental models, testing, configuration, and performance tuning.
• 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 testing, documentation, data quality, governance, and correctness.
• Strong stakeholder-management skills and the ability to communicate technical decisions clearly.

Responsabilidades

• Design, build, and improve reliable production data models and products using SQL, dbt, Python, and BigQuery.
• Turn business 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 timelines.
• Use AI to accelerate development, analysis, scoping, and documentation, and explore AI-powered capabilities like automated quality checks.

Conocimientos

SQL

Data modeling

Stakeholder management

Communication

Team collaboration

Herramientas

dbt

BigQuery

Python

Looker/Tableau

Airflow

Descripción del empleo

At Lighthouse, we’re on a mission to revolutionize commercial strategy as hospitality’s most powerful AI platform. We take the world's largest hotel data network and transform it into real-time intelligence that drives action. We don't just deliver insights; we empower businesses to make decisions that move revenue.

With $370M in Series C funding and over $100M in ARR, we are scaling at lightspeed. Our 850+ teammates across 35 countries aren't just building software—they are leveraging cutting‑edge AI to help hoteliers be the first to act. Tens of thousands of hotels across 185 countries trust Lighthouse to execute their commercial strategy, including every one of the top 15 global chains and thousands of independent hotels that consistently outperform their markets. With Lighthouse AI, the intelligence gets deeper. Decisions get smarter. Actions get faster. We help hoteliers be first to act.

Lighthouse Values: Our guiding light

We are Lumineers. Our shared values keep us on a collaborative path fostering a cultural and customer centric environment.

• Pursuit of greatness : We’re innovators who care deeply about our customers’ success. Our team brings their best work, stays curious, and delivers excellence through attention to detail
• Meaningful work matters : We make every moment count by knowing what to deliver, why it matters, and how it drives Lighthouse forward
• Elevate each other : We don’t just work together - we grow together. What unites us is understanding each other as people and working toward shared goals

We’re more than just a workplace – we’re a community. Collaborative, fun, and deeply committed, we work hard together to revolutionize the hospitality sector. Are you ready to join us and shine brighter in the industry’s most exciting rocket-ship?

What you will do

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.

Where you will have impact

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

What's in it for you?

• Flexible time off: Autonomy to manage your work‑life balance.
• Alan Flex benefits: 160€/month for food or nursery.
• Flexible retribution: Optional benefits through tax‑free payroll deductions for food, transportation and/or nursery.
• Comprehensive health insurance: 100% Alan coverage for you, your spouse, and dependents.
• Impactful work: Shape products relied on by 85,000+ users worldwide.
• Referral bonuses: Earn rewards for bringing in new talent.

Who you are

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

We welcome

• Experience with client‑facing products, external customers, or complex internal stakeholders in a SaaS or consultancy environment.
• Familiarity with tools and practices such as BigQuery, Airflow, Looker or other visualization platforms, cloud analytics platforms, and Agile ways of working.
• Experience using AI in recurring workflows, agent‑based processes, or customer‑facing data products.
• Knowledge of travel, hospitality, or short‑term‑rental data, or experience mentoring colleagues and improving analytics‑engineering practices.

Technologies you will work with

SQL (Google’s BigQuery), python, GCP, Looker / Tableau, terraform, airflow, Claude.

Diversity, equity, inclusion, and belonging

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 part of our culture. If you require reasonable accommodation at any point during the application or interview process, please notify your recruiter.

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!