Analyst, Retail Expansion & Property - (011 - 0684)

Hunt St Pty Ltd; Manila; Remote; PHP 600,000 - 900,000; Full time

Job summary

Hunt St Pty Ltd is seeking an Analyst, Retail Expansion & Property based in the Philippines or Malaysia to support its Southeast Asia store network and development projects. You will build financial models, analyze performance, and research locations for potential expansion, while coordinating with senior stakeholders across time zones.

The role emphasizes Excel analytics, data handling, and the ability to manage multiple workstreams remotely.

Qualifications

• 3–6 years of experience in financial analysis, FP&A, or property/retail analysis.
• Strong Excel modelling, scenario/sensitivity analysis, and auditing.
• Experience building and explaining financial models and calculations.
• Excellent data cleaning, reconciliation, and multi-source data handling.

Responsibilities

• Build and maintain financial models for retail networks (sales forecasts, P&L, CAPEX, ROI).
• Gather, clean, reconcile, and validate client data across datasets.
• Analyze store performance and assumptions to guide site selection/expansion.
• Maintain templates, deal trackers, and project schedules for the property platform.
• Upload data, test calculations, and coordinate fixes with the platform team.
• Update forecasts with actuals as stores begin trading.

Skills

Advanced Excel

Data analysis

English comms

Independent work

Remote collaboration

Tools

Power BI

Power Query

SQL

Job description

Looking for Philippines-based or Malaysia-based candidates

Job Role: Analyst, Retail Expansion & Property
Compensation range: TBA
Engagement type: Potentially through a local Employer of Record
Work Schedule: Full-time, Monday to Friday, during local working hours, with daily overlap until 3 PM Australian Eastern Standard Time (AEST).

Who We Are: At Hunt St, we help Australian companies hire top remote talent in the Philippines. For this role, the employment arrangement will be confirmed based on the successful candidate's location and the client's requirements. All of our roles are remote, allowing you to work from home.

Who the Client Is: a company that supports international retail expansion and property development projects across Southeast Asia. The team works with retail businesses on store network planning, financial modelling, property negotiations, and store development. The group is also involved in property acquisition, development, and renovation projects.

Role Overview: The client is looking for an Analyst, Retail Expansion & Property to support its retail consulting and property development work across Southeast Asia. You will work closely with the Head of Analysis, the engagement lead, and the store development lead to build financial models, analyse retail performance, research potential store locations, and track property deals and development projects.

A key part of the role will involve helping maintain a property platform that brings together store network plans, financial models, deal trackers, and project schedules. When retail consulting work is quieter, you will also support property acquisition, development, and renovation projects.

This role suits an analytical and organised professional who is confident working with Excel, comfortable handling large datasets, and able to manage multiple workstreams independently.

Key Responsibilities:

• Build and maintain financial models for retail store networks, including sales forecasts, market profit and loss (P&L), capital expenditure (CAPEX), and return on investment (ROI).
• Gather, clean, reconcile, and validate sales, cost, labour, freight, property, and other client data.
• Analyse store performance and financial assumptions to support decisions about store locations and expansion plans.
• Maintain financial models, deal trackers, store audit templates, work schedules, and other inputs for the company's property platform.
• Upload and validate data, test model calculations and reports, identify issues, and coordinate fixes with the platform developer.
• Update forecasts with actual store performance once locations begin trading.
• Research shopping centres, landlords, rental terms, vacancies, potential franchise partners, and competing brands across Southeast Asia.
• Compare landlord offers and lease terms, including rent, service charges, incentives, fit-out periods, and other commercial conditions.
• Prepare meeting briefs, reports, presentations, meeting minutes, and action trackers for client and internal meetings.
• Support store development by collating drawings, specifications, contractor quotes, fit-out costs, and construction schedules.
• Track project milestones, budgets, procurement timelines, and long-lead items to help identify potential delays.
• Support property acquisition, development, and renovation feasibility models, budgets, cash flow forecasts, and project reporting when retail consulting work is quieter.
• Maintain consistent templates, documentation, and trackers across projects.
• Communicate clearly with stakeholders, follow up on outstanding inputs, and flag risks or delays early.

Requirements

• 3–6 years of experience in financial analysis, financial planning and analysis (FP&A), property analysis, retail analytics, or a Big 4 or consulting analyst role.
• Advanced Excel skills, including financial modelling, scenario and sensitivity analysis, formula auditing, and error checking.
• Experience building, maintaining, and reviewing financial models, with the ability to explain assumptions and calculations clearly.
• Strong data analysis skills, including cleaning, reconciling, and combining information from multiple sources.
• Understanding of retail or property economics, including sales per square metre, gross profit, rent, occupancy costs, lease terms, and fit-out costs.
• Strong written and spoken English, with the ability to prepare clear, concise, client-ready reports.
• Excellent organisational and problem-solving skills, with the ability to manage multiple projects and deadlines.
• Ability to work independently, follow up on missing information, and communicate issues proactively.
• Comfortable collaborating remotely with stakeholders across different time zones.

Highly Desirable:

• Experience with multi-site retailers, franchise businesses, shopping centre operators, property companies, or retail consulting.
• Familiarity with Southeast Asian markets, particularly the Philippines, Malaysia, Indonesia, or Singapore.
• Experience with project scheduling, Gantt charts, procurement tracking, or store development programmes.
• Working knowledge of Power BI, Power Query, or SQL.
• Experience 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 advantageous.