Data Engineer, Mobile Game Analytics

Mattel; El Segundo (CA); On-site; USD 132,000 - 155,000; Full time

Job summary

Mattel Game Studios seeks a Data Engineer II to own the analytics backbone for our mobile free-to-play portfolio. You’ll design and operate pipelines, data models, and quality systems that turn raw telemetry into analyst-ready datasets for retention, monetization, and engagement across titles.

This is a build-while-running role; you’ll keep existing pipelines healthy, migrate legacy infrastructure to a partner-managed ETL platform, and stand up new capabilities with it.

Qualifications

• 4+ years as a Data Engineer shipping production data pipelines.
• Expert SQL and strong Python, with hands-on BigQuery and Airflow/Cloud Composer experience.
• Demonstrated expertise in medallion architecture, dimensional modeling and DW optimization.
• Mobile F2P analytics experience with telemetry, retention, LTV and ARPDAU metrics.
• Hands-on working knowledge of GCP-native tooling and data observability.

Responsibilities

• Run and optimize the LiveData ETL framework for mobile game telemetry ingestion and transformation.
• Maintain silver/gold transformation layers in BigQuery with optimized schemas for analytics.
• Migrate legacy Airflow pipelines to the partner platform without disrupting live reporting.
• Collaborate with game studios and analysts on tracking plans, events, and data contracts.
• Build data quality, observability systems, and CI/CD practices for pipelines.
• Contribute to engineering practices and apply AI tooling to SQL authoring and documentation.

Skills

SQL

Python

BigQuery

Airflow

Cloud Composer

Dimensional modeling

Data warehouse

ETL pipelines

Data quality

CI/CD

Education

Bachelor's degree in Computer Science, Engineering, Information Systems

Tools

dbt

Mixpanel

Tableau

Looker

GCP-native tooling

Job description

CREATIVITY IS OUR SUPERPOWER.It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.

The Team:

Mattel Game Studios builds and publishes digital games inspired by Mattel’s iconic brands—creating high-quality experiences that connect players with the characters and worlds they love. Led by seasoned games industry leaders, we partner across disciplines and with best-in-class external studios to bring experiences to life for a global audience.

The Opportunity:

We’rehiring a Data Engineer II to own the analytics backbone for our growing mobile free-to-play portfolio.You’lldesign andoperatethe 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’llkeep existing pipelines healthy, migrate legacy infrastructure onto our partner-managed ETL platform, andstand upnew capabilities alongside it.

What Your Impact Will Be:

Run &Optimize– LiveData ETL Framework

• Configure andoperatethe partner-managed ETL framework for mobile game telemetry ingestion and transformation

• Maintain silver/gold transformation layers inBigQueryusing SQL and orchestration tooling, applyingschemasoptimizedfor analytical queries

• OptimizeBigQueryperformance and cost through partitioning, clustering, materialized views, and query tuning

• Design curated data marts as data products — with clear owners, documentation, and SLAs — that powerMixpaneldashboards 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

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 inBigQueryand Airflow / Cloud Composer

• Demonstratedexpertiseinmedallion architecture,dimensionalmodelingand 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 recordof 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

• Comfortoperatingwithin 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 withdbt(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 withMixpanelas a downstream consumer of the data you build; exposure to Tableau or Looker

*The pay range of 132,000 to 155,000 USD annual 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.

Don’t meet every single requirement?At Mattel, we are dedicated to an inclusive workplace and a culture of belonging. If you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles.Join Mattel's Talent Community and start receivingexciting updates about our company, our employees, and our culture. Also, interested in signing up for job alerts? Do so here!

How We Work:

We are a purpose driven company aiming to empower generations to explore the wonder of childhood and reach their full potential. We live up to our purpose employing the following behaviors:

• We collaborate:Being a part of Mattel means being part of one team with shared values and common goals. Every person counts and working closely together always brings better results. Partnership is our process and our collective capabilities is our superpower.
• We innovate:At Mattel we always aim to find new and better ways to create innovative products and experiences. No matter where you work in the organization, you can always make a difference and have real impact. We welcome new ideas and value new initiatives that challenge conventional thinking.
• We execute:We are a performance-driven company. We strive for excellence and are focused on pursuing best-in-class outcomes. We believe in accountability and ownership and know that our people are at their best when they are empowered to create and deliver results.

Who We Are:

Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world. We engage consumers and fans through our franchise brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA and Polly Pocket, as well as other popular properties that we own or license in partnership with global entertainment companies. Our offerings include toys, content, consumer products, digital and live experiences.Our products are sold in collaboration with the world’s leading retail and ecommerce companies. Since its founding in 1945, Mattel is proud to be a trusted partner in empowering generations to explore the wonder of childhood and reach their full potential.

Mattel’s award-winning workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and more.

Visit us at https://jobs.mattel.com/ and www.instagram.com/MattelCareers.

Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers, and all applicants will receive consideration for employment without regard to race, ethnicity, color, national origin, religion, sex, gender, gender identity or expression, sexual orientation, veteran and protected veteran status, disability status, and or any other basis protected by applicable federal, state or local law.

Pursuant to the Los Angeles Fair Chance Ordinance and the California Fair Chance Act, qualified applicants with arrest or conviction records will be considered for employment.

Videos to watch:

The Culture at Mattel

Corporate Philanthropy