About Swiggy
From starting out as a hyperlocal food delivery service in 2014, to becoming India s leading on-demand convenience platform today, our capabilities result not only in lightning-fast delivery for customers, but also in a productive and fulfilling experience for our employees
Role Overview
The Business Associate - Assortment mSKU Architecture will support the creation, maintenance, and optimization of Instamart s platform-wide master SKU list. This role is critical in enabling data-backed decisions on assortment width, breadth, and depth, and ensuring that category proposals align with established guardrails.
The analyst will work closely with the Senior Manager - Assortment Design, Category teams, Analytics, Product, and Supply to build scalable frameworks, automate checks, and produce insights that shape Instamart s assortment strategy.
1. mSKU Architecture Assortment Guardrails - Support the development and maintenance of the platform-wide master SKU (mSKU) list.
- Operationalize assortment guardrails for width (category coverage), breadth (variety), and depth (pack sizes/SKUs).
- Build rule-based and data-driven checks to ensure category-proposed SKUs meet eligibility criteria.
2. Assortment Analytics Insights - Analyze SKU performance across velocity, contribution, coverage, substitution, and customer demand.
- Identify assortment gaps across price points, pack sizes, brands, and sub-categories.
- Track trends using internal signals, competition crawls, and search behavior to recommend new mSKUs.
- Monitor redundancy and SKU proliferation; recommend SKU exits to improve operational efficiency.
3. Tooling, Automation Dashboarding - Work with Product, Data Engineering, and Internal Tools teams to automate guardrail checks.
- Build and maintain dashboards for assortment health, mSKU compliance, new SKU performance, and category gaps.
- Develop scripts or automated workflows for data cleaning, SKU mapping, and guardrail validation.
4. Cross-Functional Collaboration - Partner with Category Managers to evaluate SKU onboarding requests.
- Collaborate with Consumer Insights to integrate qualitative learnings.
- Work with Supply/Planning to ensure depth decisions align with demand patterns.
5. Reporting Documentation - Create clear documentation for guardrails, eligibility rules, taxonomies, and SKU validation logic.
- Present insights and recommendations to leadership on assortment improvements.
Technical Skills Requirements:
- Ability to design and optimize
LLM prompts
and work with GPT-based architectures for automation, classification, and enrichment use cases. - Experience working with or supporting
web scraping, competition crawls, or automated data ingestion pipelines
. - Strong proficiency in
SQL
for data extraction and transformation. - Hands-on experience with
Python
(Pandas, NumPy) for data analysis and automation. - Expertise in
Excel/Google Sheets
for quick analysis and scenario modeling. - Experience building dashboards using
Tableau, Power BI, or Looker
. - Ability to work with large datasets and build scalable analytical workflows.
- Familiarity with taxonomy, catalog data, and recommendation systems preferred.
- Experience with API-based data ingestion, web crawling data, or catalog data structures is a plus.
Core Competencies:
- Strong analytical and problem solving skills.
- High attention to detail and ability to work with complex datasets.
- Ability to translate ambiguous business problems into structured analytical frameworks.
- Strong communication skills for cross-functional alignment.
- Bias for action and comfort with fast-paced, evolving environments.
Experience Qualifications:
- 2-5 years of experience in analytics, business intelligence, category analytics, or product analytics.
- Experience in e-commerce, retail, FMCG, or quick commerce preferred.
- Bachelor s degree in Engineering, Mathematics, Economics, Statistics, or similar quantitative fields.
Success Metrics:
- Accuracy and reliability of mSKU guardrail automation.
- Reduction in duplicate, redundant, or low-value SKUs.
- Faster and more consistent validation of category-proposed SKUs.
- Improved assortment coverage, depth accuracy, and alignment with customer demand.
- Adoption of dashboards and tools by cross-functional teams.