Data Engineer

**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.

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?**- +2 years of experience in Data Warehousing.
- Expertise in implementing ETL/ELT processes.
- Fluency in English and Spanish is mandatory.
- 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 full-time 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 long-term career. We offer you activities, tasks and