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
Sandya Engka
from Michoacan, Mexico

Skills & Expertise Required

BigQuery Database Design MySQL Programming sql Database Architecture

Open for hiringApply before - Jul 29, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$19.17

Cost

Offer to work on this project closes in 25 days!
Are you interested in this Opportunity?

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

App Developers are needed for creating an app for andriod and ios - Fixed
Experienced 3D Jewelry Designer - Fixed
Microsoft Word Office 365 subscription sharing - Fixed
window server 2012 / IIS administrator - Hourly
Fix my app VPN is not working - Hourly
A DBA needed to clear a part of MongoDB database - Hourly
UI / UX designer with experience in mobile and web app protityping - Hourly
ZOHO CRM Blueprint - Fixed
Digital Ocean Server Administator - Fixed
Activate Mobile (Preferably California Based) - Fixed
Urgent Phone Support Requirement! - Hourly
Need Logo Designed ASAP - Fixed
Crawling a website for information - Hourly
Wordpress Website Lead Generation Website - Fixed

Similar Projects

Moodle BigBlueButton Record Video Download Module

I would like to have a module for Moodle BigBlueButton module, which will download the saved lessons to the computer. The existing BigBlueButton module only allows you to preview recordings and download the webcam. However, I want to download the ent...read more

php based application

Looking to hire someone to build a custom web based application that will do the following:

-Formatted into template
-Print ready from said template
-Re-Editable fields, easly clearable

So this is what is trying to be accomp...read more

Quality Database

Looking for a C# programmer to create a new database for our manufacturing company that wikk utilize quite a few forms, tables, and foldout-end interaction with the shop floor people. This is a longer-term project that will require Skype meetings nor...read more

Python SQL debugging

Im looking for someone to help me with python and SQL. If you know PySpark, that is a plus. This would be in person somewhere in the Des Moines area. A couple of hours a week.

R Developer

Im a data scientist and Im looking for an R developer (not an analyst or statistician).

You can write clear and efficient R code, you have experience with the tidyverse (primarily dplyr and purrr), and you know your way around relational d...read more