Business Intelligence Analyst (GCP & Tableau)

System One is a leader in delivering outsourced services and workforce solutions across North America. They are seeking a Business Intelligence Analyst to support an analytics platform on Google Cloud Platform and Tableau, focusing on data stability, dashboard maintenance, and migration support from legacy SQL platforms.

Responsibilities:

• Create, maintain, and update BigQuery tables and datasets
• Support table migrations from legacy platforms into BigQuery
• Convert and validate SQL logic (legacy SQL ? BigQuery)
• Perform data validation/reconciliation to ensure accuracy post-migration
• Build and maintain Tableau dashboards on BigQuery datasets
• Support migration of dashboards to a new Tableau instance
• Execute regression testing/validation and resolve discrepancies
• Ensure refresh stability, accuracy, and performance
• Monitor scheduled ingestion jobs; troubleshoot and resolve failures
• Partner with Data Engineering to address pipeline/data issues
• Handle BAU reporting fixes, data updates, and dashboard changes
• Provide clear status updates and escalate risks as needed

Requirements:

• 2–5 years in BI, analytics, or data engineering support
• Strong SQL (BigQuery required; Hive/Presto exposure is a plus)
• Hands-on BigQuery (GCP) experience
• Hands-on Tableau dashboard development and support
• Experience with data validation / reconciliation in production reporting
• Tableau migration experience
• Workflow orchestration exposure (e.g., Airflow)
• Basic Python for automation
• BigQuery performance tuning
• Experience with logistics/freight or go-to-market (GTM) analytics domains