Data-Driven Commercial Analyst, Excel & Dashboards

Boxer Superstores; Durban; On-site; ZAR 420,000 - 640,000; Full time

Job summary

Boxer Superstores in Durban is seeking an analytical and detail-driven Commercial Analyst to join our Commercial team. You will support the Commercial Lead Analyst in producing business-critical reports, analysing performance, and transforming complex data into meaningful insights for strategic decisions.

This role requires advanced Excel skills, strong analytical ability, and the capacity to work with large data sets in a fast-paced retail environment.

Qualifications

• 3–5 years of relevant experience in commercial/financial analysis
• Advanced Microsoft Excel skills
• Strong Microsoft PowerPoint skills
• Knowledge of BoMM and Cube
• Knowledge of data analytics and reporting tools
• Strong analytical and problem-solving ability
• Sound commercial and financial acumen
• Excellent attention to detail and accuracy
• Strong verbal and written communication skills
• Ability to work under pressure and meet deadlines

Responsibilities

• Compile and maintain Profit & Loss (P&L) reports with accurate data and formulas
• Compile inflation reporting and analyze like-for-like data for insights
• Analyse basket data and create clear reports and dashboards
• Prepare swell and damage reports from raw data
• Monitor growth hurdles, supplier terms, and projected income
• Build Excel dashboards to support reporting and decision making
• Maintain the GP Predictor with up-to-date sales and gross profit figures
• Cross-check data outputs for accuracy
• Align Excel reporting with IT applications and systems
• Track competitor promotions and analyze impact
• Conduct post-promotional analysis using sales data
• Review stock-on-hand performance on promo lines and reporting
• Identify trends, risks and opportunities in commercial data
• Present complex information to Commercial, Finance and Executive stakeholders
• Respond to ad hoc analytical requests

Skills

Advanced Excel

PowerPoint

Analytical thinking

Attention to detail

Communication

Education

Tertiary qualification at NQF Level 7 or higher

Tools

BoMM

Cube

Job description

Boxer Superstores in Durban is seeking an analytical and detail-driven Commercial Analyst to join our Commercial team. You will support the Commercial Lead Analyst in producing business-critical reports, analysing performance, and transforming complex data into meaningful insights for strategic decisions.

This role requires advanced Excel skills, strong analytical ability, and the capacity to work with large data sets in a fast-paced retail environment.