BigQuery Specialist - Automate CSV Transfer to Google Cloud Storage for BigQuery Integration

$100.00
Fixed price

Description: We are looking for an engineer to set up an automated workflow that transfers NetSuite-generated CSV reports (sent via email) into Google Cloud Storage, where they will then be ingested into BigQuery for reporting and analysis. NetSuite is configured to email CSV reports 3 times a day. Your task is to set up a seamless integration where these files are: Saved automatically to a Google Drive or Google Cloud Storage (GCS) folder Ingested into BigQuery via external tables or scheduled loads RESPONSIBILITIES: Extract the attached CSV file and upload it to a designated GCS bucket Create a scheduled ingestion or external table setup in BigQuery Ensure the process runs 3x daily with minimal latency DELIVERABLES: A fully functional integration that runs automatically 3x per day Documentation on how the system works and how to modify it (e.g., change folders or email filters)

Keyword: Data Analysis

Price: $100.0

BigQuery Google Cloud Platform ETL Pipeline Python

I want to apply

AI Engineer with Advanced Expertise Needed

We are seeking an experienced AI Engineer to join our team. The ideal candidate will have a high level of expertise in developing and implementing machine learning models and AI algorithms. If you have a strong background in AI technologies (know how to simply by settin...

View Job

Data Analyst Needed for Google Ads & CRM data import into BigQuery + Looker Dashboard

We are seeking an experienced data analyst to set up a seamless data flow that imports Google Ads and CRM system data into BigQuery for our business. You will also need to create a simple Looker dashboard to visualize and analyze the imported data effectively. Your expe...

View Job

Power BI - Data visualization expert needed to create interactive dashboards, charts, graphs

We are looking for a Power BI Data Analyst to support us in creating and refining interactive dashboards, charts, and reports. Familiarity with Supply Chain or Manufacturing data is a big plus. Needs: Design and build new dashboards and visuals in Power BI Audit existin...

View Job