Required BigQuery,Database Design,MySQL Programming,sql,Database Architecture freelancer for Simple SQL transformation job

Background:

We have sensors installed on production lines that produce snacks. We are counting snack packages in 10 second increments. We save this data to DWH in Bigquery.

Goal:

Write SQL code that aggregates production data into daily units and calculates the following metrics:
1. Work time (in minutes)
2. Idle time (in minutes)
3. First start (the very first Work Start in the production day)
4. Last end (the very last End Work in the production day)

I will share a detailed job description with shortlisted candidates.

Skills & Expertise Required

BigQuery Database Design MySQL Programming sql Database Architecture