Sql dw engineer Empleos en Valencia

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 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.
• 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 visualizations.
• 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?

Useful to have :

What do we offer?

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 sky's the limit".

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

J-18808-Ljbffr