Business Analyst (Retail Planning & Analytics)

Lenskart; Gurugram District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Lenskart is seeking a diligent Business Planning & Performance Analyst to lead the retail division's planning and AOP tracking. You will work cross-functionally with Finance, Marketing, and Merchandising to align budgeting decisions with growth strategies.

Role requires strong analytics, Excel/SQL skills, and experience with BI tools. You will build predictive models for demand planning and drive improvements in margin and inventory efficiency.

Qualifications

• Bachelor's degree in Engineering or Commerce; MBA or CA preferred.
• 2-4 years of experience in business analysis, buying, merchandising, or planning functions in retail or consumer businesses.
• Strong analytical skills with advanced proficiency in Excel and SQL; familiarity with BI tools like Tableau or Power BI is a plus.
• Ability to influence stakeholders and collaborate effectively across functions.
• Strong business acumen, with a hands-on approach to problem-solving and execution.

Responsibilities

• Lead business planning and Annual Operating Plan (AOP) tracking for the retail division.
• Monitor monthly performance variances, highlight gaps, and suggest agile course corrections to meet business objectives.
• Work closely with Finance, Marketing, and Merchandising teams to enable data-driven decisions around budgeting and investments.
• Align operational and marketing strategies to drive growth and optimize resource allocation.
• Manage Open-to-Buy (OTB), sell-through, and aged inventory analysis to support efficient purchase planning.
• Collaborate with merchandising and finance teams to improve forecasting accuracy and inventory turns.
• Identify and track key levers to grow revenue and improve contribution margins for key product categories.
• Analyze performance drivers and develop actionable insights to support profitability goals.
• Support the scale-up of premium and emerging brands through deep-dive analysis and performance tracking.
• Contribute to strategic growth plans in collaboration with brand and category teams.
• Build and maintain predictive models to support seasonal and long-term demand planning.
• Improve sell-through and inventory efficiency through data-backed insights.

Skills

Excel

Analytical thinking

SQL

Tableau

Power BI

Stakeholder management

Forecasting

OTB

Education

Bachelor's degree in Engineering or Commerce

MBA or CA preferred

Tools

SQL

Tableau

Power BI

Job description

Role & responsibilities

Business Planning & Performance Tracking

• Lead business planning and Annual Operating Plan (AOP) tracking for the retail division.
• Monitor monthly performance variances, highlight gaps, and suggest agile course corrections to meet business objectives.

Cross-Functional Collaboration

• Work closely with Finance, Marketing, and Merchandising teams to enable data-driven decisions around budgeting and investments.
• Align operational and marketing strategies to drive growth and optimize resource allocation.

Merchandise Analytics & Forecasting

• Manage Open-to-Buy (OTB), sell-through, and aged inventory analysis to support efficient purchase planning.
• Collaborate with merchandising and finance teams to improve forecasting accuracy and inventory turns.

Margin & Profitability Initiatives

• Identify and track key levers to grow revenue and improve contribution margins for key product categories.
• Analyze performance drivers and develop actionable insights to support profitability goals.

Brand Strategy Support

• Support the scale-up of premium and emerging brands through deep-dive analysis and performance tracking.
• Contribute to strategic growth plans in collaboration with brand and category teams.

Demand Planning & Predictive Modelling

• Build and maintain predictive models to support seasonal and long-term demand planning.
• Improve sell-through and inventory efficiency through data-backed insights.

Preferred candidate profile

• Bachelors degree in Engineering or Commerce; MBA or CA preferred.
• 2-4 years of experience in business analysis, buying, merchandising, or planning functions in retail or consumer businesses.
• Strong analytical skills with advanced proficiency in Excel and SQL; familiarity with BI tools like Tableau or Power BI is a plus.
• Ability to influence stakeholders and collaborate effectively across functions.
• Strong business acumen, with a hands-on approach to problem-solving and execution.