Mattel
is hiring
Data Analyst
About Our Company
We are a purpose driven company with a mission to create innovative products and experiences that inspire, entertain, and develop children through play.
We treat play as if the future depends on it — because it does. Play is our language, and we speak to our consumers authentically by representing the world as they see and imagine it.
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 engage consumers through our portfolio of iconic brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Monster High 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 and digital experiences, music, and live events. We operate in more than 35 locations and our products are sold in more than 150 countries in collaboration with the world’s leading retail and ecommerce companies.
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. Mattel is at its best when every member of our team feels respected, included, and heard. We support this by offering flexible work schedules, health and wellness programs including personal and professional coaching, financial rewards, recognition programs and more.
Job Description & Responsibilities
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.
Requirements
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.
- Demonstrated a growth mindset by staying curious and continuously learning, embracing challenges, and improving themselves.
What we offer
The annual base salary range for this position is between $60,000 and $75,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.