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
Patricia Herdma
from Georgia, United States

Skills & Expertise Required

BigQuery Database Design MySQL Programming sql Database Architecture 
Open for hiringApply before - Aug 22, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$19.06

Cost

Offer to work on this project closes in 14 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

Graphic designer to create visuals for Mobile app - Fixed
MAG STB - Fixed
Admin assistant to help with scheduling - Hourly
R Data Analysis and Writing Job - Hourly
Forex trading simulation using Excel Modeling - Hourly
Sr. MS SQL Server DBA / SQL Server Expert (On-going) - Hourly
Full stack developer for .Net - Hourly
Soncwall/DNS Support - Hourly
New Perfex CRM Module development - Hourly
Experienced councel on hyper secure crypto custody infrastructure for an emerging crypto exchange - Hourly

Similar Projects

In need of a full stack developer

Need a front and back end developer who can code my sports page. I would like the sports page to be similar to ESPN, yahoo sports, etc.

I lost access and all files from my last page and I will rebuild with time, to start I am only concerned...read more

restaurant pos from a to z

built-from-scratch restaurant point-of-sale platform with software, hardware (optional), and payments that streamlines the restaurant operation.

(it would be perfect if u already developed a pos before)

Software developer

Looking for senior engineer with cloud infrastructure background. We will discuss remaining details with shortlisted freelancers only.

Django Developer / Latam & Caribbean

If youre a rockstar Django Developer, passionate about e-commerce & technology who would like to work in a start-up environment and grow exponentially, read on!

Who Are We?

At Trafilea, we perform life changing eCommerce. Were a L...read more

Submit A Proposal