Inventory Data Analyst, Amazon FBA Reconciliation (SQL)

Luminize • San Diego, CA

9d • $125,000 - $150,000 • Onsite

About The Position

Luminize is seeking a forensic-minded Inventory Control Analyst to own Amazon FBA reconciliation across thousands of SKUs. The engineering team has already built the SP-API pipelines. This role requires 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.

Requirements

• 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 Haves

• High-SKU environments.
• BI tools (Looker, Tableau, Power BI).
• SP-API datasets.
• Reimbursement workflows.
• WMS data models.

Responsibilities

• 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.

Benefits

• Comprehensive medical coverage, choose from multiple plans through Anthem Blue Cross.
• Dental & vision, including orthodontia and annual exams.
• Pet benefits, savings on vet care, products, and services.
• Paid vacation, accrue 120 hours a year, with rollover.
• Paid holidays and sick time.
• 401(k) with company match.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed