Rackspace-posted 3 months ago
$143,700 - $245,520/Yr
1,001-5,000 employees

We’re seeking a highly skilled and experienced Data Analyst to join our dynamic team supporting one of our premiere clients on a cloud migration, on-prem into GCP, project. You’ll become part of a team of cloud experts supporting one of the world’s largest email providers. You’ll be navigating large datasets, building robust queries, and identifying inconsistencies with precision and insight.

  • 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.
  • 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).
  • Variable compensation in the form of bonus, commissions, or other discretionary payments based on company and/or individual performance.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service