Senior Commercial Planning & Strategy

AlloFresh; Jakarta Pusat; On-site; IDR 178,560,000 - 401,760,000; Full time

Job summary

AlloFresh is seeking an experienced commercial analytics professional to drive growth and profitability through data-driven insights. You will monitor GMV, MTU, AOV, and other KPIs, evaluate campaigns and promotions, and model promo economics to inform decision making.

The role requires advanced Excel/Sheets and SQL, strong BI tool experience, and the ability to translate complex data into practical recommendations for business growth and customer engagement.

Qualifications

• 5+ years of experience in commercial analytics in e-commerce, retail, or consumer internet.
• Advanced Excel/Google Sheets and SQL skills for modelling scenarios and turning data into insights.
• Strong understanding of e-commerce metrics such as GMV, MTU, AOV, GM%, GP%, funnel, cohort, and RFM.
• Ability to design and evaluate promotional schemes with margin impact and customer targeting.
• Strong written and verbal communication skills to translate analysis into actionable recommendations.
• Proficiency with AI tools to automate repetitive tasks and boost productivity.
• Experience with BI and data visualization tools such as Metabase, Tableau, Looker or equivalent.

Responsibilities

• Analyze commercial performance and monitor key KPIs (GMV, MTU, AOV, GM%), identify trends, gaps, and risks.
• Evaluate campaign and promo performance, including uptake, GMV contribution, basket composition, user segments, and margin impact.
• Model promotional mechanics and target customers, defining promo economics and basket profiles.
• Assess post-campaign effectiveness, retention, behavioral changes, and margin impact.
• Monitor competitors and market developments, turning findings into actionable insights.
• Support ad-hoc, data-driven analyses to answer strategic and operational questions.

Job description

This role will analyze commercial performance, evaluate campaigns, identify growth opportunities, and provide recommendations to drive growth, customer engagement, and profitability.

Key Responsibilities

• Commercial performance analysis: monitor key metrics such as GMV, MTU, AOV, GM%, GP%, and other commercial KPIs; identify trends, gaps, opportunities, and risks.
• Campaign & promo monitoring: monitor campaign and promotion performance, including uptake, GMV contribution, basket composition, user segments, and margin impact; highlight issues and opportunities early.
• Cross-initiative impact analysis: assess the expected and actual impact of business initiatives on sales, customers, profitability, and other relevant metrics.
• Promotion scheme design: support the development of promotional mechanics by modeling their potential impact on GMV, MTU, GM%, and GP%; help define target customers, basket profiles, and promo economics.
• Post-campaign analysis: evaluate campaign effectiveness, identify whether growth was truly incremental or temporary, and assess customer retention, behavioral changes, and margin impact.
• Competitive & market monitoring: monitor competitor activities and market developments; turn findings into clear insights and recommendations for the business.
• Ad-hoc commercial analysis: support various strategic and operational business questions through timely, data-driven analysis and deep dives.

Requirements

• Flexible and agile mindset: comfortable working beyond a fixed job scope and adapting to changing priorities as the business grows; willing to take on new challenges and contribute wherever analytical support is needed.
• 5+ years of experience in commercial analytics, business analytics, or another data-heavy role within e-commerce, retail, or consumer internet.
• Advanced Excel / Google Sheets and/or strong SQL skills, with the ability to build models, run scenario analysis, and turn data into structured insights.
• Strong understanding of e-commerce metrics such as GMV, MTU, AOV, GM%, GP%, funnel, cohort, and RFM, with the ability to understand what these metrics mean for business performance.
• Ability to design and evaluate promotional schemes, with an understanding of promo mechanics, margin impact, customer targeting, basket behavior, and incremental growth.
• Strong written and verbal communication skills, with the ability to explain analysis clearly and turn findings into practical business recommendations.
• Proficiency in using AI tools to support analysis, automate repetitive tasks, improve productivity, and solve problems more efficiently.
• Experience with BI and data visualization tools such as Metabase, Tableau, Looker, or equivalent will be huge advantage
• Good understanding of in-app funnels, user journeys, growth analytics, and customer behavior will be a plus