Business Intelligence Analyst

Analyst, Business Intelligence (GCP & Tableau Support)

Role Overview

Offshore execution role supporting the analytics platform across GCP (BigQuery) and Tableau development. Focus is on data pipeline stability, reporting creation and maintenance, and migration support from legacy systems (Hive/Presto and Tableau). Work is SLA-based, following defined SOPs from onshore teams.

Key Responsibilities

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

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

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

4. 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 skills (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

Why This Role Matters

This role ensures stable production reporting and smooth migration from legacy systems to GCP and Tableau, enabling reliable analytics delivery for business teams.