Key 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.
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.
Preferred Qualifications
- 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
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.
- 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 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.
Who We Are:
Mattel is a leading global toy and family entertainment company and owner of 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 and .
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
- Videos to watch: The Culture at Mattel
Corporate Philanthropy
