Inventory Data Analyst, Amazon FBA Reconciliation (SQL)

Luminize

β€’ $125K β€” $150K *
Retail & Consumer Goods
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3+ years experience in Amazon FBA reconciliation or inventory control
  • Strong SQL skills and advanced Excel proficiency
  • In-depth knowledge of FBA inbound processes and common variance drivers
  • Direct end-to-end ownership of reimbursement cases
  • Forensic attention to detail and comfort with imperfect data

Responsibilities

  • Own inventory reconciliation from warehouse to Amazon FBA.
  • Analyze FBA ledger data and translate reason codes into business impact.
  • Manage exceptions for shortages, misplaced units, and damages requiring reimbursement.
  • Identify failure points and work with teams to strengthen controls.
  • Build executive-ready dashboards showing financial impacts and recovery opportunities.

Benefits

  • Comprehensive medical coverage through multiple plans
  • Dental and vision insurance, including orthodontics
  • Pet benefits for savings on vet care and services
  • 120 hours of paid vacation annually, with rollover
  • 401(k) with company match to invest in your future
Full Job Description
πŸ“ 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.

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 do great work here and we want to take care of you outside of it, too.
  • 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, we invest in your future, too.

πŸ’΅ Compensation Transparency

We've listed a broad salary range of $125,000-$150,000/year to account for varying levels of experience, skill sets, and leadership depth. Where you land in the range will depend on how your background aligns with this role.

We're committed to compensating based on value and impact, not just years on paper, and we're happy to have open conversations throughout the process.

If you're excited to take ownership and grow, both in your craft and your career, you'll be in good company here.

Similar Jobs

More Jobs at Luminize

More Retail & Consumer Goods Jobs

Find similar Inventory Data Analyst, Amazon FBA Reconciliation (SQL) jobs: