(Senior) Data Analyst

Job Overview:

The (Senior) Data Analyst supports the Site Analysis Manager in driving data-informed decision-making for site selection and new store openings (NSO) strategy. This role manages cluster-level master data, conducts in-depth analysis, and delivers revenue forecasts, store analog assessments, and post-opening performance reviews - translating insights into clear, actionable stories that support Network Expansion strategy.

Key accountabilities:

Data Management & Analytical Modeling

• Build and maintain master datasets for cluster mapping, store characteristics, and trade area profiling.
• Enhance the Store Analog database to benchmark new sites against similar high-performing stores.
• Develop and maintain a Rental Profile database, capturing rent levels, rent-to-revenue ratios, and lease benchmarks to support site selection and contract renewals.
• Support modeling tools to evaluate key site factors (e.g., visibility, layout, accessibility) and forecast revenue, CAPEX, and Box of Economy (BOE).
• Ensure data accuracy, completeness, and usability across site analysis models and reporting systems.
• Create and manage dynamic dashboards (using Power BI, Python, etc.) to support decision-making across departments.

Store Performance Analysis

• Conduct quarterly performance reviews of new and existing stores, analyzing post-opening performance vs. forecast.
• Analyze store performance prior to contract renewal, identifying risks and opportunities to support go/no-go decisions.
• Identify drivers of performance variance and provide recommendations for network optimization or strategy refinement.

Cross-functional Collaboration & Reporting

• Collaborate with Site Analysis Executives and cross-functional partners in Marketing, Operations, and Finance to align data requirements and strategic goals.
• Support the Site Analysis Manager in preparing strategic reports, presentations, and proposals for Head of Department (HOD) and relevant Departments.
• Prepare and deliver the monthly SND Committee report, consolidating key findings from site evaluation, store performance, and rental benchmarks.
• Respond to ad-hoc analysis requests related to expansion, renewal, or performance diagnostics based on business needs.

• Bachelor's degree in Management Information Systems/ Data Analysis/ Business Administration/ Marketing or a related field.
• 03+ years of experience in data analytics, preferably in market research, marketing, or sales analytics roles, preferably in the food & beverage/ retail industry.
• Experience working with large datasets and building analytical models; location-based or site analysis experience is a plus.
• Experience using Power BI, Data Studio, SQL, etc.
• Good analytical skills and strong communication and interpersonal skills
• Detail-oriented, proactive and self-motivated with a strong problem solving skill.

• Qualification: Bachelor
• Age: Unlimited
• Job type: Permanent