Business Intelligence Manager

**Position Description**

**MAIN OUTPUTS AND RESPONSIBILITIES FOR THIS POSITION**

**ANALYSIS AND REPORTING**:Explore and organise data into meaningful business insights.
- BI Tool: Drive the implementation of the new tool ensuring reliability of data. Utilise data visualisation tools to drive key illustrations and enhance the current status quo.
- 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.
- Reporting: Lead the analytical processes by preparation of insightful and streamlined reports that are of consistent high quality, finalised timeously, relevant and meaningful. 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.

**FORECASTING**:Generate a planning process to ensure forecast accuracy to avoid stocks outs, manage risk
- Responsible for supporting the business strategy by leading initiatives covering sales forecasting up to new product plan launches and all systems development in such a way to improve the service to end-customer and add value towards the supply and demand chain
- By using sales data and information about economic and market trends, predict future market conditions and demand for products.
- Manage the forecasting process, lead the implementation and drive the improvement plans in terms of process, system and people skills:

- Develop and maintain accurate sales forecasting processes
- Develop, implement and maintain automated standardised recipe calculator that accommodates all brands requirements.
- Agree and manage forecasts with brand marketing heads for new menu and promotions
- Review and evaluate accuracy of weekly sales plans in partnership with the Planning/Marketing teams and develop robust accurate sales forecasting processes
- Measure forecasting accuracies and their consistency with previous plans;
- Constantly update and enhance models to ensure relevance to each brand
- Communicate ongoing forecast changes to stakeholders in the Marketing and Supply Chain
- Research historical data to map trends and determine how they will influence the business
- Examine own methodologies to find ways of improving predictive accuracy
- Manage the Turnover forecasting process at year end

***

**CRM**:Manage and analyse consumer data, exposure and response to marketing campaigns
- Work with IT to build the CRM Tool and ingest data from various sources
- Extract, prepare, validate and analyse customer data sets
- Critically evaluate information from multiple sources and clearly indicate quality of final analysis
- Tests, analyzes and problem solves data issues to ensure data integrity
- Determine, implement, and evaluate business metrics to measure campaign effectiveness
- Provide governance & structure for content performance measurement (POPIA)

***

**MAPPING TOOL**:Provide quantitative and qualitative insights using the Mapping Tool
- Utilise GIS Mapping solution to drive insights and analytics and support new business development
- Recognize appropriate data projection for data sets based on location and standards
- Use mapping tools and GIS experience to continually improve mapping accuracy
- Develop and maintain data quality, cartographic standards and best practices for GIS
- Demonstrate / Roll out the tools value-added services to Brands

***

**MASTER DATA MANAGEMENT**:Support operations by monitoring and analyzing master data, key data, and master relationship da