Job Description

Coca Cola Beverages South Africa has an exciting opportunity in the Sales & Marketing Department. We are looking for seasoned individual with necessary skills & experience for a Data Analyst role.Key Purpose StatementProvide insights, deep analytics and modelling to support Customer teams and sales regions to identify growth opportunities and levers for CCBSA.
Key Duties & ResponsibilitiesKey Outputs and Accountabilities

• Perform basket level analyses for specific key accounts to provide consumer level insights as input into promotional activity and channel strategy development.
• Develop and maintain the CCBSA reporting and visualisation platform to ensure accurate sales, volume, revenue and margin communication to relevant key stakeholders.
• Convert multiple data sources into user friendly, insightful reports and dashboards by utilising Microsoft Power BI capabilities, as per business requirements.
• Coordinate research as per business requirements to extract shopper, customer, and channel insights to support critical business decision making.
• Compile insights for monthly or quarterly customer category reviews for key customers, to support decision making and identify opportunities within Key Accounts.
• Collaborate with key internal stakeholders (e.g. Revenue Growth team and Channel Development teams) to develop volume and/or Net Sales Income (NSI) projections as input into the Annual Business Plans (ABPs).
• Translate analytical and/or research findings into meaningful insights, and provide recommendations to mitigate risk and highlight opportunities to the business.
• Interrogate market data to drive reliable market insights and trends.
• Extract, and report on, competitor and CCBSA activity in the market in relation to brand, pack, channel and customer to support CCBSA promotional campaigns.
• Use forecasting and statistical modelling techniques, data mining, advanced analytics and quantitative tools to support business and strategic objectives.
• Develop processes to evaluate and standardise multiple data sources (e.g. Nielsen, RED execution, internal sales data, etc.) to enable big data analytics and insights within the relevant reporting and visualisation platform (e.g. Microsoft Power BI).
• Monitor and evaluate sales and market information to drive data integrity.
• Coach and/or train relevant stakeholders on the effective use on visualisation and reporting tools (e.g. Microsoft Power BI).
• Support relevant projects by executing market analytics, as required, to drive top-line revenue growth for CCBSA.

Skills, Experience & EducationQualifications and Experience

• A relevant qualification, such as a BComm qualification, Business Science or BSC.
• At least 3-5 years research and/or analytical experience within a FMCG environment.
• Experience using core research and analytical techniques and tools (e.g. Microsoft Power BI, Qlick View, etc.).
• Commercially astute with proven ability to convert the outcomes of analytic processes or models into tangible business value.
• Experience with database management and optimisation through automation.

Competencies

• Action Oriented
• Business Acumen
• Composure is Cool Under Pressure
• Customer Focus
• Decision Quality
• Self-Development
• Written Communication
• Verbal Communication
• Analytical Ability
• Knowledge

• Sound knowledge of business sales systems, including Power BI.
• Experience working with Qlikview.

GeneralThe advert has minimum requirements listed. Management reserves the right to use additional or relevant information as criteria for short-listing. Interested applicants, who meet the above employee specifications, should please apply. Suitable equity candidates will be given preference in line with our Equity Plan.PolicyAt Coca-Cola Beverages Africa we are proud to celebrate diversity and we strive to achieve an equal opportunity workplace by being cognisant of affirmative action requirements. It is our policy to be mindful and compliant with all our regional requirements and national laws for those regions. Employment at Coca-Cola Beverages Africa is based solely on an individuals merit and qualifications directly related to their field of competence. We do not discriminate against an employee or potential employees because race, colour, religion, sex, national origin, sexual orientation, age, marital status, disability and gender identity.At the heart of our recruitment processes is the need to create a value driven experience for all applicants. To all recruitment agencies: Coca-Cola Beverages Africa does not accept agency resumes for roles that we post and make available. Please do not forward any resumes to any Coca-Cola Beverages Africa employees and Talent Teams as we are not responsible for any fees related to unsolicited resumes.

Coca-Cola