Data Analyst - AME at Famous Brands

Main Outputs and Responsibilities for This Position

Business Analysis & Reporting: 

• Gather, clean, and study data sets to help AME to improve business intelligence capabilities.
• Generate and deliver quality reports to the various AME markets and perform quality assurance checks on all reports generated. 
• Design and build data pipelines to integrate data from various sources.
• Design, develop and maintaining business intelligence solutions.
• Partner with IT in driving automation of reports through Business Intelligence (Power BI).Identify and recommend best-practice reports based on data mining, analysis, and visualization.
• Collaborate with Leading Brands Commercial and POS team to unify, manage and govern data that improves business decision making. 
• Evaluate internal systems for efficiency, problems, and inaccuracies, developing and maintaining protocols for handling, processing, and cleaning data. 
• Utilize computer programs, analytical tools, and machine learning to pull out actionable insights from big data. 
• Incorporate external research into reporting to support AME market reports. 

Mapping Analysis

• Support Operations Team in unpacking and translating the Retail Galaxy studies to identify AAA sites for the AME business. 
• Utilise GIS solution to drive analytics
• Support AME marketing on adhoc business analysis
• Compile and deliver insights on Projects
• Discover patterns and trends through spatial mapping of data
• Design digital maps with geographic data and other data source
• Track industry and competitor trends and share knowledge with stakeholders
• Analyse competitors' moves using analytical frameworks and models
• Define Brand requirements by working collaboratively with new business teams

Master data: 

• Maintain database systems, ensuring data integrity and reliability
• Supports existing database applications
• Manage FB data for the AME Marketing team   
   

Requirements
Education and Experience

• Matric essential
• A relevant B. Com/B.Sc. (Finance; Statistics or Analytics) degree
   

Experience

• Analytical mindset with experience in translating data into relevant insights
• Minimum 2 years of relevant experience
• Clear understanding of statistical tools and BI tools (POWER BI, SPSS, SQL, BIG QUERY, etc…) 
• Proficient in Microsoft Excel & PowerPoint