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
Create and manage dynamic dashboards (using Power BI, Python, etc.) to support decision- making across departments.
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.
Ensure data accuracy, completeness, and usability across site analysis models and reporting systems.
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).
Store Performance Analysis
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.
Conduct quarterly performance reviews of new and existing stores, analyzing post- opening performance vs. forecast.
Cross- functional Collaboration & Reporting
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.
Collaborate with Site Analysis Executives and cross- functional partners in Marketing, Operations, and Finance to align data requirements and strategic goals.
Respond to ad- hoc analysis requests related to expansion, renewal, or performance diagnostics based on business needs.
