Data Analyst - Sales & Inventory

Data Analyst - Inventory & Sales Analytics

The role

We run 50 QSR stores and we're still scaling. At this size, decisions can't run on gut feel - they run on numbers. We're hiring a Data Analyst who wants to go deep on the two things that make or break a multi-store food business: inventory and sales.

This isn't a generic dashboarding job. You'll specialise. You'll become the person who knows exactly why COGS moved two points last month, which SKUs are dead weight, and where stock is quietly leaking across 50 kitchens.

What you'll own

• Weekly and monthly sales reports across stores, channels (dine-in, Swiggy, Zomato), and categories - with the story behind the numbers, not just the numbers
• Store-level inventory tracking: consumption, wastage, variance, and days-of-cover
• Turning POS and stock data into indents, reorder alerts, and min-stock triggers
• COGS analysis by store, category, and SKU - flagging what's pushing margin up or down
• Spotting outliers early: the store over-ordering, the item bleeding margin, the channel underperforming
• Clean, repeatable reporting the ops team can actually act on

What we're looking for

• 2-4 years in data analysis, ideally retail, F&B/QSR, or FMCG
• Advanced Excel - pivots, lookups, nested formulas - this is non-negotiable
• SQL and comfort with a BI tool (Power BI / Looker / Metabase)
• Ability to wrangle messy, real-world POS exports into something clean and trustworthy
• A commercial head: you understand that a report is only useful if it changes a decision

Bonus points

• Hands-on with Petpooja or a similar restaurant POS
• You get restaurant unit economics - COGS, yield, wastage, contribution margin
• Python/pandas to automate the repetitive stuff

What success looks like (first 6 months)

• Sales and inventory reporting runs like clockwork, with zero manual firefighting
• Ops can see stock health across all 50 stores at a glance
• At least three margin or waste leaks identified and closed
• Leadership stops asking "what happened?" because the report already answers it