GCP Data Analyst - BigQuery

1 Month ago • 5-5 Years • Data Analysis • $143,700 PA - $245,520 PA

Job Summary

Job Description

We are looking for a GCP Data Analyst with extensive experience in BigQuery, SQL, and Python. The role involves supporting data validation and ongoing analytics, navigating large datasets, and building robust queries. Responsibilities include validating metrics during system migrations, supporting daily data analysis, and utilizing advanced BigQuery features like authorized views, materialized views, UDFs, partitioning, and time series analysis. Python proficiency is essential for data manipulation and anomaly detection. A good understanding of data engineering fundamentals and GCP infrastructure is important, along with the ability to read Java or Scala code. Familiarity with Airflow (Composer) is beneficial. The analyst will write and optimize complex SQL queries, analyze large datasets for quality and trends, use Python for analysis, and collaborate with engineering teams. This role requires strong analytical skills and clear communication with stakeholders.
Must have:
  • Proficiency in SQL, BigQuery, and Python
  • Advanced SQL skills in BigQuery
  • Experience comparing datasets across systems
  • Proven ability to identify data discrepancies
  • Strong analytical intuition
  • Perform side-by-side metric comparisons
  • Skilled in root cause analysis
  • Effective communicator
  • Familiarity with time series analysis
  • Ability to follow validation processes
Good to have:
  • Familiarity with Looker or other BI tools
  • BigQuery ML and Vertex AI
  • Familiarity with Oozie or Pig

Job Details

About the Role

We’re seeking a GCP Data Analyst with deep expertise in BigQuery, strong SQL and Python skills, and a sharp analytical mindset to support both data validation initiatives and ongoing analytics work. This role is ideal for someone who can navigate large datasets, build robust queries, and identify inconsistencies with precision and insight.

The analyst will work across a variety of data workflows, from validating metrics during system migrations to supporting day-to-day data analysis and reporting needs. You’ll leverage advanced BigQuery features—such as authorized views, materialized views, UDFs, partitioning strategies, and time series analysis—to ensure data integrity and surface meaningful insights. Comfort working in Python with data frames and relevant packages is also essential, particularly for tasks involving data manipulation, anomaly detection, or prototyping workflows.

A solid understanding of data engineering fundamentals and GCP infrastructure is important, as is the ability to read and interpret code in Java or Scala when collaborating with engineering teammates. Familiarity with Airflow (Composer) will help you understand orchestration logic, though this won’t be a core responsibility. Experience with BigQuery ML, anomaly detection frameworks, or Vertex AI is a plus.

Key Responsibilities:-
  • Write, optimize, and execute complex SQL queries in BigQuery to validate data accuracy, identify inconsistencies, and support analytics and reporting.
  • Analyze large datasets to assess data quality, compare trends across systems, and surface anomalies or unexpected behaviors.
  • Utilize advanced BigQuery features such as authorized views, materialized views, UDFs, partitioned tables, and joins to support scalable, high-performance analysis.
  • Use Python (including data frames and relevant libraries) for exploratory analysis, data manipulation, and supporting validation workflows.
  • Support time series analysis and, where applicable, anomaly detection using SQL or Python-based approaches.
  • Assist with load/transform validation to ensure reliability and accuracy in data pipelines.
  • Collaborate with engineering teams to understand data pipelines, with basic ability to read and interpret Java or Scala code when needed.
  • Perform side-by-side comparisons of data across systems to ensure consistency during and after migrations.
  • Maintain basic familiarity with orchestration tools such as Airflow (Composer) to follow pipeline logic and collaborate effectively with engineering.
  • Work within the GCP environment, leveraging cloud tools and services to support analysis, troubleshoot issues, and navigate cloud-based workflows.
  • Clearly communicate analytical findings and data quality issues to cross-functional stakeholders to support decision-making.

Qualifications:-
  • Bachelor’s degree in Computer Science, Data Science, Engineering, or a related field.
  • 5+ years of experience in data analyst or analytics engineering roles with strong BigQuery, SQL, and Python skills.
  • 5+ years of experience building and operating solutions on Google Cloud Platform (GCP).
  • Strong ability to write and optimize SQL queries to validate data, analyze trends, and detect inconsistencies.
  • Proficient in Python, including use of data frames and common analytical libraries.
  • Experience with advanced BigQuery features such as authorized views, materialized views, UDFs, partitions, and time series analysis.
  • Strong analytical skills and experience validating data across systems during migrations and ongoing operations.
  • Basic ability to read and understand Java or Scala code to support engineering collaboration.
  • Familiarity with Airflow (Cloud Composer) to interpret and trace data pipeline workflows.

Nice to have:-
  • Familiarity with Looker or other BI tools for metric validation and reporting support.
  • BigQuery ML and Vertex AI
  • Basic familiarity with legacy systems such as Oozie or Pig for reading existing scripts.

Must have's:-
  • Proficiency in SQL, BigQuery, and Python
  • Advanced SQL skills in BigQuery for complex data validation, anomaly detection, and trend analysis.
  • Experience comparing datasets across systems
  • Proven ability to identify and investigate data discrepancies across platforms.
  • Strong analytical intuition to sense-check metrics and flag issues that may not trigger formal alerts.
  • Ability to perform side-by-side metric and trend comparisons to confirm post-migration accuracy.
  • Skilled in root cause analysis using SQL, domain expertise, and supporting context.
  • Effective communicator who can document findings and share insights with both technical and non-technical stakeholders.
  • Familiarity with time series analysis to detect unexpected shifts, drops, or spikes in metrics.
  • Ability to follow structured validation processes while proactively identifying workflow improvements.

Travel:-
  • As per business requirements


Similar Jobs

beghou consulting - Consultant

beghou consulting

Boston, Massachusetts, United States (Hybrid)
3 Months ago
Internet Brands - Marketing Associate

Internet Brands

El Segundo, California, United States (On-Site)
1 Month ago
Absurd Ventures - Lead Engineer, AI

Absurd Ventures

Santa Monica, California, United States (On-Site)
1 Week ago
Sprinkler - Senior Managed Services Consultant CCaaS

Sprinkler

Philippines (On-Site)
2 Months ago
Marvell - Senior Engineer, Analog Layout

Marvell

Santa Clara, California, United States (On-Site)
1 Month ago
Nagarro - Senior Staff Consultant, Business Analyst

Nagarro

New York, New York, United States (On-Site)
9 Months ago
dun bradstreet - Senior Data Analyst

dun bradstreet

Helsinki, Uusimaa, Finland (Hybrid)
3 Months ago
Tellius - QA Data Analyst

Tellius

Bengaluru, Karnataka, India (On-Site)
3 Weeks ago
Kyruus Health - Senior Data Architect

Kyruus Health

United States (Remote)
3 Months ago
CrazyLabs - Data Engineer

CrazyLabs

Tel Aviv-Yafo, Tel Aviv District, Israel (On-Site)
1 Week ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

ComeOn Group - Responsible Gaming Analyst - Scandinavian, Nordic or Dutch Speaking

ComeOn Group

St. Julian's, Malta (Hybrid)
1 Month ago
Riot Games - Manager, Competitive Operations

Riot Games

Los Angeles, California, United States (On-Site)
4 Months ago
welevel  - Head of Operations

welevel

Munich, Bavaria, Germany (On-Site)
5 Months ago
Decagon - Technical Recruiter

Decagon

New York, New York, United States (On-Site)
1 Month ago
Fashionphile - General Manager, Flagship

Fashionphile

Los Angeles, California, United States (On-Site)
1 Week ago
Lionbridge Games - Tester

Lionbridge Games

Mexico City, Mexico (On-Site)
2 Months ago
codeninja  - Talent Acquisition Associate

codeninja

Riyadh, Riyadh Province, Saudi Arabia (On-Site)
2 Weeks ago
Microsoft - Executive Business Administrator

Microsoft

Mountain View, California, United States (Hybrid)
3 Months ago
SBM Management - Controller, Real Estate

SBM Management

Sacramento, California, United States (On-Site)
5 Months ago
Zelis  - Senior DevOps Engineer

Zelis

Hyderabad, Telangana, India (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Jobs in Toronto, Ontario, Canada

Activate Games - Digital Marketing Leader

Activate Games

Toronto, Ontario, Canada (Hybrid)
3 Weeks ago
virtual machine - ACT: Advanced Coxswain Training Program (Fast Rescue Boat)

virtual machine

Paradise, Newfoundland And Labrador, Canada (On-Site)
1 Month ago
Epic Games - Senior Gameplay AI Programmer, UEFN

Epic Games

Montreal, Quebec, Canada (On-Site)
3 Months ago
2K - Principal Product Manager

2K

Montréal, Québec, Canada (On-Site)
2 Months ago
BKOM Studios - Senior Unreal Developer

BKOM Studios

Québec City, Quebec, Canada (Remote)
2 Months ago
Cineplex - Full Stack Software Developer

Cineplex

Toronto, Ontario, Canada (Remote)
3 Weeks ago
Critical mass - Freelance Product Designer

Critical mass

Calgary, Alberta, Canada (On-Site)
1 Month ago
Unity - Gestionnaire de Programme Technique Senior/Senior Technical Program Manager

Unity

Montreal, Quebec, Canada (On-Site)
1 Week ago
Puzzle Cats - Software Developer Intern

Puzzle Cats

Toronto, Ontario, Canada (On-Site)
11 Months ago
Scanline VFX - Lead Software Engineer (Production Tools)

Scanline VFX

Vancouver, British Columbia, Canada (Remote)
9 Months ago

Get notifed when new similar jobs are uploaded

Data Analysis Jobs

Apple - Data Analyst - SWE Infrastructure

Apple

Cupertino, California, United States (On-Site)
2 Months ago
Ciklum - Senior Data Scientist

Ciklum

Chennai, Tamil Nadu, India (Hybrid)
9 Months ago
DraftKings - Lead Data Science Engineer, Sportsbook

DraftKings

Boston, Massachusetts, United States (On-Site)
1 Year ago
Apple - Senior Software Engineer - Data Cloud

Apple

San Diego, California, United States (On-Site)
3 Months ago
PwC - Senior Financial Data Analyst  | Deals (M&A) | Lyon | CDI | H/F

PwC

Lyon, Auvergne-Rhône-Alpes, France (On-Site)
10 Months ago
Moonvalley - ML Data Engineer

Moonvalley

United Kingdom (Remote)
2 Weeks ago
ISS Stoxx - Data Quality Analyst

ISS Stoxx

Mumbai, Maharashtra, India (On-Site)
1 Month ago
Rackspace Technology - Customer Data Engineer II

Rackspace Technology

India (Remote)
3 Months ago
Zinnia - Senior Data Scientist

Zinnia

Gurugram, Haryana, India (On-Site)
1 Month ago
Gupta Media - Marketing Data Analyst II

Gupta Media

Boston, Massachusetts, United States (On-Site)
3 Months ago

Get notifed when new similar jobs are uploaded