CATEGORY ANALYST

SUMMARY:
A stationery and promotional gift company based in the West Rand of Johannesburg is currently seeking a Category Analyst the purpose of this role is to provide the Category Manager with support through analysis of data, implementation and execution monthly. Through data analysis, find actionable insights that can be used to inform business decisions by identifying opportunities and potential risks.

POSITION INFO:
MAIN RESPONSIBILITIES / TASKS:
Assist the Category Manager with the analysis and compilation of monthly reports and
additional requests driven by Marketing and Sales to achieve the defined objectives by
category.
Work closely with the Category Manager to develop the recommended category strategies
and related activities to increase penetration and market share.
Market data analysis and understanding.
Compile and Present Post Campaign Analysis Reports (PCA)in conjunction with
Category Manager input.
Collate and Present Competitor Analysis data for Competitor Reviews as and when
required, working with the Junior Brand Managers
Ownership of monthly Circana reports (e.g. SKU Ranking, NPD, Customised KAM
Reports, Broadsheet Report), which entails updating and providing actionable
insights
Ownership of E-Commerce report entailing refreshing and collating data received
from various sources, working with the E-Commerce and Digital Manager
Sharing of Economic Report from Trade Intelligence and updating shared folder
with refreshed Trade Intelligence Reports monthly
Update Power BI Category Helpers
Build and refresh new reports i.e. Store Alignment Reports using Power Query
Complete Product Listing Documents for KAM team on request
Support Marketing and Sales with data requests.
Internal data analysis and understanding
Pull and Utilize Cognos data to identify trends on SKU’s and customers that will
enrich the data analysis.
Cognos Report Requests from Marketing
Administration:
JDE System to create Purchase Orders
Ensure that cost centre numbers are correctly allocated to the relevant CE (Cost
Estimate)
Manage monthly invoices received from suppliers to generate GRN (receipt) to send
to the Finance Department to ensure timeous payment to the suppliers
Key performance Indicators:
Meeting of deadlines for key duties (monthly reports, competitor analysis)
Continuous communication with relevant stakeholders in Marketing and Sales.
Accurate and on time delivery of all data-related requests.
QUALIFICATIONS:
1 YEARS Category Management Experience in FMCG will be advantageous.
3-year Marketing degree with statistics as a major.
Exceptional MS Excel, MS PowerPoint
Must have Valid Driver’s License
Must have own car
Knowledge, Skills, Competencies:
Degree in business or Marketing with Statistics as a major
Able to communicate clearly and effectively in English, orally and in writing.
A passion for data and data analysis.
 Attention to detail
High Numeracy skills – detail analysis
Curiosity to find new and improved ways to report data and insights
Professional Skills:
Time Management
Meeting critical deadlines
Planning
Flexibility
Detail oriented with strong analytical skills
Action Orientation
Drive for Results
Team work
Collaboration across departments
Exceptional Excel
Exceptional PowerPoint
Power BI
Power Query (Power Pivot)
DAX calculations
D-IBM COGNOS
Personal Skills:
Stress Management
Resilience
Objectivity
Self-Starter
Initiative
Presentation Skills