{bc}
linkedin

Commercal Analyst - Fix term contract

Shiseido
Dubai, UAE
Freelance
Entry
Onsite
1 weeks ago
Advanced ExcelQlikPowerPointSAPFinancial AnalysisSell out Reporting
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

Advanced ExcelQlikPowerPoint
Smart Apply

Full Job Posting

Role Purpose

  • The Business Analyst is the analytical backbone of the Commercial team for the GCC region, owning end to end sell out reporting, commercial finance operations, and analysis behind retailer, brand, and budget decisions.

Key Responsibilities

  • Own the monthly sell out cycle: collect reports from all retail partners, validate data quality, and keep Qlik updated.
  • Produce Sephora weekly and monthly sell out reports for internal and external stakeholders.
  • Run the NARS reporting pipeline: consolidate sell out from all markets, prepare EMEA monthly report and performance review deck.
  • Deliver BOTAN EMEA monthly reporting and quarterly Chalhoub GCC sell out submission.
  • Issue and control POs and CNs for the region across all customers.
  • Deliver monthly finance requests: Gross Sales RF, Sell Out RF, BC productivity.
  • Own price increase and ICF file completion for customers.
  • Resolve invoicing and price issues raised by Customer Service.
  • Prepare stock coverage and SOH/suggested order analysis at partner level.
  • Support annual budget process: complementary files, MOC analysis, alignment decks.
  • Prepare retailer strategy decks and NARS monthly performance review.
  • Maintain order forms and consolidated distribution list.

Candidate Profile

  • Bachelor's degree in Business, Finance, Economics, or related quantitative field.
  • 1 2 years of experience as a business/commercial/sales analyst, ideally in beauty, FMCG, or retail distribution.
  • Advanced Excel (Power Query, pivot models, complex consolidations) essential.
  • BI tools: Qlik (or Power BI/Tableau with willingness to master Qlik).
  • Strong PowerPoint storytelling skills.
  • ERP exposure (e.g., SAP) for PO/CN flows is an advantage.
  • Full professional proficiency in English; Arabic or French is a plus.

Key Working Relationships

  • Commercial Director and Commercial team (primary)
  • Finance and Accounting
  • Brand and Marketing teams
  • Customer Service
  • External: Sephora, Al Tayer, Faces, MAF, Chalhoub and other retail partners

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Shiseido