Manager - O2O Commercial Intelligence
Lotus's · Bueng Kum district, Bangkok City, Thailand
Apply & track with Apply EdgeDevelop and deliver Commercial Intelligence analytics, scorecards, and actionable recommendations by translating business, categ ory, SKU, pricing, assortment, and performancedata into reliable insights that improve commercial decision making across Online and Offline channelsResponsibilities1. Commercial Scorecard & KPI ManagementDevelop and maintain commercial scorecards and KPI dashboards covering sales, category, SKU, pricing, assortment, NPD, and other agreed commercial metrics.Monitor performance against targets and identify key gaps, trends, and opportunities.2. Category & SKU Performance AnalyticsAnalyze category and SKU performance to identify growth opportunities, underperformance, productivity gaps, and portfolio opportunities.Provide analytical insights to support category and commercial reviews.3. SKU Range In/Out RecommendationsAnalyze SKU productivity, sales contribution, customer demand, and relevant commercial indicators to support range in/out recommendations.Establish fact based criteria and analytical outputs for assortment decisions.4. NPD & Assortment Opportunity IdentificationIdentify NPD, assortment expansion, rationalization, and portfolio optimization opportunities through data analysis.Develop opportunity sizing and supporting business cases where required.5. Pricing & Promotion IntelligenceAnalyze pricing competitiveness, price performance, promotional effectiveness, and relevant commercial indicators.Provide actionable pricing and promotion recommendations based on available internal and external data.6. Commercial Insights & RecommendationsTranslate analytical findings into concise, business oriented recommendations for commercial stakeholders.Support monthly and quarterly commercial reviews with relevant insights, analysis, and recommendations.7. Data, Dashboard & Analytical ExcellenceEnsure accuracy, consistency, timeliness, and usability of commercial data, dashboards, and analytical outputs.Improve reporting and analytical processes through automation, standardized methodologies, and appropriate BI tools.8. Stakeholder CollaborationWork closely with Merchandising, E Commerce, Marketing, Finance, Supply Chain, Technology & Data, and other relevant teams to understand business questions and deliver fit for purpose analysis.Follow through on agreed recommendations and track actions and outcomes with business owners.Key skillsBachelor’s or Master’s degree in Business Administration, Economics, Finance, Statistics, Data Analytics, Marketing, Engineering, or related fields.8+ years of relevant experience in commercial analytics, business intelligence, category management, strategy, consulting, e commerce, retail, FMCG, or related fields.Experience developing commercial dashboards, scorecards, business analysis, and actionable recommendationsExperience working with cross functional stakeholders in a commercial or business environment.Experience in retail, e commerce, omnichannel, or O2O business is preferred.Good English communication skills.Strong commercial and business analytics capability.Strong understanding of category, SKU, assortment, pricing, promotion, NPD, and commercial performance analysis.Ability to develop KPI scorecards, dashboards, management reports, and analytical models.Strong Excel and data analysis skills; experience with Power BI, SQL, Python, or similar analytical tools is preferred.Ability to work with large and complex datasets and convert data into practical business insights.Understanding of retail, e commerce, omnichannel, FMCG, marketplace, or commercial business models is preferred.