Job Description

Roles & Responsibilities

Job Purpose

The Retail Analyst is responsible for supporting the Leasing Department through accurate data management, sales tracking, revenue reporting, rent roll updates, tenant performance monitoring, and preparation of leasing analysis. The role ensures that leasing decisions are supported by reliable data, updated reports, and clear performance insights across retail and specialty leasing units.

Key Responsibilities

1. Sales, Revenue & Leasing Tracking

• Collect monthly sales reports from tenants in line with lease requirements.
• Track tenant sales submissions and follow up on pending or missing reports.
• Update sales data in the system and maintain accurate historical records.
• Monitor tenant performance, sales trends, and revenue contribution.
• Support calculation and tracking of turnover rent where applicable.
• Track retail leasing, and specialty leasing revenue.
• Maintain leasing trackers, expiry schedules, and payment status where required.

2. Rent Roll & Leasing Data Management

• Maintain and update the retail and specialty leasing rent roll.
• Ensure accuracy of tenant information, unit details, lease terms, rent, service charges, expiry dates, deposits, and contract status.
• Coordinate with lease administration to ensure system records match approved lease documents.
• Flag data discrepancies and follow up until corrected.

3. Performance Reporting

• Prepare weekly and monthly leasing reports for management review.
• Support analysis of occupancy, vacancy, leased GLA, revenue, expiries, renewals, pipeline status, and specialty leasing performance.
• Prepare dashboards and summaries showing tenant performance, rental income, specialty leasing revenue, and collection status.
• Assist in preparing reports for internal meetings, management updates, and ownership presentations.

4. Tenant & Category Analysis

• Analyze tenant performance by category, zone, unit size, and rental structure.
• Support comparison of existing tenants against market benchmarks where required.
• Identify underperforming units or categories based on available data.
• Assist leasing team in evaluating replacement opportunities, renewal cases, and commercial proposals.

5. System & Document Support

• Update leasing systems with approved commercial terms, tenant sales, contract milestones, and invoicing information.
• Maintain organized records of reports, approvals, tenant submissions, and supporting documents.
• Coordinate with Finance, Lease Administration, Operations, and other internal departments to ensure data accuracy.

6. Ad Hoc Support

• Carry out ad hoc tasks and provide additional support to the Leasing Department and management as required from time to time.

Required Skills & Competencies

• Strong Excel skills, including formulas, pivot tables, lookups, and data cleaning.
• Ability to prepare clear reports, dashboards, and summaries.
• Strong attention to detail and accuracy.
• Good understanding of retail leasing, rent structures, sales reporting, and occupancy metrics.
• Ability to follow up with tenants and internal departments professionally.
• Good analytical and numerical skills.
• Ability to work under deadlines and manage recurring reporting cycles.
• Strong written and verbal communication skills.
• Ability to identify inconsistencies in data and escalate issues appropriately.

Minimum Qualifications

• Bachelor s degree in Business Administration, Finance, Real Estate, Economics, or a related field.
• 2 4 years of experience in retail leasing analysis, mall management, commercial real estate, finance reporting, or business analysis.
• Experience in a shopping mall, retail asset, mixed-use destination, or commercial real estate environment is preferred.

Preferred Experience

• Experience with rent rolls, tenant sales reports, turnover rent, occupancy tracking, and leasing dashboards.
• Knowledge of retail, F&B, kiosks, and specialty leasing categories.
• Experience working with Leasing, Finance, Operations, and Lease Administration teams.
• Familiarity with ERP, property management, or leasing management systems.

Key Performance Indicators

• Accuracy of rent roll and leasing data.
• Timely collection and updating of tenant sales reports.
• Timely delivery of weekly and monthly reports.
• Quality and clarity of analysis provided to management.
• Reduction in data discrepancies between leasing, finance, and system records.
• Effective tracking of revenue, occupancy, expiries, tenant performance, and specialty leasing performance.