Consumer Data Analyst

Mattel•El Segundo, CA

10d•$76,000 - $90,000•Onsite

About The Position

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

Requirements

Knowledge of descriptive statistical measures
Knowledge of consumer analyses (e.g. new vs returning consumer behavior, consumer cohorts, consumer journeys)
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, BigQuery)
Proficiency with SQL, querying accurately with minimal review
Ability to do the following with either Python or R:
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

Nice To Haves

Understanding of data transformation processes or ETL
Experience with cloud architecture (e.g. GCP, AWS)
Prior experience in ecommerce, digital analytics, consumer analytics, or retail environments preferred

Responsibilities

Propose quantitative approaches and conduct analyses
Clean, explore, and transform data
Apply statistical analyses and predictive models
Use either notebooks or scripts to develop clean, standardized code
Design action-oriented visualizations that tell a story and drive results
Apply methods appropriate for summarizing and displaying both categorical and numeric data
Design and develop interactive dashboards in tools (e.g. Tableau, Looker, Power BI, Sisense)
Produce plots and visualizations programmatically (e.g. matplotlib, ggplot)
Tell a concise story to business stakeholders with actionable recommendations, providing quantitative evidence when needed
Document analysis, assumptions, methodology, and results clearly and at the appropriate level of detail
Manage multiple tasks according to priority, schedule, resources, etc