We're looking for a highly analytical and business-oriented Strategy Planner to support daily and weekly customer segment strategy, campaign planning logic, and growth opportunity identification. This role works closely with the CRM Planner, Campaign Team, Commercial Teams, and IP Team to drive customer-centric strategies that improve sales, frequency, and new customer acquisition. Ideal for someone who is data-driven, structured, and proactive, with strong experience in segmentation, funnel analysis, and retail/eCommerce strategy.
Daily & Weekly Strategic Monitoring
- Monitor daily segment performance across segments (HORECA / Food Retailer / End User Region Tier).
- Track key funnel metrics (CTR, CVR, AOV, Frequency, Traffic contribution) and flag abnormal trends or opportunities.
- Provide daily insights that guide Makro's national + regional strategy adjustments.
Customer Segment Strategy
- Analyze customer behavior clusters and propose strategic actions for new customer acquisition, churn winback, low-frequency improvement, high-value retention, regional and category-based segment growth
- Maintain and refine customer segmentation logic with BI and CRM Planner.
Growth Opportunity Planning
- Identify cross-selling, regional opportunity areas, seasonal boosts, and customer segment white spaces.
Campaign & Portfolio Integration
- Align segment strategy with major campaigns (Double Day, Brand Day, SEA Games, Holiday, Hamper).
- Define strategic targeting and expected uplift per segment.
Data & Insight Reporting
- Produce daily/weekly dashboards summarizing traffic, conversion, and segment shift.
- Build storyline and insights for leadership review and decision-making.
- Ensure data accuracy and alignment with CRM/BI systems.
Requirements
- Bachelor's Degree in Business Analytics, Marketing, Statistics, Economics, or related field.
- At least 5 years of experience in Strategy, CRM Analytics, Retail Planning, eCommerce, or BI-related roles.
- Strong analytical skills and proficiency in Excel/Google Sheets; BI dashboard experience preferred.
- Strong understanding of customer segmentation and funnel-based performance metrics.
- Ability to synthesize data into actionable insights and strategies.
- Structured communicator with strong coordination capability across teams.
- English proficiency for cross-functional collaboration.
- High ownership, problem-solving attitude, and ability to manage time-sensitive tasks.
