Data Analyst at Famous Brands

About the job

Key Tasks And Responsibilities

ANALYSIS AND REPORTING: Explore and organise data into meaningful business insights.

• Processing: Responsible for data extraction (compiling raw data), transformation (make it intelligible), and loading (load into warehouse) process. Extract data from various sources and convert it into meaningful information that will enhance business decisions.

• Data Capture: Capture data and continually review and refine the quality of reports to ensure they support and inform appropriate decisions by senior management. Manage data integrity with the objective of presenting accurate information Implement quality control of databases to ensure appropriate use of data

• External data sources: Ensure data quality, accuracy and cleansing of external data. Continuously identify and evaluate new data sources.

• Big Data Components: Responsible for the components of data: Volume (How much data is currently managed), Variety (What types of data are managed and can be accessed), Veracity (How reliable / useful is the data?), Velocity (How accessible / usable is the data within the information system) and Visualisation (What tools do we have at our disposal to represent the data?)

• Analysis: Analyse and interpret business information needs based on a strong understanding of business processes, drivers and priorities. Explore data in meaningful ways in order to organise, interpret, structure and present the data into meaningful information. Evaluate evolving analytics platforms

• Impact Analysis: Proactively provide Brands with analysis on economic and market trends, predict future market conditions and demand for products by using external data sources. Evaluate Brands performance linked to current market condition, and provide value added insights (over and above the weekly, monthly report)

• Reporting: Prepare analytical reports that specify the key performance indicators as well as diagnostic measures to analyse and recommend course of action for a brand to improve performance and maximize growth. Continually review and refine the quality of reports to ensure they support and inform appropriate decisions by senior management

• BI Tool: Build current reports onto the Pentaho Tool. Utilise the new tools to enhance data visualization

FORECASTING: Provide analytics to ensure forecast accuracy to avoid stocks outs and manage risk

• Provide data inputs to manage forecasts with the Brand teams for all new menu promotional items

• Research historical data to map trends and determine how they will influence the business

• Examine own methodologies to find ways of improving predictive accuracy

• Post Implementation Review analysis on Promo – GP’s, post promo impact on menu and customer behavior

• Continual analysis and enhancement of the Promo dashboards

• In-depth analysis, review and tracking of WPSA’s