Data Analyst - Direct to consumer (DTC)

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, entertain 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 Opportunity: 

Under direction from the DTC Planning and Control Manager, the Data Analyst is responsible for all ad hoc data reporting within the DTC organization.  Responsible for capturing and reporting all DTC operational metrics and KPI, the Data Analyst will interpret data trends and provide tactical insights to the Planning & Control Manager and leadership team to help improve customer service levels and operational efficiency.  The Data Analyst is responsible for overall DTC systems master data quality and will work with appropriate partners to ensure proper controls and audits are in place to avoid data driven issues.  To ensure efficient replenishment and fulfillment operations, the Data Analyst is responsible for analyzing sales forecasts and planned flash sale demand to ensure proper slotting of SKUs.      

What Your Impact Will Be: 

• Extract and interpret data from various sources and using appropriate applications, provide ad hoc reporting to management as needed.
• Identify and define operational metrics and KPIs; provide management reports articulating trends, root causes of such trends and improvement opportunities. 
• Develop methodology and process to effectively slot SKUs in appropriate media to minimize replenishment and maximize order allocation.
• Continually monitors SKU slot performance to established targets, and re-slot SKUs as needed.
• Identify key systems data attributes; develop a process to validate accuracy and update as needed.
• Coordinates and oversees development and continued improvement of system reports and dashboards. 
• Engages and challenges business sponsors and stakeholders as warranted and appropriate.
• Support, as needed, business testing of systems solutions.
• DTC master data and report SME.
• Travel as required, ~25%.
• Other job duties as assigned from time to time.

What We’re Looking For:

• Bachelor’s Degree in appropriate discipline or proven experience required with 4-5 years experience working in a DTC distribution operation (preferably consumer goods) with a minimum of 3 years as a data analyst. 
• Advanced Microsoft Excel and Access skills required; strong SQL, Python and PowerPoint skills required, Power BI (or like) experience preferred.    
• Proven experience extracting, analyzing and interpreting data in a DTC distribution environment. 
• Excellent interpersonal, presentation and communication skills with the proven ability to work effectively with all organizational levels; ability to present material in a concise focused manner.
• Proven ability working effectively as part of a cross functional, global team.
• Proven ability to effectively navigate conflict between multiple business partners.
• Must thrive and excel in an ever changing fast paced environment while achieving broadly communicated objectives under minimal supervision.
• Proven experience handling confidential and sensitive information is essential.
• Demonstrated a growth mindset by staying curious and continuously learning, embracing challenges, and improving themselves.
• Demonstrated a growth mindset by staying curious and continuously learning, embracing challenges, and improving themselves.

The annual base salary range for this position is between $63,000 and $78,000.
**This range is indicative of projected hiring range, however annual base salary will be determined based on a candidate’s work location, skills and experience.

Don’t meet every single requirement? At Mattel we are dedicated to building a diverse and inclusive workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

What It’s Like to Work Here:

We are a purpose driven company aiming to empower the next generation 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.

Who We Are:

Mattel is a leading global toy company and owner of one of the strongest catalogs of children’s and family entertainment franchises in the world. We create innovative products and experiences that inspire, entertain and develop children through play. We engage consumers through our portfolio of iconic brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO and MEGA, as well as other popular intellectual properties that we own or license in partnership with global entertainment companies. Our offerings include film and television content, gaming, music and live events. We operate in 35 locations and our products are available in more than 150 countries 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 children to explore the wonder of childhood and reach their full potential.

Mattel is recognized for the second year in a row as a Great Place to Work™ and as one of Fast Company’s Best Workplaces for Innovators in 2022.

Visit us at https://jobs.mattel.com/ and www.instagram.com/MattelCareers.

Mattel is an Affirmative Action/Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers including minorities, females, veterans, military spouses, individuals with disabilities, and those of all sexual orientations and gender identities.