Data Warehouse Developer

About us

Avantio with more than 20 years of experience is one of the world leaders in technology solutions for holiday rentals. We provide shortterm rental agencies with an allinone solution to help them manage their business: Property Management System Channel Manager and Website.

Based in Valencia and with sales teams in the USA and LATAM in Avantio you will discover a highly qualified team made up of toplevel professionals in an international environment.

Description:

You will be part of the newly formed Data science and Analytics team at Avantio. Our mission is to drive growth for our clients by innovating and optimising technology through the use of machine learning and AI.

You will play an important role in the development of our Dynamic Pricing model and Advanced analytics features and help to lay the foundation for further innovation in these areas. This is a fantastic opportunity for someone who thrives on building solutions from scratch and wants to make a significant impact on the company and clients.

Designing building and maintaining robust data pipelines integrating data from various sources and ensuring data quality and consistency. This role will be critical in supporting the development of dynamic pricing models revenue management tools and advanced analytics features within our Property Management System (PMS).

Key Responsibilities:

• Data Warehouse Development and Design:

Architectural Knowledge: Knowledge of data warehouse architectures such as Kimball Inmon and Data Vault to design robust and scalable solutions.

Data Modeling: Proficiency in data design and modelling including the creation of star and snowflake schemas to optimise query performance and ensure data integrity.

ETL/ELT Processes: Implementation of ETL (Extract Transform Load) or ELT (Extract Load Transform) processes to efficiently move and transform data from various sources into the data warehouse.

• Databases:

RDBMS Experience: Strong experience with relational database management systems (RDBMS) such as SQL Server ensuring robust data management and query optimization.

NoSQL Knowledge: Familiarity with NoSQL databases such as MongoDB and Cassandra enhancing our capability to handle unstructured data.

Advanced SQL Skills: Expertise in advanced SQL for complex queries optimization and data manipulation to support data analysis and reporting needs.

• ETL/ELT Tools:

ETL Tool Handling: Proficient in using ETL tools like Microsoft SSIS (SQL Server Integration Services) to automate data integration and transformation processes.

Scripting Languages: Experience with scripting languages such as Python R and Bash for custom data transformation tasks and automation.

• Data Integration:

Multiple Data Sources: Skilled in integrating data from multiple sources including databases flat files APIs and web services to create a cohesive data environment.

Data Cleansing: Knowledgeable in data cleansing and transformation techniques to ensure data quality and consistency across the data warehouse.

• Business Intelligence (BI):

BI Tools Usage: Proficient in BI tools like Microsoft Power BI Tableau QlikView and Looker for creating insightful reports dashboards and interactive visualisations.

Business Metrics: Understanding of business metrics and KPIs (Key Performance Indicators) to develop meaningful analytical insights.

• Big Data and Processing Tools:

Big Data Technologies: Familiarity with Big Data technologies such as Hadoop Spark and Hive to manage and process large datasets efficiently.

Cloud Platforms: Knowledge of cloud platforms like AWS Azure and Google Cloud Platform (GCP) to leverage cloud services for scalable and flexible data warehousing solutions.

What are we looking for

• 35 years of experience in Data Warehousing.
  
• Expertise in implementing ETL/ELT processes.
  
• Advanced skills in SQL and experience with RDBMS like SQL Server.
  
• Experience with scripting languages like Python.
  
• Proficiency in BI tools like Power BI Tableau etc.
  
• Experience with cloud platforms (AWS Azure GCP).
  
  

Useful to have:

• Experience in the vacation rental or hospitality industry.
  
• Understanding of data privacy and security best practices.
  
• Familiarity with agile development methodologies.
  
• Relevant education or certifications.
  
• Knowledge of MongoDB
  
  

What do we offer

• We are a leading global provider of solutions services and technological tools for holiday rentals with a stable projection.
• Stable fulltime contract.
• Competitive salary according to experience and the test
• Training provided by the company.
• Flexible working hours.
• We currently have a hybrid working system which means that we come two days a week and three days of telework .
• Possibility to build a longterm career. We offer you activities tasks and responsibilities that will allow you to grow professionally and personally.
• Flexible remuneration plan.
• Worklife balance: childcare allowance afternoon off for childrens birthdays and support during their first days at school :)
• Carsharing: the possibility of giving your colleagues a lift in your car (monthly extra from the company) or you can travel to work with colleagues free of charge.
• A dynamic and multicultural environment with more than 24 nationalities to get to know.
• The opportunity to work in a young and international team. We currently have 175 employees with cultural diversity.
• Attractive facilities and atmosphere: lounge areas with sofas (pingpong table table football...) fully equipped cafeteria (coffee fresh fruit...) and a roof terrace with interesting views. We have fun!
• Employment advice: a small guide to help you with all your documentation (NIE social security number or how to register in a place...).

At Avantio we look for people who identify with our values: we care we constantly help each other we communicate a lot (both internally and with our clients and partners) and we learn from each other. We want you to make this project yours too!

We provide the necessary tools and opportunities to grow professionally. You will be challenged so that you can develop your professional career and this will lead to the growth of the company. In other words the skys the limit.

If all this describes you and you want to work in a young international company with these values dont hesitate to apply!