SQL Developer for Shopify API to BigQuery Data Conversion

Job ID: 38304714

Budget: $10 – $30 USD

I'm looking for a skilled SQL developer with specific experience in converting data from Shopify's API to Google Cloud Storage (GCS) for querying in BigQuery.

Key requirements include:
- Converting Shopify's API data to BigQuery.
- Extracting following data:
1. Daily orders, revenue, and discounts.
2. SKU-wise sales, revenue, inventory, and Days on Hand (DOH).

Additional details:
- Data has already been imported to GCS.
- The final reports should be formatted in BigQuery tables.
- The goal is to analyze both historical and ongoing/new data.

Ideal candidates for this project would have:
- Profound expertise in SQL.
- Prior experience with Shopify's API.
- Proven track record of working with BigQuery.
- Understand the retail/e-commerce domain, particularly SKU management.
Related categories: Python SQL