GCP Data Analyst - BigQuery (USA)

Category: Data Analysis

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.

Requirements

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

Preferred Qualifications (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-Haves

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

Salary Range (for specified states)

• Colorado: $143,700 - $210,760
• Hawaii and New York (not including NYC): $153,000 - $224,400
• California, New York City, and Washington: $167,400 - $245,520

About the Company

Rackspace Technology is the multicloud solutions expert. 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.