Objective
The client required remote support to create and execute BigQuery scripts that could be easily used by their on-site data engineering team. Due to access restrictions, the offshore support team couldn’t be granted direct edit access to the BigQuery environment.

Approach
Our team:
1. Requested read-only access to BigQuery tables and views.
2. Developed sample SQL queries based on the available schema and shared them with the on-site engineering team for execution.
3. Conducted a training session and live walkthrough of the BigQuery console to upskill the on-site data team.

Solution Overview
The approach ensured effective remote collaboration without compromising data security or access controls.
The shared queries were structured for quick execution, enabling the client’s team to scale similar data pulls across multiple properties.Business Impact
• Delivery timelines were met, ensuring smooth project continuity. • The on-site team reused the BigQuery templates across other lines of business, increasing internal efficiency and reducing turnaround time.