Back to jobs

Inventory Planning & Data Analyst

Pay
USD 75,000–85,000/yearAnnual period assumed — pay source
Pay range for this role: $75,000—$85,000 USD
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Review daily replenishment and PO needs against WOS and inventory targets

  • Build and maintain inventory and planning dashboards in Looker

  • Write SQL queries to extract and validate sales, inventory, and PO data

  • Investigate exceptions and find root causes of stockouts, overstock, and delays

  • Release POs within approved authority and follow up with vendors on past-due orders

From the employer’s posting
Review daily replenishment and PO needs against established inventory and WOS targets
Independently build, maintain, and enhance inventory and planning dashboards in Looker
Write and maintain SQL queries to extract, join, aggregate, and validate sales, demand, inventory, item master, and PO data
Perform root-cause analysis to identify demand shifts, vendor delays, lead time changes, PO timing issues, item setup errors, or execution gaps
Release purchase orders within approved authority and follow up with vendors on past-due POs

Before you apply

Employer’s visa record
1 H-1B petition approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • SQL for querying and joining sales, inventory, and PO data
  • Hands-on inventory planning experience
  • Looker dashboard building
Qualification wording
Write and maintain SQL queries to extract, join, aggregate, and validate sales, demand, inventory, item master, and PO data
combine hands-on inventory planning, SQL, business intelligence, and reporting automation
Independently build, maintain, and enhance inventory and planning dashboards in Looker
Apply at Adorama

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 14, 202638 days ago
Recorded sightings
37
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Lower than most similar jobs

$75K–$85K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 38

Similar jobs usually come down between day 5 and day 43.

From 16,018 similar postings that came down. Coming down is not always a hire.

Adorama is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • VBA
  • BigQuery
  • Excel
  • Looker
  • Power BI
  • Power Query
  • Tableau
Where the posting names them
Preferred Skills and Experience - Knowledge of Python and Visual Basic for Applications (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.
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.
- 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.
- Very strong Excel skills, including Power Query, PivotTables, XLOOKUP and other lookup functions, advanced formulas, data reconciliation, and analysis of large SKU-level datasets. - Hands-on SQL proficiency, with the ability to write, validate, and troubleshoot queries independently using joins, aggregations, and CTEs, as well as identify duplicate records, missing data, and discrepancies across sources. - Strong understanding of weeks of supply, run-rate, lead time, inventory turns, GMROI, aged inventory, overstock, backorders, and open PO management.
- Knowledge of Python and Visual Basic for Applications (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.
- Demonstrated 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. Candidates must demonstrate their own contributions and resulting business impact. - Very strong Excel skills, including Power Query, PivotTables, XLOOKUP and other lookup functions, advanced formulas, data reconciliation, and analysis of large SKU-level datasets. - Hands-on SQL proficiency, with the ability to write, validate, and troubleshoot queries independently using joins, aggregations, and CTEs, as well as identify duplicate records, missing data, and discrepancies across sources.
- 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.
- 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. - Demonstrated 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. Candidates must demonstrate their own contributions and resulting business impact. - Very strong Excel skills, including Power Query, PivotTables, XLOOKUP and other lookup functions, advanced formulas, data reconciliation, and analysis of large SKU-level datasets.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

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, investigation priorities, recommended actions, and follow-up owners.
    • Maintain reporting that monitors inventory, WOS, and aged inventory against established targets; verify their correct application in replenishment and PO review, investigate variances, and recommend corrective actions for approval.
    • Support approved initiatives in forecast optimization, warehouse distribution and transfers, slow-moving and excess inventory reporting, and lead time and customer ETA reporting through data validation, analysis, and follow-up.
  • Root Cause Analysis and Planning Data Accuracy
    • Work with Merchants and Item Master to keep planning-related item fields accurate and updated promptly; identify missing, outdated, or incorrect attributes affecting replenishment and reporting.
    • Follow up on item setup and planning feed issues that create 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 to identify demand shifts, vendor delays, lead time changes, PO timing issues, item setup errors, or execution gaps; recommend practical corrective actions.
    • Account for promotions, one-time sales spikes, new items, vendor transitions, and opportunity buys when evaluating planning recommendations.
  • Cross-Functional Collaboration and Process Improvement
    • Partner with Merchants to validate demand changes, product lifecycle status, vendor realities, and purchasing needs; respond to requests 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 and maintain established 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.

Required Skills and Experience

  • 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.
  • Demonstrated 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. Candidates must demonstrate their own contributions and resulting business impact.
  • Very strong Excel skills, including Power Query, PivotTables, XLOOKUP and other lookup functions, advanced formulas, data reconciliation, and analysis of large SKU-level datasets.
  • Hands-on SQL proficiency, with the ability to write, validate, and troubleshoot queries independently using joins, aggregations, and CTEs, as well as identify duplicate records, missing data, and discrepancies across sources.
  • Strong understanding of weeks of supply, run-rate, lead time, inventory turns, GMROI, aged inventory, overstock, backorders, and open PO management.
  • Strong attention to detail, root-cause analysis, organization, and communication; able to explain findings clearly and follow issues through resolution.

Preferred Skills and Experience

  • Knowledge of Python and Visual Basic for Applications (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.

Success Measures

Effective merchant support with actionable recommendations and consistent follow-through; adherence to established inventory, WOS, and aged inventory targets; faster root-cause identification and resolution of inventory and data issues; timely, actionable exception reporting; accurate and reliable dashboards; timely and accurate replenishment and PO execution; and measurable reductions in recurring manual work.

This role requires three on-site days weekly to ensure in-person collaboration, improved communication, effective teamwork, and real-time problem solving to enhance team synergy and productivity. A standard 40-hour work week is expected.

Pay range for this role:
$75,000—$85,000 USD

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Pay range for this role: $75,000—$85,000 USD
Location & working pattern

New York, NY

Effective merchant support with actionable recommendations and consistent follow-through; adherence to established inventory, WOS, and aged inventory targets; faster root-cause identification and resolution of inventory and data issues; timely, actionable exception reporting; accurate and reliable dashboards; timely and accurate replenishment and PO execution; and measurable reductions in recurring manual work. This role requires three on-site days weekly to ensure in-person collaboration, improved communication, effective teamwork, and real-time problem solving to enhance team synergy and productivity. A standard 40-hour work week is expected. Pay range for this role:
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.