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.19

Cost

Offer to work on this project closes in 69 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
Unity Game Developer Required - Hourly
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
Need a translator English to Chinese Simplified - Hourly
Activate Mobile (Preferably California Based) - Fixed
SQL Query assistance needed ASAP. - Hourly
Urgent Phone Support Requirement! - Hourly
Need Logo Designed ASAP - Fixed
Adwords & Adroll optimization PPC - Hourly
Google Maps Custom Integration - Hourly
UiPath Studio to Azure Repos Connect - Fixed

Similar Projects

SAGE 100 - SUITECRM INTERGRATION

NEED SOMEONE WHO HAS INTEGRATED SAGE 100 ON-PREMISE WITH SUITECRM. GIVE ME A QUOTE TO INTEGRATE THE TWO.

Need MSBI developers

Hi,
I need MSBI developers who are good at SSIS, SSRS and SSAS for an ongoing project

Full-stack Java developer required for code review and some features

We are looking for a developer that has strong analytical skills and can quickly review some code for us.

We need to improve latency in the DB Layer, expert knowledge required, and 5+ years of Hibernate.

Experience required:
...read more

Developer for MicroStrategy Reports needed

Supporting the team with building reports in MicroStrategy incl. setting up DWH, schemas, etc.
Databases are running on AWS, MicroStrategy Server is running with Linux on AWS

Experience with the energy market or timeseries would be goo...read more

Zoho Analytics Developper

I am looking for a freelancer who can create a cash budget report in Zoho analytics.

The report must use the actual data from zoho finance to start the cash budget then make a projection base on some assumptions.

I want to be able t...read more

Submit A Proposal