GCP Data Analyst - BigQuery (USA) at Cprime
Job Description
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.
Requirements
- 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.
- 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.