Inventory Planning & Data Analyst

Our Story With over 50 years of serving the creative community, Adorama has grown from a beloved New York City camera store into the world’s only full-service destination for photo, video, and electronics. We’re more than a retailer—we’re a creative partner for professionals, hobbyists, and tech enthusiasts alike. From iconic brands like Sony, Canon, and Nikon to the latest in drones, smart home tech, musical instruments, and pro audio gear, Adorama provides creators with the gear and services they need to bring their visions to life. Our passion for education, innovation and commitment to customer experience make us a dedicated and trusted resource. At Adorama, we don’t just support creativity—we live it. Join a team that’s shaping the future of how the world captures, creates and connects. Our Leadership Principles Growth Mindset: We set high standards, embrace failure, and are open to change. Be Customer-Centered: We focus on the end-to-end customer experience. Take Ownership & Dig Deeper: We are proactive, use data, and avoid shortcuts. Think Like a Start-Up: We move fast, stay flexible, and celebrate every win. Be Humble & Respectful: We assume positive intent, listen actively, and support one another. What You'll Do The Inventory Planning & Data Analyst will combine hands-on inventory planning, SQL, business intelligence, and reporting automation to improve product availability, strengthen purchasing decisions, and optimize inventory investment. Reporting to the Head of Inventory and Demand Planning and working directly with Merchants, you will investigate inventory, demand, and supply issues, identify root causes, and turn findings into actionable SKU-level recommendations. You will independently build dashboards and analytical tools, own recurring analysis and replenishment reviews, and follow corrective actions through resolution within established planning policies and purchasing authority. This role offers direct exposure to initiatives in forecast optimization, warehouse distribution, lead time, and excess inventory management, with opportunities to improve how the team uses data and reduce recurring manual work. Responsibilities: Merchant Support and Inventory Decisions Apply established inventory, weeks of supply (WOS), and aged inventory targets correctly when reviewing PO recommendations and inventory health; flag exceptions, recommend corrective actions, and follow through with Merchants. Investigate merchant questions, identify root causes, and provide clear item-level recommendations; track agreed actions and escalate unresolved issues. Replenishment and PO Execution Review daily replenishment and PO needs against established inventory and WOS targets, run-rate, lead time, available inventory, open POs, backorders, and demand trends to control purchasing and avoid excess inventory. Validate system recommendations before execution, especially for high-velocity, high-value, long-lead-time items and SKUs with 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 issues affecting availability, inventory exposure, or merchant goals and track corrective actions through resolution. BI Dashboards and Planning Analytics Independently build, maintain, and enhance inventory and planning dashboards in Looker, including data preparation, calculated metrics, filters, and reporting validation. Write and maintain SQL queries to extract, join, aggregate, and validate sales, demand, inventory, item master, and PO data. Monitor dashboard refreshes and reporting accuracy; reconcile outputs with source data and troubleshoot discrepancies with BI and technical partners. Automate recurring reporting and build exception dashboards that prioritize stockout risk, aged inventory, overstock, backorders, past-due POs, demand anomalies, and data gaps; highlight affected SKUs, in…

View the full posting and apply