Analyst, Retail Expansion – Property

This is a fully remote position, open to applicants in Philippines, +1 more country.

📋 Description

• Develop and sustain financial models for retail store networks, encompassing sales projections, market profit and loss (P&L), capital expenditure (CAPEX), and return on investment (ROI).

• Collect, cleanse, reconcile, and verify sales, cost, labor, freight, property, and various client data.

• Evaluate store performance and financial assumptions to inform decisions regarding store locations and expansion strategies.

• Manage financial models, deal trackers, store audit templates, work schedules, and other resources for the company's property platform.

• Upload and validate data, assess model calculations and reports, identify issues, and work with the platform developer to coordinate resolutions.

• Revise forecasts with actual store performance data once locations commence trading.

• Conduct research on shopping centers, landlords, rental agreements, vacancies, potential franchise partners, and competing brands throughout Southeast Asia.

• Assess landlord proposals and lease terms, including rent, service charges, incentives, fit-out periods, and other commercial conditions.

• Create meeting briefs, reports, presentations, meeting minutes, and action trackers for both client and internal meetings.

• Assist store development by gathering drawings, specifications, contractor quotes, fit-out expenses, and construction timelines.

• Monitor project milestones, budgets, procurement schedules, and long-lead items to identify possible delays.

• Support property acquisition, development, and renovation feasibility models, budgets, cash flow forecasts, and project reporting during quieter retail consulting periods.

• Ensure consistent templates, documentation, and trackers are maintained across projects.

• Communicate effectively with stakeholders, follow up on outstanding inputs, and proactively highlight risks or delays.

⛳️ Requirements

• 3–6 years of experience in financial analysis, financial planning and analysis (FP&A), property analysis, retail analytics, or a role as an analyst in a Big 4 or consulting firm.

• Proficient in advanced Excel skills, including financial modeling, scenario and sensitivity analysis, formula auditing, and error checking.

• Experience in building, maintaining, and reviewing financial models, with the capability to clearly explain assumptions and calculations.

• Strong data analysis skills, including the ability to clean, reconcile, and synthesize information from various sources.

• Knowledge of retail or property economics, including sales per square meter, gross profit, rent, occupancy costs, lease terms, and fit-out expenses.

• Excellent written and verbal English skills, with the ability to create clear, concise, client-ready reports.

• Outstanding organizational and problem-solving abilities, with the capacity to manage multiple projects and deadlines.

• Capability to work autonomously, follow up on missing information, and communicate issues proactively.

• Comfortable collaborating remotely with stakeholders across various time zones.

• Experience with multi-site retailers, franchise businesses, shopping center operators, property companies, or retail consulting.

• Familiarity with Southeast Asian markets, particularly the Philippines, Malaysia, Indonesia, or Singapore.

• Background in project scheduling, Gantt charts, procurement tracking, or store development programs.

• Working knowledge of Power BI, Power Query, or SQL.

• Experience in supporting SaaS platform implementation, data migration, or system testing.

• Experience with store fit-outs, construction costs, property development feasibility, or an accounting qualification would also be a plus.

🏝️ Benefits

• All positions are remote, enabling you to work from the comfort of your home.