Data Engineer II, Mobile Game Analytics

Job title: Data Engineer II, Mobile Game Analytics

About the Role Data Engineer II to own the analytics backbone for Mattel's 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 You'll Do

• Run & Optimize the 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; optimize performance via partitioning, clustering, materialized views, and query tuning; design data marts powering Mixpanel dashboards and enabling 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 to insulate downstream consumers from upstream changes
• 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/LLM tooling to accelerate SQL authoring, validation, and documentation
• Design curated data marts as data products with clear owners, documentation, and SLAs that power analytics dashboards and self-serve tools
• Collaborate across studio, analytics, and infrastructure teams; maintain privacy and compliance fundamentals

What We're Looking For

• 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 — fluent with event telemetry, player lifecycle metrics (retention, LTV, ARPDAU), 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, and operational hygiene
• Solid production engineering practices — version control, code review, CI/CD, and environment management for data pipelines
• Comfortable operating within a partner-managed ETL framework and coordinating across studio, analytics, and infrastructure teams
• Strong collaboration and communication skills; high-ownership working style with comfort in ambiguous problem spaces
• Working knowledge of privacy and compliance fundamentals
• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field

Nice to Have

• Experience with dbt (data build tool) for transformation orchestration
• Familiarity with mobile attribution SDKs (Adjust, AppsFlyer, Kochava) and attribution modeling
• Familiarity with mobile game revenue data — in-app purchases and ad monetization
• Experience with data observability platforms
• Fluency with Mixpanel as a downstream consumer of the data you build; exposure to Tableau or Looker

Compensation & Benefits

• Salary range: USD 132,000 – 155,000 per year
• Mattel offers competitive total pay programs, comprehensive benefits, and resources to help empower a culture where every employee can reach their full potential.