Senior Analytics Engineer

Job Details

• 💼 Engineering
• 📍 Spain
• 🕜 Full-Time/Remote

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. 
• Wellbeing support: Subsidized ClassPass subscription.
• 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.