Consumer Data Analyst

Mattel, Inc.and Subsidiaries; El Segundo (CA); On-site; USD 76,000 - 90,000; Full time

Job summary

Mattel Sales Corp. in El Segundo, CA is seeking a Consumer Data Analyst to unlock the value of ecommerce and consumer data to drive business growth.

You will report to the Manager of Consumer Data & Advanced Analytics and work onsite in our California office. The role requires strong skills in SQL, Python or R, data visualization, and a solid grounding in descriptive statistics, customer analytics, and KPI tracking.

Qualifications

• Bachelor's degree or higher in a quantitative field.
• 2+ years of analytics, BI, data science, or related area.
• Experience in ecommerce, digital analytics, consumer analytics, or retail preferred.

Responsibilities

• Propose and conduct analyses using descriptive statistics and consumer data.
• Perform analyses on new vs returning customers, cohorts, and journeys.
• Clean, transform, and model data using Python or R and SQL.
• Design or contribute to interactive dashboards in Tableau, Looker, Power BI, or similar.

Skills

SQL

Python/R

Data visualization

Descriptive statistics

Customer analytics

Communication

Education

Bachelor's degree in Statistics, Mathematics, Economics, Computer Science, Engineering

Tools

MySQL

Redshift

BigQuery

Tableau

Looker

Power BI

Sisense

Python

R

Job description

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.

The Team

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 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 relationaldatabases (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 numericdata


• 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 tobusiness 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 datatransformation processes or ETL


• Experience with cloud architecture (e.g. GCP, AWS)

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.

How We Work

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

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 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 athttps://jobs.mattel.com/andwww.instagram.com/MattelCareers.

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 without regard to race, ethnicity, color, national origin, religion, sex, gender, gender identity or expression, sexual orientation, veteran and protected veteran status, disability status, and or any other basis protected by applicable federal, state or local law.

Pursuant to the Los Angeles Fair Chance Ordinance and the California Fair Chance Act, qualified applicants with arrest or conviction records will be considered for employment.

Videos to watch: The Culture at Mattel Corporate Philanthropy