Commercial Analyst

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

Job Description

Boxer Superstores is looking for an analytical and detail-driven Commercial Analyst to join our Commercial team.

Job Description

Boxer Superstores is looking for an analytical and detail-driven Commercial Analyst to join our Commercial team. This role will support the Commercial Lead Analyst in producing business-critical reports, analysing commercial performance, and transforming complex data into meaningful insights that support strategic business decisions. The successful candidate will have strong analytical and commercial acumen, advanced Microsoft Excel skills, and the ability to work accurately with large volumes of data in a fast-paced environment.

Duties And Responsibilities

• Compile and maintain Profit & Loss (P&L) reports, ensuring the accuracy of data, formulas, lookups, and supporting information
• Compile inflation reporting and analyse like-for-like data to provide meaningful business insights
• Analyse basket data and summarise findings into clear, user-friendly reports and dashboards
• Compile swell and damage reports, transforming raw data into structured and meaningful information
• Monitor and report on growth hurdles, including supplier growth, GRVs, trade terms, and projected income
• Build and maintain Excel-based dashboards to support commercial reporting and decision-making
• Manage and maintain the GP Predictor, ensuring sales and gross profit information is updated accurately and timeously
• Cross-check formulas, calculations, lookups, and data outputs to ensure reporting accuracy
• Assist with aligning Excel-based reporting and the GP Predictor with relevant IT applications and system developments
• Track competitor promotional activity and maintain supporting promotional information
• Conduct post-promotional analysis using sales and promotional data
• Review stock-on-hand performance on promotional lines and compile relevant promotional and combo sales reporting
• Analyse commercial data and identify trends, risks, opportunities, and performance insights
• Present complex information in clear dashboards and reports for Commercial, Finance, and Executive stakeholders
• Respond to ad hoc analytical and reporting requirements as required

Minimum Requirements

• Tertiary qualification at NQF Level 7 or higher
• 3–5 years’ relevant experience in commercial analysis, financial analysis, business analysis, data analysis, reporting, or a similar analytical role
• Advanced Microsoft Excel skills
• Strong Microsoft PowerPoint skills
• Knowledge and working experience 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 effectively under pressure and meet deadlines
• Ability to handle confidential business information with discretion