Job Description

The Opportunity:

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.

What Your Impact Will Be:

Quantitative Methods

• 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

Programming / Tools

• Proficient with relational databases (e.g. MySQL, Redshift, BigQuery)
• 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

Data Visualization

• 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)

Business Knowledge

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

Critical Thinking / Innovation

• 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

Communication

• 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

Independence

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

Bonus Points

• Understanding of data transformation processes or ETL
• Experience with cloud architecture (e.g. GCP, AWS)

Qualifications

What We're Looking For:

• Bachelor's degree in Statistics, Mathematics, Economics, Computer Science, Engineering, or another quantitative discipline
• 2+ years of experience in analytics, business intelligence, data science, or a related field
• Prior experience in ecommerce, digital analytics, consumer analytics, or retail environments preferred

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

Additional Information

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 receiving exciting 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.