BCom Graduate

Time Personnel; Cape Town; On-site; ZAR 350,000 - 480,000; Full time

Job summary

Time Personnel is seeking a capable analyst to support monthly reporting, forecasting and variance analysis for South Africa’s market. You will develop and maintain performance dashboards, consolidate forecasts, and drill into Actual vs Forecast variances to provide actionable insights.

The role requires strong Excel skills (including macros), PowerPoint and multi-dimensional tool experience, with rigorous attention to detail and the ability to work under pressure.

Qualifications

• Matric or equivalent
• Strong knowledge of Excel (macro, programming)
• PowerPoint proficiency
• Experience with multi-dimensional tools (Essbase, EOS, MS database) is an asset
• Analytical, mathematical, creative problem-solving skills
• Integrity, rigor, proactivity and team spirit
• Strong listening, interpersonal, written, and oral communication
• Attention to detail and ability to prioritize under pressure
• Self-motivated and able to exercise independent judgment

Responsibilities

• Prepare ACTUAL monthly reports (Volume & Revenue at D+2, Variance Analysis, PnL, Mid-month forecast and Month End Forecast)
• Develop and maintain performance tracking tools (Power BI and others)
• Aggregate reporting & insights from clusters to identify risks & opportunities vs forecast
• Consolidate LE/Budget/R&O forecasts received from markets
• Lead forecast processes for regional office in coordination with HR, Marketing, GM
• Build and consolidate monthly reporting files to analyze Actual vs Forecast
• Understand variances in labour cost, travel expense and overheads
• Create visualizations for large data sets to aid management decisions
• Improve efficiency of existing internal reports
• Support senior exec meetings with presentation material
• Ad-hoc analysis for stakeholders

Skills

Analytical

Problem solving

Attention to detail

Communication

Team player

Education

Matric / Grade 12

Tools

Excel

PowerPoint

Essbase

EOS

MS Database

Job description

REQUIREMENTS

Matric, or equivalent qualification Strong knowledge of Excel (macro, programming), PowerPoint, multi-dimensional tools (ESSBASE, EOS, Microsoft database type) are an asset. Excellent analytical, mathematical, and creative problem-solving skills Integrity and rigor are a must, as well as pro activity and team spirit. Excellent listening, interpersonal, written, and oral communication skills Logical and efficient, with keen attention to detail Highly self-motivated and directed Ability to effectively prioritize and execute tasks while under pressure Strong customer service orientation Able to exercise independent judgment and take action on it.

DUTIES

Prepare ACTUAL monthly reports (Volume & Revenue at D+2, Variance Analysis, PnL, Mid-month forecast and Month End Forecast) Develop and maintain accurate & user-friendly performance tracking tools (Power BI and others) Aggregate reporting & insights from Clusters to identify risks & opportunities vs forecast. Help consolidate and analyse the LE/Budget/R&O forecasts received from markets. Contribute to LE/Budget/R&O forecasting for Regional Office Support Regional Controller in leading forecast processes for regional office and South Africa market (initial budget, revisions & landings) in coordination with HR, Marketing Managers and GM Build and consolidate monthly reporting files to analyse Actual vs Forecast Ensure full understanding of variances in labour cost, travel expense and other overheads Develop dynamic ways to visualize large data sets to empower Management for effective decision taking (with various tools such as Power BI etc.). Improve ways of working on existing internal reports to gain efficiency. Support the team to create pertinent presentation for Senior Executive meetings Ad-hoc analysis of business results for different stakeholders

Salary: R negotiable dependent on experience

Join us on SOCIAL MEDIA or visit our WEBSITE for more information. See links below.