Portfolio Management Analyst

Mattel; El Segundo (CA); On-site; USD 85,000 - 120,000; Full time

Job summary

Mattel is seeking a Portfolio Management Analyst to enable data-driven portfolio decisions by connecting Global Product Brand Teams with regional planning and commercial groups. You will own PMR analytics, develop executive-ready visuals, and support cross-functional process improvements across the S&OP organization.

You will translate complex data into concise narratives, build KPI views and dashboards, and partner with Finance, Product Development, and Sourcing to align on decisions and

Qualifications

• Bachelor’s degree or higher in Business Administration, Supply Chain, Analytics, Finance, Operations, or a related field.
• 2–3 years of relevant experience in supply chain, portfolio management, product development, business analytics, or a related function; consumer products experience preferred.
• Strong analytical and critical-thinking skills; ability to frame ambiguous business questions and form evidence-based recommendations.
• Experience developing recurring management presentations with data visualization and executive storytelling.
• Advanced Excel skills (pivot tables, lookups, data cleansing, scenario modeling) and familiarity with automation tools like Power Query.
• Proficiency in PowerPoint with strong slide architecture and visual storytelling; experience with BI tools (Tableau/Power BI) and dashboard validation.
• Practical proficiency with generative AI/productivity tools for analysis, summarization, and content development; strong data privacy awareness.
• Excellent written and verbal communication; ability to collaborate cross-functionally and influence stakeholders.

Responsibilities

• Own the end-to-end monthly PMR analytics and PowerPoint deck development including data collection, validation, synthesis, storytelling, and distribution of materials.
• Analyze portfolio performance across brands, regions, product lines, and planning horizons; identify trends, variances, risks, and opportunities.
• Translate large datasets into concise business narratives, clear recommendations, and actionable metrics for leadership.
• Develop and maintain standardized KPI views, scorecards, dashboards, and presentation templates for consistency and efficiency.
• Conduct ad-hoc analysis, scenario modeling, and what-if assessments on portfolio choices and demand shifts.
• Partner with Global Brand Teams, regional planning, and Finance to drive alignment on decisions and follow-up actions.
• Lead or support initiatives to improve PMR/S&OP processes; define requirements and measure outcomes.
• Collaborate with Supply Chain Analytics to validate data and improve dashboard usability and adoption.
• Apply approved AI tools responsibly to accelerate research and reporting while protecting confidential information.
• Maintain action logs and decision records from PMR sessions and monitor follow-through.

Skills

Analytics

Excel

PowerPoint

Power BI

Tableau

AI tools

SQL

Python

Alteryx

Education

Bachelor's degree or higher

Tools

SQL

Python

Alteryx

Power Query

Job description

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

The Portfolio Management Analyst enables data-driven portfolio decisions by connecting Global Product Brand Teams with regional planning functions and commercial organizations. The role analyzes portfolio and supply chain performance, identifies trends, risks, and opportunities, and translates complex data into clear executive insights and recommended actions.

As a critical member of the Portfolio Management team, the analyst will own the monthly Portfolio Management Review analytics and presentation process, strengthen performance measurement and governance, and support cross‑functional process improvements across the S&OP organization. The analyst will also apply modern analytics and responsible AI tools to improve the speed, quality, and consistency of analysis and decision support.

What Your Impact Will Be:

• Own the end‑to‑end monthly Portfolio Management Review (PMR) analytics and PowerPoint deck development process, including data collection, validation, synthesis, storyline development, executive‑ready visuals, and distribution of supporting materials.
• Analyze portfolio performance across brands, regions, product lines, and planning horizons; identify meaningful trends, variances, outliers, risks, and opportunities that require management attention.
• Translate large and complex data sets into concise business narratives, clear recommendations, and actionable metrics that help leaders understand what changed, why it changed, and what action is required.
• Develop and maintain standardized KPI views, scorecards, dashboards, and presentation templates to improve consistency, comparability, and efficiency across monthly reviews.
• Conduct ad‑hoc analysis, scenario modeling, and what‑if assessments to evaluate portfolio choices, timing changes, demand shifts, item productivity, and process impacts.
• Partner with Global Brand Teams, regional planning, commercial teams, Finance, Product Development, and Sourcing to understand business challenges, challenge assumptions constructively, and drive alignment on decisions and follow‑up actions.
• Lead or support strategic initiatives that improve Portfolio Management and S&OP processes, including defining requirements, documenting workflows, measuring outcomes, and managing implementation milestones.
• Partner with Supply Chain Analytics to validate data, perform user acceptance testing, improve dashboard usability, and increase adoption and understanding of reporting tools.
• Use approved AI and automation tools responsibly to accelerate research, data preparation, quality checks, meeting summaries, and presentation development while applying sound judgment, protecting confidential information, and validating outputs before use.
• Maintain action logs and decision records from PMR sessions, monitor follow‑through, and escalated unresolved risks or dependencies when appropriate.

What We’re Looking For:

• Bachelor’s degree or higher in Business Administration, Supply Chain, Analytics, Finance, Operations, or a related field.
• 2-3 years of relevant experience in supply chain, portfolio management, product development, business analytics, or a related function; consumer products experience preferred.
• Strong analytical and critical‑thinking skills, including the ability to frame ambiguous business questions, test assumptions, distinguish signal from noise, identify root causes, and form evidence‑based recommendations.
• Demonstrated ability to develop recurring management presentations that combine accurate analysis, effective data visualization, and a compelling executive storyline.
• Advanced Microsoft Excel skills, including pivot tables, lookups, data cleansing, scenario modeling, and management of large data sets; experience with Power Query or similar automation capabilities is preferred.
• Highly proficient in Microsoft PowerPoint, with strong capability in slide architecture, chart selection, visual hierarchy, and communicating complex information clearly to senior stakeholders.
• Working knowledge of Business Intelligence and visualization tools such as Tableau, Power BI, or comparable platforms; ability to validate dashboard outputs and interpret underlying data.
• Practical proficiency with generative AI and productivity tools for analysis, research, summarization, and content development, including effective prompting, output validation, data privacy awareness, and responsible‑use practices.
• Strong written and verbal communication skills, with the ability to tailor messages for technical, operational, and executive audiences.
• Ability to collaborate cross‑functionally, build trust, influence without direct authority, and constructively challenge stakeholders to drive decisions and accountability.
• Excellent attention to detail, data‑quality discipline, organizational skills, and ability to manage multiple deliverables within a monthly recurring cadence.
• Demonstrated growth mindset, intellectual curiosity, learning agility, and willingness to improve processes through new methods and technologies.

Preferred Qualifications

• Experience with SQL, Python, Alteryx, Power Query, or other data‑transformation and automation tools.
• Familiarity with S&OP, integrated business planning, product lifecycle management, portfolio optimization, or consumer‑products planning processes.
• Experience defining KPIs, building repeatable reporting processes, and documenting data definitions or business rules.

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

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

How We Work:

We are a purpose driven company aiming to empower generations 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 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 at https://jobs.mattel.com/ and www.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