مدير تحليل الأعمال

Responsibilities:

• Prepare feasibility studies for new phases in Makadi Heights and O West, and for product or phasing changes, under the direction of the Director of Business Analysis.
• Develop development scenarios (land-use mix, product mix, unit sizes, phasing, construction cost and timeline) using inputs from Design & Development and Project Management.
• Benchmark the market and competitors on pricing, payment plans, absorption rates and product offering to support the business case.
• Prepare investment papers and presentations for management, stating returns, risks, sensitivities and a clear recommendation.
• Build and maintain detailed project-level development financial models using agreed structures, assumptions and accounting treatment.
• Calculate and monitor investment indicators: IRR, NPV, gross and net margins, payback period and peak funding requirement.
• Run sensitivity and scenario analysis on selling prices, cost escalation, inflation, FX, sales velocity and collection rates.
• Prepare the five-year business plan for the destinations, covering launches, sales, collections, construction spend, deliveries and cash flow.
• Work with different departments to keep the plan aligned with the development pipeline, construction schedules and sales targets and highlight any deviations from the approved plan.
• Support in the development of annual budget and periodic re-forecasts.
• Assess the impact of payment plans and discounts on NPV and cash flow to support approval decisions.
• Monitor sales performance and market movements, and propose price revisions to protect margins and absorption.
• Track actual project performance (sales, achieved prices, costs, cash flow) against the approved feasibility study and business plan.
• Issue the monthly project performance pack and dashboards for management, and lead post-launch reviews that feed lessons into future studies.
• Define and maintain the project KPIs and recommend corrective actions when results drift from plan.
• Keep one approved, version-controlled set of models and assumptions, and protect the confidentiality of commercial information.
• Automate recurring reports with advanced Excel, and document methods, templates and review controls so outputs are consistent and auditable.

Requirements:

• Bachelor's degree in Finance, Economics, Business Administration, Engineering or Architecture.
• MBA or master's in Finance or Real Estate is preferred.
• CFA, CMA or RICS certified in valuation is an advantage.
• At least 8 years of experience, with at least 4 in real estate development feasibility, financial modelling or investment analysis.
• Proven experience in master-planned or mixed-use developments in Egypt, including pricing and payment-plan design for off-plan sales.
• Experience supervising or reviewing the work of analysts.
• Track record of presenting analysis to senior management.
• Advanced Excel financial modelling (DCF, IRR, NPV, scenario and sensitivity analysis).