Inventory Data Analyst, Amazon FBA Reconciliation (SQL)
Luminize🚀 Protect Real Dollars at Scale — Love Where You Work 📍 Role: Inventory Data Analyst, Amazon FBA Reconciliation (SQL) 📍 Location: San Diego, CA 92101 (Onsite at Symphony Towers) 💰 Compensation Range: $125,000–$150,000 DOE You might currently be an Inventory Control Analyst, FBA Reconciliation Analyst, Amazon Reimbursement Specialist, Inventory Data Analyst, Supply Chain Data Analyst, or Operations Analyst (Amazon Marketplace). If you've traced units through a chain of custody until you found exactly where they fell out, written your own SQL to join shipment and ledger tables when Excel couldn't get you there, and turned a pile of shortage cases into filed reimbursement claims and real dollars recovered, you'll recognize this role. At Luminize, we help brands win, and as one of the top 5 Amazon sellers by volume, we're looking for top performers to grow with us. We're hiring a forensic-minded Inventory Control Analyst to own Amazon FBA reconciliation across thousands of SKUs. Our engineering team has already built the SP-API pipelines. We need someone to trace inventory from warehouse through FBA inbound, receiving, adjustments, returns, and removals, pinpoint where units fall out of the chain of custody, and drive corrective action. This is an ownership role, not a reporting role. 🎯 What You'll Be Doing Own reconciliation of inventory moving from our warehouse to Amazon FBA, WMS records, box-level contents, carrier handoff, and Amazon receiving events Analyze FBA ledger data across receipts, returns, removals, disposals, and adjustments, translating Amazon reason codes into business impact Manage a structured exception queue covering shortages, misplaced units, damages, and aged variances requiring reimbursement follow-up Identify recurring failure points and partner with Warehouse and Operations to implement stronger controls and audit checks Build executive-ready dashboards for CFO, Accounting, and Operations showing dollars at risk, variance by root cause, and recovery opportunities Collaborate with Engineering, Warehouse, Accounting, and Amazon Operations on data quality, process fixes, and case escalation 🏁 What Success Looks Like (First 90 Days) Weekly variance reporting quantifying unreconciled units and dollar impact by shipment, SKU, and root cause A repeatable reconciliation process for inbound shipments from the warehouse to Amazon Aging buckets and escalation rules for missing, damaged, lost, and unreceived units Executive-ready reporting that drives decisions, not raw data dumps ✅ What You Bring Direct ownership of FBA reimbursement cases end to end: discovery, evidence, filing, follow-up, and recovery reconciliation Deep understanding of FBA inbound, receiving, adjustments, removals, and common variance drivers 3+ years Amazon FBA experience with inventory reconciliation, operations analytics, or inventory control experience Strong SQL skills and advanced Excel (Power Query, complex lookups, pivots) Forensic attention to detail, comfort with imperfect data, and a bias toward repeatable controls over one-off analysis ➕ Nice to Have High-SKU environments BI tools (Looker, Tableau, Power BI) SP-API datasets Reimbursement workflows WMS data models 🏙 Work From Symphony Towers Your office comes with a view, literally. Panoramic city and coastline views from your workspace Free building gym access, no separate membership needed Exclusive discounts at tower restaurants and cafes Secure bike storage 24/7 paid parking downtown, blocks from the office Steps from 100+ top-rated bars, restaurants, coffee shops, and Petco Park 🛋️ An Office You'll Actually Want to Be In Built for how great teams actually work. Ergonomic standing desks and premium workstations Fully stocked kitchen, snacks, espresso Monthly all-company lunches to celebrate wins and stay connected A team lounge with pool table and games for when you need a break Bright, modern, collaborative space designed for focus and connection 🎁 Benefits & Perks You …