Mattel is seeking a Data Engineer II to own the analytics backbone for its mobile free-to-play portfolio.

Set up and run the partner-managed ETL platform to ingest and transform telemetry from mobile games
Manage the silver and gold data layers in BigQuery using SQL and orchestration tools, applying analytical schemas
Improve BigQuery performance and cost efficiency through partitioning, clustering, materialized views, and query tuning
Create curated data marts as data products with defined owners, documentation, and SLAs to support Mixpanel dashboards and empower analysts to self-serve on retention, monetization, and engagement metrics
Migrate legacy Airflow pipelines to the partner platform for existing and licensed titles while preserving live reporting
Collaborate with game studios and Data Analysts to define tracking plans, including events, properties, validation rules, and data contracts to insulate downstream consumers from upstream change
Build data quality and observability mechanisms to shorten time-to-detect and time-to-recover for telemetry issues before they impact reporting
Contribute to engineering practices such as code review, documentation standards, onboarding, and leverage AI/LLM tooling to accelerate SQL authoring, validation, and documentation

4+ years as a Data Engineer or Analytics Engineer shipping production data pipelines
Expert SQL and strong Python skills, with hands-on experience in BigQuery and Airflow or Cloud Composer
Proven expertise in medallion architecture, dimensional modeling, and data warehouse optimization
Mobile free-to-play analytics experience with event telemetry, player lifecycle metrics (retention, LTV, ARPDAU), and game economy KPIs
Hands-on knowledge of Google Cloud Platform native tooling
Track record building data quality and observability systems with validation, anomaly detection, SLAs, and operational hygiene
Solid production engineering practices including 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 with a high-ownership working style and 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

Own the analytics backbone for Mattel's growing mobile free-to-play portfolio by designing and operating data pipelines, models, and quality systems that convert raw telemetry into analyst-ready datasets for retention, monetization, and engagement decisions across titles
Maintain and evolve live pipelines while migrating legacy infrastructure to a partner-managed ETL platform to support ongoing titles

Experience with dbt for transformation orchestration
Familiarity with mobile attribution SDKs (Adjust, AppsFlyer, Kochava) and attribution modeling
Exposure to mobile game revenue data including in-app purchases and ad monetization
Experience with data observability platforms
Comfort working with Mixpanel as a downstream data consumer; some exposure to Tableau or Looker
Compensation details are location and experience dependent; Mattel offers competitive total pay programs and comprehensive benefits

We collaborate as one team with shared values and goals; partnership is our process and collective capabilities are our strength
We innovate by pursuing new ideas and better ways to create products and experiences; every role can contribute impact
We execute with accountability and ownership, aiming for best-in-class outcomes and measurable results

Data Engineer II, Mobile Game Analytics

Job Description