Data Engineer, Mobile Game Analytics
About the role
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.
Responsibilities
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 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
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 (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
Production engineering practices — version control, code review, CI/CD, and environment management for data pipelines
Comfort 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
Qualifications
Working knowledge of privacy and compliance fundamentals
Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field
Skills
Experience with dbt (data build tool) for transformation orchestration
Familiarity with mobile attribution SDKs (Adjust, AppsFlyer, Kochava)
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
Benefits
The pay range is indicative of projected hiring range, however base pay will be determined based on a candidate’s work location, skills and experience. Mattel offers competitive total pay programs, comprehensive benefits, and resources to help empower a culture where every employee can reach their full potential.