Remote Data Mining And Management Job In Data Science And Analytics

Simple SQL transformation

Find more Data Mining And Management remote jobs posted recently Worldwide

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.
About the recuiter
Member since Mar 14, 2020
Vaibhav Singh
from Madhya Pradesh, India

Skills & Expertise Required

BigQuery Database Design MySQL Programming sql Database Architecture

Candidate shortlisted and hiredHiring open till - Apr 22, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$19.16

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Directory App for Startup Must link with Website - Fixed
Graphic Design: Hot Air Balloon Marketing Flyer - Fixed
Looking for SEO for my own Website - Hourly
Implementing CPANEL/Plesk - Hourly
LINUX/Docker Regular Support Tasks - Hourly
Need a Xamarin Android and IOS Developer - Fixed
Excel Data Visualization - Survey results - Fixed
Continue work on PDF parser - original project solution provided. - Fixed
IT Security - Website Penetration/Security Test - Hourly
Infographic Design NEEDED - Fixed
Provisional Patent Preparation Guidance - Fixed
Forensic Accountant needed to evaluate and calculate damages for breach of contract action - Hourly
Brand Building / Logo Design - Fixed

Similar Projects

Developer needed for customizations on a Yii PHP framework application

A freelancer or a team of freelancers are needed to work on an ongoing live web application that is built in Yii php framework and is being used. The applications requires additional changes/ enhancements. The freelancer should be able to take a trai...read more

BigQuery Expert Needed for API Data Extraction

We are looking to build a workflow that allows a few (very similar) recurring API calls to be made on a regular basis, and house the data contained in the payloads in BigQuery.

From there, we are hoping to connect the BigQuery data with Goog...read more

Web Application Architecture with cloud CRM integration

Deliverable is to create a design document with following content.

Solution Architecture for an could (AWS or Azure) web application with:
- SQL backend with user data is master
- API for web fronted (webiste)
- API for CRM and 3...read more

Erwin tool

Erwin data modeler, SQL queries, skills on oracle developer, and skills on SQL server studio.
At least 7 years of experience

MySQL Optimization

Hello,
We have an online shop that uses the salesrule table to store salesrules (discounts). A salesrule can be applied automatically or with a coupon code (salesrule_coupon). It can be assigned to one or more websites (core_website, relation ta...read more