Data Analyst-Africa at The Coca-Cola Company

Function Related Activities/Key Responsibilities:

• Investigate and perform business and system analysis, determine business system requirements and identify alternatives.
• Identify suitable data sources for the specified business need utilizing internal data repositories and external sources (bottler data, macro-economic data, consumer data, shopper data etc.)
• Understand, analyze and interpret source data required for the technical solution that will enable the business need.
• Translate business requirements to a level of detail appropriate for implementation using user-stories with acceptable criteria, process diagrams, data models, business rules and mock-ups.
• Translate business requirements into detailed technical requirements in the form of a Source to Target map and Functional Requirements Specification that will effectively assist technical developers to develop data and analytics solutions.
• Assist in the design and development of data and analytics visualization solutions (dashboards, OLAP cubes, reports, data dumps) utilizing PowerBI and SSAS.
• Assist in the design and sign-off of quality assurance test cases for the Technical development of data and analytics solutions ( User-acceptance testing, integration testing, regression testing)
• Assist in the documentation of data management solutions (data models, meta-data, master data and data quality solutions).

Education Requirements:

• Degree or related qualification in an analytic field of study (e.g. Bsc Computer science, Bcom Informatics, Bsc (Engineering) or similar).
• Technical certification (e.g. Microsoft stack (SSIS, SSRS, SSAS, SQL), CDMP) will be advantageous but is not a requirement.

Related Work Experience:

• 3+ years of experience in either MIS, BI or Data and Analytics related fields as a Business or Data analyst.

Nice to have:

• Coca-Cola system knowledge and understanding of the dynamics of the soft drink industry.
• General FMCG experience. 
• Prior experience working in multiple markets