π Role: Inventory Data Analyst, Amazon FBA Reconciliation (SQL)
π Location: San Diego, CA 92101 (Onsite at Symphony Towers)
π° Compensation Range: $125,000-$150,000 DOEYou 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 TowersYour 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 InBuilt 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 & PerksYou 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 TransparencyWe'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.