Inventory Data Analyst, Amazon FBA Reconciliation (SQL)

Luminize; San Diego (CA); On-site; USD 125,000 - 150,000; Full time

Benefits offered by this job

Comprehensive medical coverage through

Dental & vision

401(k) with company match

Paid vacation 120 hours/year

Paid holidays and sick time

Office at Symphony Towers with city &海

Job summary

Luminize is seeking an Inventory Data Analyst to own Amazon FBA reconciliation from warehouse to inbound, receiving, and removals in a fast-paced environment in San Diego. You’ll transform ledger data into actionable insights, identify loss points, and drive reimbursement opportunities.

Ideal candidates have 3+ years of Amazon FBA experience, strong SQL and Excel skills, and a forensic attention to data quality.

Qualifications

• 3+ years Amazon FBA experience with inventory reconciliation or analytics.
• Strong SQL skills and advanced Excel.
• Experience turning fragmented data into actionable reimbursement claims.

Responsibilities

• Own reconciliation from warehouse to Amazon FBA, including WMS, receiving, and events.
• Analyze FBA ledger data and translate reason codes into business impact.
• Manage a structured exception queue for shortages, damages, and variances.
• Identify recurring failure points and collaborate with Warehouse and Ops to tighten controls.
• Build executive dashboards showing dollars at risk, variance by root cause, and recovery opportunities.
• Collaborate with Engineering, Warehouse, Accounting, and Amazon Operations on data quality and process fixes.

Skills

SQL

Excel

Data analysis

Amazon FBA experience

Attention to detail

Tools

Power BI

Looker

Tableau

SP-API datasets

Job description

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

Growth & Career Opportunities at Luminize

At Luminize, growth isn't just something we drive for our clients, it's our mindset and a big priority for our people.

We offer clear career paths and leveling guidelines so you always know where you stand, what's next, and what skills and experience you need to get there. From day one, you'll have visibility into advancement opportunities and what it takes to grow into leadership, specialization, or other cross-functional roles.

We're proud of our strong track record of promoting from within. Many of our team leads and managers started in individual contributor roles and grew by consistently showing initiative, curiosity, and impact. We only hire externally when needed, because we believe the best future leaders are often already here.

You'll also benefit from:

• Mentorship from experienced managers during 1:1s and annual performance reviews.
• Cross-functional exposure to departments including content, brand management, software, supply chain, operations, and catalog.
• Learning resources, including Udemy course access, and additional training programs and courses.
• A culture that encourages asking questions, trying new things, and leveling up together.

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

About Luminize

Luminize is a full-service Amazon growth partner helping brands achieve next-level success in a competitive digital marketplace. From creative strategy to advertising and analytics, we combine expertise and hustle to fuel results for brands in CPG, health, wellness, beauty, and beyond.

We're not your typical agency, and we like it that way. We operate with transparency, celebrate wins often, and treat every brand like it's our own.

If you're ready to work with great people, do work that matters, and keep growing, we would love to meet you!