Need help with streaming data back and forth between firestore and bigquery, And build dashboards using Google Looker Studio

We are building an inventory management platform. Firestore is our database. Due to its limitation with regard to sum aggregation, we are streaming the data to Bigquery. Currently, we are seeking a competent engineer who could steam the data back and forth between firestore and bigquery, and also help us build dashboards in Google Looker Studio.

Deliverables
Refine our data modelling on Firestore
Stream data from Bigquery to Firestore
Build dashboards using Google Looker Studio and Bigquery