Data Engineer II - Mobile Game Analytics

1w1 week ago

Mattel

El Segundo, US · Full-time · $140,000 – $180,000

About this role

Mattel is hiring a Data Engineer II to own the analytics backbone for our growing mobile free-to-play portfolio. You'll design and operate the pipelines, data models, and quality systems that turn raw telemetry into trustworthy, analyst-ready datasets. Studio teams will make sharper decisions about retention, monetization, and engagement across titles.

This build-while-running role involves keeping existing pipelines healthy while migrating legacy infrastructure onto our partner-managed ETL platform. You'll configure and operate the ETL framework for mobile game telemetry ingestion and transformation. Maintain silver/gold layers in BigQuery using SQL and orchestration tooling with schemas optimized for analytical queries.

Optimize BigQuery performance and cost through partitioning, clustering, materialized views, and query tuning. Design curated data marts as data products with clear owners, documentation, and SLAs to power Mixpanel dashboards. Mattel Game Studios builds digital games inspired by iconic brands, partnering across disciplines and with best-in-class external studios.

Migrate legacy Airflow pipelines without disrupting live reporting and partner with game studios on tracking plans. Build data quality and observability systems to reduce time-to-detect issues. Contribute to team practices like code review and pragmatically apply AI and LLM tooling to accelerate SQL authoring.

Requirements

4+ years as a Data Engineer or Analytics Engineer shipping production data pipelines
Expert SQL and strong Python, with hands-on experience in BigQuery and Airflow / Cloud Composer
Demonstrated expertise in medallion architecture, dimensional modeling and data warehouse optimization
Mobile F2P analytics experience — fluency with event telemetry, player lifecycle metrics, and game economy KPIs
Hands-on working knowledge of GCP-native tooling
Track record of building data quality and observability systems: validation, anomaly detection, SLAs

Responsibilities

Configure and operate the partner-managed ETL framework for mobile game telemetry ingestion and transformation
Maintain silver/gold transformation layers in BigQuery using SQL and orchestration tooling
Optimize BigQuery performance and cost through partitioning, clustering, materialized views, and query tuning
Design curated data marts as data products with clear owners, documentation, and SLAs
Migrate legacy Airflow pipelines to the partner platform without disrupting live reporting
Partner with game studios and Data Analysts on tracking plans defining events, properties, and data contracts
Build data quality and observability systems to reduce time-to-detect and time-to-recover for telemetry issues
Contribute to team engineering practices including code review, documentation, and onboarding

Benefits

Inclusive environment where every team member feels respected, included, and heard
Work with iconic Mattel brands creating high-quality experiences for global audiences
Partner across disciplines and with best-in-class external studios
Creativity-focused culture that values infinite range of ideas and voices