Senior Analytics Engineer @ OTA Insight in Greater Madrid Metropolitan Area

OTA Insight

+44 20 3095 2727

To apply for this job please visit

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:

We’re looking for a pragmatic and experienced Senior Analytics Engineer with 3+ years of experience in a similar role. The ideal candidate will have a keen eye for detail, outstanding problem-solving skills, and the ability to make data-driven decisions.

Where you will have impact:

  • Perform client-focused analysis to identify trends, patterns, and insights on our data.
  • Closely work with our Operations Team to deliver valuable data & insights to our clients.
  • Develop dashboards, graphs, and visualizations to communicate data findings to clients and internal stakeholders.
  • Provide your strategic vision to the product team to help create and improve existing features and datasets.
  • Collaborate with the Marketing team to help build interesting articles supported by data insights.
  • Help the Quality Assurance team to ensure that data quality is up to the required standards.
  • Collaborate with IT teams and data engineers to develop and maintain databases, data systems, and data pipelines.

About our team:

Our team is an integral part of our larger organization, dedicated to delivering Short Term Rental and Hotel insights to Destination Marketing Organizations (DMOs) and enterprise clients. We are a diverse and international ensemble of web developers, data engineers, and data analysts who work together to meet our clients’ diverse needs.

Our mission is to empower clients with precise data and insights, aiding them in making informed decisions. We work in close collaboration with business stakeholders and clients, developing bespoke datasets and analytical reports tailored to their specific requirements. Our team also specializes in data acquisition from leading accommodation platforms such as Booking, Expedia, and Airbnb, ensuring our clients have access to the most comprehensive and current data.

While our office is situated in the vibrant heart of Madrid, we promote a flexible work culture, encouraging our team members to work remotely as needed. As a dynamic and growth-oriented team, we are constantly expanding our horizons and refining our data acquisition and analysis techniques.

Technologies you’ll work with:

Postgres (SQL), BigQuery, dbt, Looker, Google Cloud, etc.

 (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 choose-your-own mobility budget when you’re based in Belgium or a 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:

  • Proven working experience and proficiency with analytical databases in SQL, such as Clickhouse or BigQuery.
  • Strong knowledge of and experience with data analysis in Python.
  • Relevant experience with one or more data visualization tools (Metabase, Tableau, PowerBI, etc.).
  • Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS, etc.).
  • Good organizational skills, with a logical approach to problem solving, excellent time management, and task prioritization skills.
  • Outstanding written and oral communication skills in English.
  • Proactive and able to work with a minimum of supervision.

We welcome:

  • Experience with other programming languages (Javascript, R, Matlab, etc.).
  • Experience with system administration including Unix command line, and shell scripting.
  • Experience with deployment tools such as Docker, CI integration, or similar.
  • Experience with mentoring junior team members.

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.