Inventory Planning Analyst Data Jobs

1 job found

Today

Inventory Planning & Data Analyst

Adorama New York, NY

New York, NY

Today

$75k - $85k/yr Full time Business Analytics Business Intelligence Business Intelligence Tools

Apply Now

Job Description

Join Adorama in New York for an onsite role focused on inventory planning, SQL-based analysis, and automated BI reporting to improve product availability and inventory investment.

Responsibilities

Apply established inventory, weeks of supply (WOS), and aged inventory targets when reviewing PO recommendations and inventory health; flag exceptions, propose corrective actions, and follow through with Merchants.
Answer merchant questions by identifying root causes and providing item-level recommendations; track agreed actions and escalate unresolved issues.
Review daily replenishment and PO needs against inventory and WOS targets, including run-rate, lead time, available inventory, open POs, backorders, and demand trends to manage purchasing and limit excess inventory.
Validate system recommendations before execution, with extra focus on high-velocity, high-value, long-lead-time items and SKUs showing demand spikes or overstock risk.
Release purchase orders within approved authority and follow up with vendors on past-due POs, delivery changes, and supply constraints.
Monitor backorders and stockout risk; escalate availability-impacting issues, inventory exposure concerns, or impacts to merchant goals, and track corrective actions to resolution.
Independently build, maintain, and improve inventory and planning dashboards in Looker, including data preparation, calculated metrics, filters, and reporting validation.
Write and maintain SQL to extract, join, and aggregate sales, demand, inventory, item master, and PO data, and validate outputs.
Monitor dashboard refreshes and reporting accuracy; reconcile results to source data and troubleshoot discrepancies with BI and technical partners.
Automate recurring reporting and exception dashboards that prioritize stockout risk, aged inventory, overstock, backorders, past-due POs, demand anomalies, and data gaps; surface impacted SKUs, investigation priorities, recommended actions, and follow-up owners.
Maintain reporting that tracks inventory, WOS, and aged inventory against targets; verify correct application in replenishment and PO review, investigate variances, and recommend corrective actions for approval.
Support approved initiatives for forecast optimization, warehouse distribution and transfers, slow-moving/excess inventory reporting, and lead time and customer ETA reporting through data validation, analysis, and follow-up.
Coordinate with Merchants and Item Master to keep planning-related item fields accurate and updated; identify missing, outdated, or incorrect attributes that affect replenishment and reporting.
Investigate item setup and planning feed issues that lead to inaccurate recommendations, reporting gaps, or poor inventory decisions.
Investigate flagged exceptions involving aged inventory, overstock, past-due POs, backorders, planning overrides, unusual demand, and data gaps to determine root causes and recommend corrective actions.
Perform root-cause analysis for demand shifts, vendor delays, lead time changes, PO timing issues, item setup errors, and execution gaps; recommend practical corrective actions.
Incorporate considerations for promotions, one-time sales spikes, new items, vendor transitions, and opportunity buys when evaluating planning recommendations.
Partner with Merchants to validate demand changes, product lifecycle status, vendor realities, and purchasing needs; respond with data-backed recommendations.
Coordinate with Vendors, Item Master, Warehouse Operations, Finance, and BI to resolve inventory issues; own related JIRA tickets from intake through closure.
Maintain a structured daily replenishment and exception review, weekly merchant action follow-up, and recurring KPI reporting cadence.
Document workflows and reporting definitions; recommend improvements to replenishment execution, data quality, and merchant follow-up for approval by the Head of Inventory and Demand Planning.

Requirements

At least 3 years of relevant experience in inventory planning, replenishment, demand planning, or supply chain analytics, including hands-on inventory analysis and business reporting.
Experience independently building and maintaining operational dashboards and automating recurring reporting in Looker, Tableau, or Power BI, including data preparation, metric definitions and calculations, refresh configuration, validation, and troubleshooting.
Very strong Excel skills: Power Query, PivotTables, XLOOKUP and other lookup functions, advanced formulas, reconciliation, and analysis of large SKU-level datasets.
Hands-on SQL proficiency to write, validate, and troubleshoot queries independently using joins, aggregations, and CTEs, including identification of duplicate records, missing data, and cross-source discrepancies.
Strong understanding of weeks of supply, run-rate, lead time, inventory turns, GMROI, aged inventory, overstock, backorders, and open PO management.
Attention to detail, root-cause analysis, organization, and communication skills; ability to explain findings clearly and follow issues through resolution.

Technologies

SQL, Looker, Tableau, Power BI, Excel, Power Query, PivotTables, XLOOKUP, Python, VBA, BigQuery, JIRA

Preferred Skills and Experience

Knowledge of Python and VBA for analysis, reporting automation, and maintenance of existing scripts or Excel tools.
Experience with BigQuery, ERP or replenishment systems, JIRA, or automated planning workflows.
E-commerce, retail, consumer electronics, or marketplace inventory experience.

Location and Schedule

New York, NY (onsite)
On-site schedule: 3 days per week
Work week: standard 40-hour schedule

Compensation

USD 75,000 - 85,000 per year

Success Measures

Provide effective merchant support with actionable recommendations and consistent follow-through.
Adhere to established inventory, WOS, and aged inventory targets.
Identify and resolve inventory and data issues faster through root-cause analysis.
Deliver timely, actionable exception reporting.
Maintain accurate and reliable dashboards.
Ensure timely and accurate replenishment and PO execution.
Reduce recurring manual work with measurable impact.

View full job page →

Get Inventory Planning Analyst Data Jobs alerts

New Inventory Planning Analyst Data Jobs, daily.