Commercial Business Analyst

IIBA (International Institute of Business Analysis); Dubai; On-site; AED 120,000 - 160,000; Full time

Job summary

A global business analysis institute located in Dubai is seeking a candidate to lead the commercial finance operations. Responsibilities include providing financial insights to the commercial and marketing teams, supporting monthly financial closing, and performing sales and margin analysis. The ideal candidate should have strong knowledge of P&L management, advanced Excel skills, and a minimum of 5 years of experience in finance. Expertise with ERP systems and BI tools is preferred.

Qualifications

• Strong knowledge of P&L management, financial modeling, and scenario analysis.
• Hands-on experience with ERP systems.
• Minimum 5 years of experience preferred.

Responsibilities

• Lead the day-to-day operations of commercial finance.
• Provide financial insight to Commercial and Marketing team.
• Support in Monthly financial closing.
• Prepare insightful reports and financial analysis.
• Analyze sales/margins and recommend actions.

Skills

P&L management

Financial modeling

Advanced Excel skills

ERP system experience

Sales planning

Pricing strategy

Margin analysis

Tools

SAP

Oracle

Microsoft Dynamics

Power BI

Tableau

Job description

Job Description

• Lead the day-to-day operations of commercial finance to ensure that work processes are implemented as designed and comply with established policies, processes and procedures.
• Work closely with the commercial team and distributor team to analyze the monthly promotions, accrual review and provide insights at the month end to all commercial stakeholders.
• Provide financial insight to the Commercial and Marketing team.
• Business partnering with sales counterpart - with focus on CG/SIS/FS/Retail/Ecom channel.
• Evaluate Customer P&L & Promotions.
• Support in Monthly financial closing
• Prepare and analyze value chain for NPD/EPD or promotions.
• Preparing insightful reports and financial analysis to support the Commercial team in decision making, highlighting significant variances vs. Budget, Forecast and previous year.
• Analyze sales/ margins - volume, price, mix vs. Budget/Forecast/LY - identifying issues & recommending actions.
• Aid modelling and scenario testing for new products and business opportunities.
• Other Ad-hoc requirements to drive revenue maximization.
• Work Closely with Sales Team to support sales planning & analysis.
• Help establish/streamline policies and procedures throughout the department, support best practices in sales forecasting, reporting, and communications.
• Work with Trade Marketing team for the ROI analysis for every promotion - Preapproval and post analysis.
• Support the Commercial team in preparing the Budget/Rolling Forecast/LRP plans.
• Be a bridge between the Demand Planning team and Sales team in analyzing and improving the Sales forecast accuracy.
• Work with the marketing team in implementing the price increases, making sure all the prices are implemented in the system and conducting proactive analysis on the margin.
• Inform the sales team from time to time of the impact on margins due to WAC fluctuations

Requirements

• Strong knowledge of P&L management, financial modeling, and scenario analysis.
• Advanced Excel skills (Pivot Tables, Power Query, Macros/VBA preferred).
• Hands-on experience with ERP systems (e.g., SAP, Oracle, or Microsoft Dynamics).
• Familiarity with BI/reporting tools (e.g., Power BI, Tableau, or similar).
• Strong understanding of sales planning, pricing strategy, and margin analysis
• Minimum 5 years of exprience is preferred.