Based in El Segundo, CA on site, Mattel offers a competitive total pay program and comprehensive benefits. You’ll join one team with shared values that emphasizes collaboration, innovation, and accountability. This is a role built to support the analytics backbone of a growing mobile free-to-play portfolio, turning raw telemetry into analyst-ready datasets that inform retention, monetization, and engagement decisions across titles.
Responsibilities
- Configure and operate the partner-managed ETL framework for mobile game telemetry ingestion and transformation
- Maintain silver and 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 insulate downstream consumers from upstream changes
- Build data quality and observability systems to 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 free-to-play analytics experience — fluency with event telemetry, player lifecycle metrics (retention, LTV, ARPDAU), and game economy KPIs
- Hands-on working knowledge of Google Cloud Platform 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
- 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
- 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
Technologies
- SQL
- Python
- BigQuery
- Airflow
- Cloud Composer
- dbt
- Google Cloud Platform native tooling
- Mixpanel
- Tableau
- Looker
- Adjust
- AppsFlyer
- Kochava
Benefits
- Competitive total pay programs
- Comprehensive benefits
The Opportunity
We are hiring a Data Engineer II to own the analytics backbone for our growing mobile free-to-play portfolio. You will design and operate the pipelines, data models, and quality systems that turn raw telemetry into trustworthy, analyst-ready datasets, enabling studio teams to sharpen retention, monetization, and engagement decisions across titles. This is a build while running role: you will maintain existing pipelines, migrate legacy infrastructure onto the partner-managed ETL platform, and extend capabilities across licensed titles.
How We Work
We collaborate as one team with shared values and common goals. Partnership guides our process, and our collective capabilities are our strength. We welcome new ideas and initiatives that challenge conventional thinking, and we execute with accountability and ownership, empowering everyone to deliver results.
Videos to Watch
- The Culture at Mattel
- Corporate Philanthropy
