Supporting one of Rackspace's premiere clients on a cloud migration, on-prem into GCP, project by navigating large datasets, building robust queries, and identifying inconsistencies with precision and insight.
Requirements
- 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.
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.
- Perform side-by-side comparisons of data across systems to ensure consistency during and after migrations.
Other
- If located near a Rackspace office, you’ll work a hybrid schedule… 2 days in the office and three days remote.
- If not located near an office, you may work 100% remotely.
- 5% annual travel.
- Bachelor’s degree in computer science or a related field.
- Familiarity with Airflow (Cloud Composer).
