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
We are seeking an experienced data analyst to estimate the number of employed workers (excluding tipped occupations) in a major U.S. urban area who would be affected by a potential increase in the minimum wage above its current level. The results will inform a policy re...
View JobTraining and analysis services only in Data analysis courses,I want the logo with :HS: letter only and add a Symbol for Line chart and column Chart in the logo to indicate that we are for data analysis only .Category: Design & MultimediaSubcategory: Logo designWhat ...
View Job