Assistant Manager - Business Intelligence & Commercial Planning Analyst

Assistant Manager - Business Intelligence & Commercial Planning Analyst

Responsibilities

1. Business Intelligence & Data Analytics (40%)

Collect, validate and structure data from various sources such as CRM, Timeshareware, and internal databases
Design, develop, and maintain structured BI solutions and data models using Power BI or Tableau, for reports and dashboards
Construct specialized data models and ETL based on business requirements
Define and track KPIs and performance metrics to monitor business results
Automate reporting processes to reduce reliance on manual Excel work
Ensure data accuracy, consistency, and resolve data-related issues

1. Commercial Pricing & Performance Analytics (30%)

• Design and maintain a structured commercial dataset covering units, pricing, sales status, cost, and promotions
• Ensure pricing is aligned with cost inputs, target margins, and project positioning strategy
• Track and structure all promotions, discounts, and incentive schemes across projects
• Evaluate campaign effectiveness in terms of inquiries, inspection, sales conversion, pick-up pace, and margin impact
• Monitor and analyze sales velocity, absorption rate, and performance trends across unit types and price segments
• Identify opportunities for price optimization, yield improvement, and inventory release strategy

1. Feasibility & Sales Analysis (15%)

• Support development of project feasibility models
• Conduct scenario analysis on revenue, cost, margin, and sales pace/absorption
• Assist in evaluating project performance against business targets
• Provide analytical support for investment and development decisions

1. Cash Flow Model Management (15%)

Assist in maintaining and updating project cash flow models

Track assumptions including project launch, sales progress, construction cost, and cash collection

Support sensitivity analysis and scenario testing

This role may involve data validation and minor data input where required, but the primary responsibility is to structure data, ensure integrity, and derive insights to support commercial decision-making.

This role supports the transition from Excel-based reporting to a more structured, data-driven commercial platform, where Excel remains a working tool while Power BI and structured data models are increasingly used to standardize reporting, analytics, and decision-making

Requirements

3-5 years of experience in BI, commercial/data analytic, business analyst, or financial analyst roles
Strong hand-on experience with BI tools such as Power BI or Tableau, including dashboard design and data visualization
Strong proficiency in macro, SQL, Excel
Strong analytical thinking, problem-solving mindset with focus on process improvement and automation
High attention to detail with ability to manage complex datasets
Self-motivated, able to work independently with minimal supervision, and across departments
Able to balance technical execution with commercial understanding
Understanding of finance concepts is an advantage