Senior Data Analyst
Fastly
AWSAzureBigQueryCloudPythonSQLTableau
Senior Data Analyst
Rackspace Technology
full-time
Posted on:
Location Type: Hybrid
Location: California, Colorado, Hawaii, New York, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $143,700 - $245,520 per year
Job Level
Senior
Tech Stack
AirflowBigQueryCloudGoogle Cloud PlatformJavaPythonScalaSQL
About the role
- 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.
Requirements
- 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).
Benefits
- 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.
- 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.
- Information on benefits offered is here.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLBigQueryPythondata analysisdata manipulationtime series analysisanomaly detectiondata validationdata quality assessmentdata comparison
Soft skills
analytical skillscollaborationproblem-solving
Certifications
Bachelor’s degree in computer science
