Quality Assurance (QA Engineer)

About the role

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

Responsibilities

• Validate consumer identity, profile, behavioral, and transactional data across all layers of the data platform, from source systems through curated analytics datasets.
• Perform end-to-end dataset comparisons to ensure consumer-level records, counts, and attributes remain consistent as data moves through ingestion and transformation layers.
• Reconcile consumer metrics and KPIs displayed in Tableau and ThoughtSpot dashboards against upstream source and warehouse tables.
• Test ETL/ELT pipelines that ingest and transform consumer data, including events, purchases, interactions, and engagement signals.
• Validate business logic related to consumer attribution, segmentation, and aggregation rules used in analytics.
• Conduct row-level, aggregate-level, and trend-based testing to identify issues such as duplication, data loss, mis-joins, or incorrect consumer rollups.
• Partner with data engineers and analytics teams to investigate and resolve consumer data quality issues.
• Create reusable test plans, validation checklists, and reconciliation queries for consumer analytics datasets.
• Document test cases, validation results, and QA approvals for consumer data releases.
• Participate in Agile ceremonies, including sprint planning, backlog refinement, and retrospectives.
• Contribute to the continuous improvement of consumer data QA standards, validation frameworks, and automation coverage.

Requirements

• Required Qualifications
• 2-5 years of QA experience focused on consumer data, analytics, or business intelligence.
• Strong proficiency in SQL for validating consumer-level datasets (e.g., Google BigQuery or similar platforms).
• Hands-on experience testing data pipelines within modern data lake or warehouse architectures.
• Proven experience validating consumer-focused dashboards and metrics in BI tools.
• Solid understanding of consumer data models, including identity resolution, event data, and transactional facts.
• Experience using defect tracking and test management tools such as JIRA.
• Strong analytical and troubleshooting skills with exceptional attention to detail.
• Ability to clearly communicate consumer data issues to both technical and business stakeholders.
• Experience testing analytics in Tableau, ThoughtSpot, Looker, or similar BI platforms.
• Familiarity with consumer identity, event tracking, and behavioral data models.
• Exposure to data quality frameworks, reconciliation processes, or automated data validation.
• Experience with CI/CD pipelines and version control (e.g., Git) in analytics environments.
• Understanding of consumer data governance, lineage, and metadata practices.
• Knowledge of privacy and compliance considerations related to consumer data (GDPR, CCPA).
• Experience with automation tools such as Postman, Pytest, or SQL-based testing frameworks.Top of Form
• 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.
• Our Approach to Flexible Work:
• We embrace a flexible work model designed to empower a culture of growth, optimism, and wellbeing, where every employee can reach their full potential. Combining purposeful in-person collaboration with flexibility, our focus is to optimize performance and drive connection for moments that matter.

Benefits

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Mattelinc? Share your experience