Quality Assurance (QA Engineer)

The Opportunity: 

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. 

Qualifications :

What Were Looking For: 

Required Qualifications 

• 25 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 of Form 

Additional Information :

Dont meet every single requirement At Mattel we are dedicated to an inclusive workplace and a culture of belonging. If youre excited about this role but your past experience doesnt 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 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.

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 worlds 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.

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

Visit us at  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

Remote Work :

No

Employment Type :

Full-time