.About usAvantio, 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 optimizing 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 modeling, including the creation of star and snowflake schemas to optimize 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