Portfolio Strategy Analyst — Data-Driven, AI-Enabled Insights

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

Job summary

Mattel, Inc. HQ in El Segundo, California is seeking a Portfolio Management Analyst to enable data-driven portfolio decisions by connecting Global Product Brand Teams with regional planning and commercial functions.

You will analyze portfolio and supply chain performance and translate data into executive insights. In this role you will own PMR analytics, develop KPI views and dashboards, and collaborate across Finance, Product Development, Sourcing, and Brand teams to drive actionable decisions

Qualifications

• Bachelor's degree or higher in Business Administration, Supply Chain, Analytics, Finance, Operations, or related field.
• 2-3 years of relevant experience in supply chain, portfolio management, product development, business analytics, or related function; consumer products experience preferred.
• Advanced Microsoft Excel skills with pivot tables, lookups, data cleansing, scenario modeling, and large data sets; Power Query experience preferred.

Responsibilities

• Own the end-to-end monthly PMR analytics and PowerPoint deck development process, including data collection, validation, synthesis, storyline development, executive-ready visuals, and distribution of materials.
• Analyze portfolio performance across brands, regions, product lines, and planning horizons; identify trends, variances, risks, and opportunities requiring management attention.
• Translate large data sets into concise business narratives, clear recommendations, and actionable metrics for executives.
• Develop and maintain standardized KPI views, scorecards, dashboards, and presentation templates for monthly reviews.
• Conduct ad hoc analysis, scenario modeling, and what-if assessments to evaluate portfolio choices and timing changes.
• Partner with Global Brand Teams, regional planning, commercial teams, Finance, Product Development, and Sourcing to drive alignment and decisions.

Skills

Portfolio management

Data analysis

Excel

PowerPoint

Education

Bachelor's degree or higher in Business Administration, Supply Chain, Analytics, Finance, Operations, or related field

Tools

SQL

Python

Alteryx

Power Query

Job description

Mattel, Inc. HQ in El Segundo, California is seeking a Portfolio Management Analyst to enable data-driven portfolio decisions by connecting Global Product Brand Teams with regional planning and commercial functions.

You will analyze portfolio and supply chain performance and translate data into executive insights. In this role you will own PMR analytics, develop KPI views and dashboards, and collaborate across Finance, Product Development, Sourcing, and Brand teams to drive actionable decisions