Set up Looker studio report + N8N data collection process from Servio to Bigquery

We are looking for an experienced specialist to develop an automated workflow based on n8n that retrieves data from the Servio API (data about guests, invoices, fiscal sessions, deposit accounts, revenue statistics, etc.) and uploads it to Google BigQuery. The project should provide:

    •    Automatic launch (cron) and manual launch (webhook);

    •    Receiving, transforming, validating, and processing data from the Servio API;

    •    Uploading data to the appropriate BigQuery tables using INSERT/MERGE operations;

    •    Implementation of error handling and synchronization control mechanisms.

Set up reports on clients, orders, etc. in Looker studio. 

Expectations: experience with n8n, API integrations, and Google BigQuery, understanding of ETL processes; experience with the Servio API will be an advantage.