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.
- Collaborate with engineering teams to understand data pipelines.
- Perform side-by-side comparisons of data across systems to ensure consistency during and after migrations.
- Use 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.
Qualifications:
- Bachelor’s degree in computer science or a related field.
- 5+ years’ experience in data analyst or analytics engineering roles with strong BigQuery, SQL, and Python skills.
- 5+ years’ 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.
- Able to understand Java or Scala code.
- Familiarity with Airflow (Cloud Composer).
Similar Jobs
What We Do
At Rackspace Technology, we accelerate the value of the cloud during every phase of digital transformation. By managing apps, data, security and multiple clouds, we are the best choice to help customers get to the cloud, innovate with new technologies and maximize their IT investments. As a recognized Gartner Magic Quadrant leader, we are uniquely positioned to close the gap between the complex reality of today and the promise of tomorrow. Passionate about customer success, we provide unbiased expertise, based on proven results, across all the leading technologies. And across every interaction worldwide, we deliver Fanatical Experience TM — the best customer service experience in the industry. Rackspace has been honored by Fortune, Forbes, Glassdoor and others as one of the best places to work.