Check out opportunities at TheVentureCity and our family of startups

Business Intelligence and Data Engineer



Operations, Data Science
Madrid, Spain
Posted on Thursday, October 19, 2023

About Spotahome

Spotahome is an international online marketplace which offers verified rental accommodation across 100 European cities in 27 countries and with a global ambition. Spotahome began as a start-up created in 2014 by 4 friends with a vision to revolutionise the traditional real estate space starting with digitalising rentals.

At Spotahome we make renting easy by allowing people to book completely online from wherever they are in the world, with the knowledge that the property they are booking is real and accurate. We are the only ones sending “Homecheckers” to make videos, floorplans, and photos to the almost 100,000 properties across Europe.

So far we’ve helped over 150,000 renters find their perfect home – no more traditional viewings, no more time-wasting, just easy online renting!

We are backed by some of the most highly reputed international investors from Silicon Valley, the UK, and Spain; having raised €80+ Million to date.

Why Spotahome

🚀Remote flexibility and flexible work schedule, we trust our team and we are goal oriented

💰 Competitive salary in accordance with candidate experience, alongside our flexible retribution system (restaurant vouchers, transport, etc.) to get the most out of your salary

🎫 Stock Options of one of the most promising and best funded start-ups in Europe

🥇Wellness and benefits plan to take care of your physical and mental health, including gympass and access to mental health programs

🥳 Day off on your birthday, we celebrate it with you

📒 Training budget, company events and team building activities.

👉 A challenging and creative job in an innovative, constantly growing, fast-moving and owner-managed company with many opportunities for growth

🙌 An open corporate culture with plenty of room for new ideas and impulses

🎉 People. Work with talented, committed and supportive teammates

👋International work environment with more than 16 nationalities

✨No politics or bureaucracy. Only a great environment for you to achieve your best work

What would you be doing as a BI and Data Engineer?

You will be joining the Data and Analytics Team and you will work closely with the different departments of the company to build beautiful insight with the company data.

The data and analytics team owns a big chunk of Spotahome’s stack:

  • A data pipeline that moves data from our transactional databases and our analytical systems (Segment, Amplitude, Google Analytics) to a data lake in BigQuery

  • A set of ETLs in DBT that transform that data and load it into our Postgres Data Warehouse.

  • Self-service dashboarding tools to access this data: Metabase

  • A dbt (data build tool)-based pipeline to transform Data Lake data into a feature store for statistical and machine learning models.

  • A set of statistical and Machine Learning models trained and executed against this feature store (mostly written in Python).

  • A Python-based REST API so other systems can consume the output of these models.

Within this stack, as a BI engineer, you will be heavily immersed into our data pipelines, data lake and data warehouse evolution and maintenance, along with the self-service dashboarding tools in and Metabase, collaborating as well with our data engineers and data scientists in working in our feature store and dbt pipeline

Within this context, your responsibilities will be:

  • First and foremost, you will be an advocate for data-informed decision making in Spotahome. You will participate in educating key roles in the company on how to get better insights from our data and participate with them in decision making

  • You will be the owner of the data the company will base their decision making in. That implies: fetching data from heterogeneous sources, consolidating it in a reliable and automated reporting system, and ensuring it is accessible and understandable for the key decision makers.

  • You will design and implement the processes and the reports to analyse all company KPIs, and work closely with the product, operations, marketing and business teams to analyse those KPIs. You shall own different dashboards and reports used in weekly, monthly and quarterly reporting, and that will imply working closely with Metabase as the main dashboarding tool.

  • You will maintain and evolve the tech stack supporting all the processes above. That shall imply:

    • Database modelling and performance: You will work with our data lake (BigQuery) and our data warehouse (Postgres).

    • SQL querying for report, ETL(DBT) and dashboard creations.

    • Getting exposed to the entire Spotahome transactional architecture (PHP microservices persisted in MongoDB and MySQL) to understand the data model and be able to design proper data pipeline solutions.

  • You will join a young and eager to learn team. Your teammates will strive to help you on your professional development, and it will be expected that you contribute to a continuous learning and improvement of the team.

  • You will also join a very fast-paced StartUp environment, therefore you will need to dive comfortably in high ambiguity situations. It is a big challenge that requires an analytical mindset.

What are we looking for?

  • Engineering degree desired

  • 3-7 years of experience in professional engineering or data environment, preferably on BI or data engineering roles.

  • High proficiency writing SQL

  • Exposure to software development, preferably in Python.

  • Experience developing ETLs (preferably with DBT)

  • You can take a complex concept and make it sound simple. You’re accomplished at orienting business users within the data domain, understanding their needs, and translating them into technical requirements to ultimately design effective BI solutions

  • Experience with at least one Data Visualization tool (Power BI, Tableau, etc.)

  • Relational database and data warehousing concepts.

  • High attention to detail and ability to effectively manage multiple projects at a time with focus on meeting deadlines.

  • Have a hands-on and positive attitude.

  • Good communication skills and fluency in english.

  • NOTE: candidates with no experience in ETLs might be considered if excellence is demonstrated in other areas (data modelling, reporting, communication skills, …)

Nice to have

  • Experience with DBT

  • Experience with Python development

  • Previous startup environment experience

Become a Spotter today!

At Spotahome we have a friendly open collaborative culture and a united team vision. All of our #Spotters have the ability to make a big impact (we love entrepreneurial/risk taking/high ambition mindsets). Our work is rewarding and we help each other win by creating a supportive and collaborative environment for one another. Take a look at our opening and send us your application - we look forward to hearing from you!

Diversity Statement

Here at Spotahome we’re passionate about creating an inclusive culture that encourages, supports, and celebrates the diverse voices of our employees. Everyone is welcome, we don’t discriminate on the basis of any protected characteristic including race, religion or belief, gender or gender reassignment, age, sexual orientation, marital status, or disability. We want to facilitate everyone in bringing their best selves to our interviews, so if there are any adjustments we can make for our process to be more inclusive, please let us know.