GCP Data Analyst - BigQuery

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

Job Summary

Job Description

We are seeking a GCP Data Analyst with expertise in BigQuery, SQL, and Python to support data validation and analytics. The role involves navigating large datasets, building queries, and identifying inconsistencies. Responsibilities include validating metrics during system migrations, supporting day-to-day data analysis, and reporting. You will leverage advanced BigQuery features, Python for data manipulation, and understand data engineering fundamentals. Collaboration with engineering teams is expected, with basic ability to read Java or Scala code. Familiarity with Airflow (Composer) is beneficial. The role requires a Bachelor's degree in a related field and strong analytical and communication skills.
Must have:
  • Proficiency in SQL, BigQuery, and Python
  • Advanced SQL skills for data validation
  • Experience comparing datasets across systems
  • Ability to identify and investigate data discrepancies
  • Strong analytical intuition
  • Perform side-by-side metric comparisons
  • Skilled in root cause analysis
  • Effective communication of findings
  • 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
  • Basic 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
The following information is required by pay transparency legislation in the following states: CA, CO, HI, NY, and WA. This information applies only to individuals working in these states.
 
·       The anticipated starting pay range for Colorado is: $ 143,700 - $ 210,760
·       The anticipated starting pay range for the states of Hawaii and New York (not including NYC) is: $ 153,000 - $ 224,400
·       The anticipated starting pay range for California, New York City and Washington is: $ 167,400 - $ 245,520
 
Unless already included in the posted pay range and based on eligibility, the role may include variable compensation in the form of bonus, commissions, or other discretionary payments. These discretionary payments are based on company and/or individual performance and may change at any time. Actual compensation is influenced by a wide array of factors including but not limited to skill set, level of experience, licenses and certifications, and specific work location. Information on benefits offered is here.

#LI-VM1
#LI-Hybrid

About Rackspace Technology
We are the multicloud solutions experts. We combine our expertise with the world’s leading technologies — across applications, data and security — to deliver end-to-end solutions. We have a proven record of advising customers based on their business challenges, designing solutions that scale, building and managing those solutions, and optimizing returns into the future. Named a best place to work, year after year according to Fortune, Forbes and Glassdoor, we attract and develop world-class talent. Join us on our mission to embrace technology, empower customers and deliver the future.
 
 
More on Rackspace Technology
Though we’re all different, Rackers thrive through our connection to a central goal: to be a valued member of a winning team on an inspiring mission. We bring our whole selves to work every day. And we embrace the notion that unique perspectives fuel innovation and enable us to best serve our customers and communities around the globe. We welcome you to apply today and want you to know that we are committed to offering equal employment opportunity without regard to age, color, disability, gender reassignment or identity or expression, genetic information, marital or civil partner status, pregnancy or maternity status, military or veteran status, nationality, ethnic or national origin, race, religion or belief, sexual orientation, or any legally protected characteristic. If you have a disability or special need that requires accommodation, please let us know.

Similar Jobs

PwC - Manager - Talent Acquisition

PwC

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
9 Months ago
Wrike - Lead Solutions Consultant (German)

Wrike

Ireland (Remote)
1 Month ago
London stock Exchange - Senior Data Science Cloud Engineer

London stock Exchange

St. Louis, Missouri, United States (On-Site)
2 Months ago
Saxo Bank - Client Service - Business Analyst

Saxo Bank

Gurugram, Haryana, India (On-Site)
1 Week ago
Tencent - Software Engineering Associate

Tencent

(On-Site)
7 Months ago
Riot Games - Business Systems Analyst II, Finance Technology

Riot Games

Los Angeles, California, United States (On-Site)
1 Month ago
Apple - Software Data Engineer

Apple

Seattle, Washington, United States (On-Site)
1 Month ago
HCL Tech - Data scientist

HCL Tech

California, United States (On-Site)
3 Months ago
Epic Games - Senior Data Scientist

Epic Games

Cary, North Carolina, United States (On-Site)
5 Months ago
HP - Supply Chain Data Scientist

HP

Spring, Texas, United States (On-Site)
2 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Sleeper - Production Engineer

Sleeper

United States (Remote)
2 Months ago
PwC - IT Audit Associate

PwC

Makati City, Metro Manila, Philippines (On-Site)
10 Months ago
Palo Alto Networks - Consulting Director - Security Operations - Proactive Services (Unit 42)

Palo Alto Networks

Netherlands (Remote)
2 Months ago
CookUnity - Director of Total Rewards

CookUnity

New York, United States (On-Site)
1 Week ago
broadcom - Memory Circuit Design Engineer

broadcom

Mendota Heights, Minnesota, United States (On-Site)
1 Month ago
Lilith games - Numerical Planner - Matching Direction (Far Light 84)

Lilith games

Shanghai, China (On-Site)
1 Week ago
Nice - Contact Centre Operations

Nice

Pune, Maharashtra, India (Hybrid)
1 Week ago
Precisly - Data Governance Solutions

Precisly

Munich, Bavaria, Germany (On-Site)
1 Month ago
Diligent Corporation - Senior Product Manager (AI & Due Diligence)

Diligent Corporation

Bengaluru, Karnataka, India (Hybrid)
1 Month ago
PwC - Public Sector Associates

PwC

Athens, Greece (Hybrid)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in San Antonio, Texas, United States

Inkittt - Improv Comedian/Host

Inkittt

San Francisco, California, United States (On-Site)
11 Months ago
Intel  - Contract Reverse Logistics Program Manager

Intel

Phoenix, Arizona, United States (On-Site)
1 Week ago
Toast - Consolidation & International Accounting Manager

Toast

United States (Remote)
1 Month ago
Apple - Health Sensing - Sensing Hardware Prototyping Engineer

Apple

Cupertino, California, United States (On-Site)
1 Month ago
zoox - Software Development Engineer in Test, Product Software - Operational Tools

zoox

Foster City, California, United States (Hybrid)
1 Week ago
Condé Nast - Global Director of Editorial Operations & Strategy

Condé Nast

New York, United States (On-Site)
3 Weeks ago
CD PROJEKT RED - Senior Human Resources Business Partner

CD PROJEKT RED

Boston, Massachusetts, United States (Hybrid)
1 Month ago
lifechruh - HRIS Specialist

lifechruh

Edmond, Oklahoma, United States (On-Site)
9 Months ago
CyberArk - Staff Site Reliability Engineer

CyberArk

United States (On-Site)
2 Months ago
bytedance - Network Engineer, Edge Networking

bytedance

San Jose, California, United States (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

Data Analysis Jobs

Ion - Senior Data Engineer

Ion

Budapest, Hungary (On-Site)
6 Months ago
Cadence - SAP SD/RAR Staff Business Systems Analyst

Cadence

San Jose, California, United States (On-Site)
3 Months ago
Reddit - Senior Data Science Manager, Ads Marketplace

Reddit

United States (Remote)
2 Months ago
Rippling - Senior Software Engineer - Data Bridge

Rippling

San Francisco, California, United States (On-Site)
3 Months ago
Luxoft - Data Engineer (financial/investment domain)

Luxoft

Singapore, Singapore (On-Site)
8 Months ago
Cadence - Sr Staff Business Systems Analyst

Cadence

San Jose, California, United States (On-Site)
10 Months ago
Autodesk - Principal Security Analyst

Autodesk

Arizona, United States (Remote)
1 Week ago
Temporal Technologies - Staff Software Engineer - Cloud Data Storage

Temporal Technologies

United States (Remote)
1 Month ago
Luxoft - Senior Data Ops Engineer

Luxoft

(Remote)
8 Months ago
Apple - Cellular Data Science & Machine Learning Engineer

Apple

San Diego, California, United States (On-Site)
2 Months ago

Get notifed when new similar jobs are uploaded