Supply Planning Analyst

Subaru•Camden, NJ

11h•$72,000 - $85,000•Hybrid

About The Position

The Supply Planning Analyst supports the vehicle planning process by analyzing incoming import supply, forecasting domestic production, and consolidating supply intelligence across production, sales, shipping, planning, and logistics organizations. This role plays a critical role supporting the vehicle planning team, with involvement in the planning cycle, preparing analyses, coordinating inputs, and ensuring data accuracy to enable informed consensus decisions related to vehicle distribution and availability.

Requirements

Intermediate to advanced proficiency in Microsoft Excel, including formulas, pivot tables, lookups, data visualization, and data calculation automation including Power Query.
Bachelor’s degree required and 4 to 6 years of progressive experience required.

Nice To Haves

Strong analytical and problem-solving skills, with the ability to interpret production and supply data and identify meaningful trends.
Ability to research, organize, reconcile, and validate data from multiple sources with attention to detail and accuracy.
Effective written and verbal communication skills, including the ability to summarize complex analyses for cross functional audiences.
Demonstrated ability to manage competing priorities and deliver time sensitive analyses in a recurring planning cadence.
Exposure to enterprise reporting systems including Oracle Business Intelligence (OBI) and QlikView preferred.

Responsibilities

Leads, coordinates, and presents weekly Vehicle Planning meetings to deliver consolidated analysis of sales trends, market intelligence, trim-level performance, port inventory, and projected demand fulfillment. This research would lead to actionable recommendations for best management of resources (ie. Global Tracking Number (GTN) – Vehicle: Port Swaps, Port Changes, Purchase Order and allocation insights).
Supports the monthly allocation planning process for all US production, consisting of ~350,000+ import vehicles and ~300,000+ units of domestic production into forward-looking supply strategies across seven US Ports and Subaru of Indiana, SIA, production by preparing and presenting pre-supply review analyses of sales performance, market demand, production data, inventory, port capacity, and purchase order fulfillment to identify risks and imbalances and propose recommendations.
Gathers and synthesizes demand intelligence from sources including Oracle Business Intelligence, MarketView, and S&P Global to form coordinated demand views of market opportunities, risks, and imbalances to support ongoing adaptations of future supply to meet demand.
Performs purchase order consumption and shipping analysis to ensure receipt of matching vehicle model mix and quantities from foreign and domestic production for approximately $24B in annual vehicle inventory.
Partners with SBR to request and track shipping adjustments via Global Tracking Numbers (GTN), to rebalance supply and support high-demand markets.
Acts as the primary analytical partner to Vehicle Planning and Fleet Operations to review supply and production plans for the order creation and fulfillment of $500M+ in annual rental fleet volume.
Responsible for the selection, order creation and order fulfillment of $500M+ in annual rental fleet volume, ensuring alignment with wholesale objectives, profitability, and inventory flow.
Tracks allocation plan changes over time and analyzes drivers of variance between planned and actual supply to support continuous process improvement.
Supports documentation of allocation planning assumptions, timelines, and standard operating procedures.
Assists with development and enhancement of planning reports, dashboards, and data visualizations.
Participates in cross functional meetings related to production planning, logistics constraints, and supply risk mitigation.
Provides analytical support for special projects related to distribution planning and supply optimization.
Provides ad hoc reports upon request.