Commercial Planning Coordinator

Description

Job Summary: We are seeking a Commercial Planning Coordinator to support strategic decisions in purchasing, distribution, inventory management, and store performance, combining data analysis with deep understanding of the fashion business. Key Highlights: 1. Focus on quantitative data and fashion business analysis 2. Balance among sales, inventory, margin, and product turnover 3. Strong analytical profile for strategic decision-making **Department:** Commercial Planning / BI / Merchandising **Level:** Junior **Employment Type:** CLT (Consolidated Labor Law contract) **Working Hours:** 8 hours/day, Monday to Friday **Work Model:** On-site **Location:** São Cristóvão – Rio de Janeiro / RJ **About the Position** We seek a Commercial Planning Coordinator with a strong analytical profile to support strategic decisions related to purchasing, product distribution, inventory management, and store commercial performance. This role combines quantitative data analysis with an understanding of the fashion business, aiming to ensure balance among sales, inventory, margin, and product turnover, thereby contributing to commercial performance and business profitability. Join our team and experience this opportunity with us! **Responsibilities and Duties** **Commercial Performance Analysis** * Analyze sales by SKU, category, collection, store, and channel * Monitor KPIs such as sell-through, product mix, inventory turnover, coverage, and margin * Identify opportunities to increase sales, improve margin, and reduce excess inventory **Inventory Management and Planning** * Track inventory levels by store and distribution center * Identify products with stockouts or excess inventory * Propose inter-store product reallocation to optimize turnover **Purchasing Planning** * Support the Purchasing team in defining quantities per product and store allocation * Use historical sales, product performance, and forecasts to guide purchasing decisions * Monitor collection performance throughout the season **Business Intelligence** * Build analytical reports and dashboards for sales and inventory * Consolidate data from multiple systems and databases * Generate analyses to support commercial area decision-making * Develop comparative scenarios and performance projections **Requirements and Qualifications** * Bachelor’s degree in Economics, Engineering, Business Administration, or related fields * Advanced Excel or Google Sheets (pivot tables, analytical functions, large dataset manipulation) * Familiarity with SQL or similar languages for data extraction and organization * Familiarity with retail ERP systems (Linx, Totvs, SAP, or Oracle) * Ability to leverage Artificial Intelligence tools for analytical productivity (data exploration, pattern identification, automation) * Proficiency in data communication and presentation using tools such as PowerPoint, Gamma, Power BI, or Tableau **Profile** * Strong analytical ability and attention to detail * Curiosity and initiative to investigate sales patterns and product behavior * Ability to transform data into actionable insights and practical business recommendations * Strong communication skills and ability to collaborate with commercial, purchasing, and operations teams **Preferred Qualifications** * Prior experience in retail, fashion, or consulting firms * Experience in collection planning or assortment management * Experience in Business Intelligence and data analysis **Additional Information** **What We Offer:** * Meal/food allowance; * Transportation allowance; * Co-payment health and dental plans; * Birthday day off; * Brand product discount; * Discounts at various educational institutions; * Travel agency discounts; * Exclusive training channel for your professional development. ______________________________________________________________________________________ We are one of the leading fashion groups in Brazil, operating approximately 60 stores nationwide with over 30 years of history. The group comprises SACADA, OH BOY, and YOBOH—the teen line of the brand. **SACADA** With 27 stores and over 500 multi-brand points of sale across Brazil, SACADA delivers a sophisticated and elegant aesthetic that defines its trajectory. Each collection draws inspiration from fashion, art, and lifestyle to create new concepts reflecting the desires of the contemporary woman—combined with meticulous material selection to craft versatile and unique pieces. Elegance and modernity define the SACADA woman, who seeks sophistication and practicality for everyday occasions. For her, classic and essential wardrobe items are reinvented to produce collections perfectly aligned with her lifestyle. **OH, BOY!** With 24 owned stores and presence in over 800 multi-brand retailers, OH, BOY! is a Rio de Janeiro–born brand with a relaxed, urban, and youthful essence. This lightness translates into comfortable, feminine, and casual collections that blend diverse influences and styles, reflecting our plural personality. Our modern and distinctive perspective is inspired by daylight and sunshine warmth. Since its inception, denim has been central to our collections—highlighted by exceptional fits, premium materials, and meticulous attention to detail. **We would be delighted to welcome you to our team. Shall we move forward together?**