.About Us: Avantio, with more than 20 years of experience, is one of the world leaders in technology solutions for holiday rentals.We provide short-term rental agencies with an all-in-one 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 top-level 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.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