Business Analyst Retail

Total years of experience needed: 3+yrs Key Responsibilities Advanced Analytics & Root-Cause Analysis Root-Cause Analysis (RCA): Lead RCAs on volatile business shifts (e.g., sudden sales dips, inventory stockouts, or spikes in returns and shrinkage) and deliver quick-turnaround, actionable recommendations.Cohort & Funnel Analysis: Apply cohort analysis, funnel tracking, and statistical forecasting techniques to predict peak seasonal retail demand (holiday, promotional, back-to-school, and other high-volume periods).Decision Models: Build heuristic and predictive models to uncover opportunities for incremental revenue and operational efficiency across stores and categories.BI Engineering & Data Architecture Data Visualization: Build and maintain enterprise-level Power BI dashboards using DAX and Power Query to surface store, category, and executive-level insights.ETL Pipeline Support: Support the development and ongoing execution of data pipelines using SSIS, SSAS, or modern data orchestration tools.Data Quality Assurance: Own SQL views, stored procedures, and data models that feed reporting and analytics, ensuring data validity and consistency.Collaboration & Stakeholder Management Cross-Functional Partnership: Act as a key analytics partner to Product, Merchandising, Store Operations, and Engineering teams, translating raw data into decisions and feature improvements.Knowledge Sharing: Support and mentor junior analysts on analytical approach, SQL, and dashboard best practices.Strategic Business Drive & Domain Analytics Revenue & Pricing Optimization: Analyze demand-supply gaps, inventory utilization, and pricing effectiveness across stores, categories, and regions.Conversion & Funnel Management: Deep-dive into customer checkout behavior, cart and basket drop-offs, and return or cancellation bottlenecks to drive retention.Campaign & Loyalty Analysis: Partner with marketing teams to design, track, and optimize loyalty programs and promotional campaigns. .