Insights Specialist: Global Fmcg Pop Culture Brand

A leading, global FMCG pop culture brand’s Cape Town HQ has a fantastic in-office opportunity for an analytically minded Junior-Mid Insights Specialist.
In this exciting role as Insights Specialist, you will be responsible for supporting the business with the creation, running and maintenance of annual, quarterly, and monthly reports. You will also be tasked with any ad-hoc research projects & presentations to the business relating to Sell-in Volumes and Consumer Offtake Volumes. This includes distribution trends, distribution opportunities and price and promotion analyses.

We’re looking for a talented data lover to provide the expertise to analyse, track and evaluate ongoing sales within the market. Additionally, through gap analysis you will be required to provide feedback and input to steer the proactive tactical steps to be taken by Sales teams.

**Responsibilities**:
Consumer Offtake Reporting & Data Management
- Support the Insights Manager in timely updating and delivery of Consumer Offtake Reports to be used by the broader business
- Generate account/regional/store level reports and ad hoc insights pieces to drive actions that will increase our awareness and footprint, close distribution gaps and drive market share gains
- Execute post campaign and NPD insights which assess both the feasibility and performance thereof.

Management Of Off & On-Premise Depletions Data
- Work closely with our team to control & monitor quality of data from our distribution partners, by working together with them and our Data Processing Managers to ensure accurate and timely availability of the data for further analysis
- Communicate with distribution partners to ensure consistently accurate data delivery for Excel uploads
- Collection, analysis, evaluation, and presentation of trade sales, financial and distribution data
- Own and manage master data and work with the global CRM/depletions team to ensure business warehouse and depletions reports are accurate.

Management of Reporting Deliverables
- Perform in depth investigations and analyses relating to Internal Sales by Channel, SKU, and Outlet Type
- Provide summarised data pieces and structured analyses proactively or as requested
- Work with Spatial XL to identify opportunities at a micro region level for both off and on-premise
- Off-Premise: Track internal sales data both daily and monthly and provide consistent, accurate and timely reporting of opportunities for growing efficiency, increasing footprint, gaining market share, and driving Brand growth across our different SKUs
- On-Premise: Support the Sales Intern with the delivery of weekly and monthly reporting deliverables to head offices regarding Internal Sales and external Market Tracking data with regards to Sales, Hi5, Distribution and Store Coverage
- Track and report on the progress against incentive targets set with individual DP partners (outlet development & volume per outlet development, Perfect Store Audit execution targets, progress of new store openings).

**Requirements**:

- Higher Commercial/ University Degree (Business, Marketing or similar) - preferable
- 4+ Years experience in research and/or FMCG industry
- Proficient on Nielsen/IRI software
- Experience with Power BI software, Power Pivot and Power Query
- Experience working with offtake data
- Experience with QlikView, Tableau, or SAP systems
- Experience with Shopper Research
- Exposure to Spar Insights, dunnhumby or CPM data
- Exposure to Spatial Excel
- Experience working with sell in / depletions data
- Outstanding knowledge of Microsoft Excel and PowerPoint
- Attention to detail, logical thinker. A strive towards perfectionism
- Excellent analytical, research and problem-solving skills
- High numerical ability; discerns trends, patterns, and anomalies in data with probable cause and effect. Storytelling abilities with data
- Strong presentation and communication skills to deliver value back to the business
- Ability to retrieve, understand and interpret data from numerous sources
- Understanding of distribution partners’ work processes, reporting systems and business context
- English -written and spoken
- Able to travel when needed.

City: Cape Town

Country: South Africa

Level of Expertise: Junior-Mid

Remuneration: Negotiable

Reference Number: #Viv3008

**Viv Gordon**:
MD & Consultant