Google Sheets Consultant

Hello and thank you for reviewing this job posting!

We are looking for a google sheets consultant to help with a project.

Background:
We are pulling all order, order detail, customer, and product data via API from our operations system and appending several tabs in a google sheet.

Currently, we are in the process of creating the tables required to populate Google Data Studio.

Where we need help is in creating the queries to consolidate data into meaningful "working tables".

For example:

Order table contains most of the order detail
Order Detail table contains each line item within the order
Product table has some product information
Product Detail table has the balance of the data

One challenge we have is to create a meaningful full summary table from which to use in creating Google Data Studio visualizations

If you have worked with POS order information and consolidated it for reporting, that is a great asset.


As such, proficient skills in the following are required:
* Google Sheets Data Query
* Google Sheets Formula Writing

In addition, it would be nice to have:
* Google Data Studio
* Google BigQuery for phase 2 of the project
* Google Analytics as we are using this to report additional information

Please submit examples of your work when you apply.

The immediate requirement is for someone to help finish the data ---------- om there, the ideal candidate will take on more of the data query development and then migrate into helping with additional data analysis. Ideally, then help with Google Data Studio setup and implementation.

The ideal candidate would transition from a freelance position into a part-time role as we continue to roll out this project and take it to market for other ---------- pensation will be $10 USD / Hour but negotiable based on experience and skill As such, assuming things work out, we could be looking at maybe between $600 - $1500 / month depending on how many hours we require.

Additional information:
We are based near Toronto Canada and I have worked remotely for the past 15 years.
I have also worked with remote international team members and we use slack, zoom, and asana to manage our projects.
Our time zone is EST, the same as New York, and would prefer that we have a 2-hour overlap when we can meet to discuss tasks, issues, etc.

Please let me know if you have any questions.

I look forward to reviewing your application.