Data Engineer II, Mobile Game Analytics at MattelInc

The Opportunity:  We’re 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 — so studio teams can make sharper decisions about retention, monetization, and engagement across titles. This is a build-while-running role: you’ll keep existing pipelines healthy, migrate legacy infrastructure onto our partner-managed ETL platform, and stand up new capabilities alongside it.  What Your Impact Will Be:    Run & Optimize – Live Data ETL Framework  • 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, applying 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 — that power Mixpanel dashboards and enable analysts to self-serve on retention, monetization, and engagement metrics  Migrate & Extend  • Migrate legacy Airflow pipelines to the partner platform for existing and licensed titles without disrupting live reporting  • Partner with game studios and Data Analysts on tracking plans — defining events, properties, validation rules, and data contracts that keep downstream consumers insulated from upstream change  • Build data quality and observability systems that reduce time-to-detect and time-to-recover for telemetry issues before they reach reporting  • Contribute to team engineering practices — code review, documentation standards, onboarding — and pragmatically apply AI and LLM tooling to accelerate SQL authoring, validation, and documentation