Business Intelligence Analyst (GCP & Tableau)
100% REMOTE
6 Months
Hiring Manager Notes:

• Basically they have a Tableau front end with the data pipe on BigQuery / GCP.
• Someone with Logistics understanding will be a nice to have

 
Role Overview: Supporting the analytics platform across GCP (BigQuery) and Tableau development. Focus is on data pipeline stability, reporting creation and maintenance, and light migration support from legacy systems (Hive/Presto and Tableau). Work is SLA-based, following defined SOPs from onshore teams.
Key Responsibilities:
GCP Data Support (BigQuery)

• Create, maintain, and update tables/datasets in BigQuery
• Support migration of tables from Hive/Presto to GCP
• Convert and validate SQL logic (Hive/Presto → BigQuery)
• Ensure data accuracy and consistency post-migration
• Maintain curated datasets for reporting use

Tableau Reporting & Migration

• Build and maintain Tableau dashboards on BigQuery datasets
• Support migration of dashboards to a new Tableau instance
• Perform validation and regression testing post-migration
• Ensure dashboard accuracy, refresh stability, and performance

Data Ingestion & Stability

• Support automated data ingestion pipelines into GCP
• Monitor scheduled jobs and resolve ingestion failures
• Troubleshoot data issues and coordinate fixes with Data Engineering
• Ensure data availability meets SLA requirements

Production Support

• Handle BAU fixes, data updates, and dashboard changes
• Follow SLA timelines for reporting and migration tasks
• Provide status updates and escalate issues as needed

Required Skills

• 2–5 years in BI / data engineering support roles
• Strong SQL (BigQuery + Hive/Presto exposure preferred)
• Experience with GCP (BigQuery)
• Hands-on Tableau dashboard development & maintenance
• Experience with data validation and reconciliation
• Exposure to data migration projects (preferred)

Preferred Skills

• Experience with Freight & Logistics data
• GTM Business exposure
• Python (basic automation)
• Airflow / workflow orchestration tools
• Tableau migration experience
• Performance tuning in BigQuery

Success Metrics

• Stable and accurate production datasets in GCP
• Successful Hive/Presto → BigQuery migration support
• Smooth Tableau dashboard migration with no regression
• SLA adherence for BAU and migration tasks
• Minimal data defects in reporting outputs

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 45.00/hr.