Consumer Data Analyst

Posting Title Consumer Data Analyst

Requisition Number R232553

Company Mattel Sales Corp.

Location El Segundo, California

Address 333 Continental Blvd

Zip Code 90245

Job Category Marketing

Pay Range USD $76,000 and $90,000 Yearly

The pay range 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.

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.

Mattel's Direct-to-Consumer (DTC) and Ecommerce organization is a key driver of Mattel's digital transformation and global growth strategy. Through experiences like Mattel Creations, American Girl, and brand-owned ecommerce platforms, the team creates engaging digital destinations where consumers can explore, connect with, and purchase directly from our brands.

The DTC organization brings together product, merchandising, marketing, technology, and analytics to deliver best-in-class digital experiences for collectors, parents, and fans around the world. By combining consumer insights, innovative product experiences, and data-driven decision making, the team is focused on strengthening direct relationships with our consumers and accelerating the growth of Mattel's global ecommerce business.

The team is seeking a Consumer Data Analyst to help unlock the value of consumer and ecommerce data to drive business growth. The Analyst will report to the Manager Consumer Data & Advanced Analytics and will be located in our El Segundo, CA office.

• Knowledge of descriptive statistical measures
• Knowledge of consumer analyses (e.g. new vs returning consumer behavior, consumer cohorts, consumer journeys)
• Propose quantitative approaches and conduct analyses
• Awareness of modeling, ready to apply the following with guidance: data cleaning, linear / logistic regression, segmentation, churn / propensity, lifetime value

• Proficient with relational databases (e.g. MySQL, Redshift, Big Query)
• Proficiency with SQL, querying accurately with minimal review
• Ability to do the following with either Python or R:
• Clean, explore, and transform data
• Apply statistical analyses and predictive models
• Use either notebooks or scripts to develop clean, standardized code

• Experience designing action-oriented visualizations that tell a story and drive results
• Application of methods appropriate for summarizing and displaying both categorical and numeric data
• Experience designing and developing interactive dashboards in tools (e.g.Tableau, Looker, Power BI, Sisense)
• Experience in producing plots and visualizations programmatically (e.g. matplotlib,ggplot)

• Understanding of e-commerce business domain
• Understanding of measures relevant to context (KPI's): conversion, demand, net sales, AOV, retention rate, RFM

• Takes initiative to identify problems and be proactive in providing solutions
• Able to reason through theories, facts, and potential choices to determine logical implications
• Demonstrates continuous learning

• Ability to tell a concise story to business stakeholders with actionable recommendations, providing quantitative evidence when needed
• Documents analysis, assumptions, methodology, and results clearly and at the appropriate level of detail

• Balances independent problem-solving with asking questions
• Ability to manage multiple tasks according to priority, schedule, resources, etc

• Understanding of…