Channel Clustering Analyst

3 weeks ago


Cape Town, South Africa Clicks Group Limited Full time

**Listing reference**: 017707**Listing status**: Online-
**Position summary**

**Industry**:Wholesale & Retail Trade
- **Job category**:Other: FMCG, Retail, Wholesale and Supply Chain**Location**:Cape Town
- **Contract**:Permanent**Remuneration**:Market related
- **EE position**:Yes**Introduction**
- We are looking to appoint a Channel Clustering Analyst to work within the Space Planning team. This role will be based at Clicks Head Office in Cape Town and report to the Space Planning Manager.**Job description**

**Job purpose**:

- To be the custodian of the clustering engine and processes by researching and selecting the appropriate clustering techniques and fine tuning clustering parameters to enable the most effective store clusters to increase the effectiveness of the downstream processes (i.e. Assortment Optimisation, Space Planning, Floor Planning).**Job objectives**:

- Enable customer centric strategy and sales execution through data analytics and customer insight
- Use internal and external data to highlight market and business trends to increase profits and efficiency
- Responsible for collecting insight through different means, from mining the company data sources and industry trends to help develop insight on company position and suggest improvements and changes to drive business and profitability
- Implement standard and approved customer segmentation to drive prioritization and business growth
- Responsible for improving customer experience through developing customer journey maps and segmentation, monitor CRM sales data quality and implement relevant actions
- Provide category strategy support through data analytics, dashboards, reports etc.
- Influences strategic thinking, drives internal process improvements and customer centricity within the buying division and should be seen by merchants as a thought leader on category and assortment strategy.
- Consult with merchandise leadership on the right product mix and assortment related to what their customer cares about most ensuring this is supported by internal data mining to analyze purchasing patterns.
- Conduct clustering runs by category after engaging with the category to understand category behaviour and nuances so that data and parameters are as accurate as possible
- Ensure that all relevant and useful data sources (i.e. CDTs, Product and Store attributes, demographic data) are understood and used to inform the clustering outputs
- Deliver clusters by category (based on business requirements) using JDA CC which groups stores based on customer purchasing behaviour
- Deliver insightful and actionable outputs for each clustering exercise by using relevant attributes to distinguish each cluster's performance differences (i.e. Product, Store, Customer attributes)
- Provide the so-what to guide the category teams in understanding the benefits of the different clusters and how this will help for downstream processes such as Assortment, Space and Floor Planning
- Maintain store repository with cluster information by category by store
- Develop further clustering best practice through benchmarking and feedback from internal Assortment & Space Analysts and through the category teams
- Build overall store picture with the different category clusters to understand if there is any further correlation between stores
- Build rich repository of store attributes to better understand store behaviour and collaborate with other areas (i.e., Store Development & Design, Store Optimisation) to develop and enhance this understanding.

**Minimum requirements**

**Job related knowledge**:

- Essential- Strong understanding of data tables and report construction, especially customer data and preference clustering techniques
- Ability to combine and analyse data from various sources and produce visual and/or exception based output that portrays answers to business questions
- Ability to draw insights from data analytics, summarize findings and make recommendations for improvement
- Ability to understand and solve complex business issues covering systems, processes and structures within and across BU's
- The ability to turn data and /or insights into clearly articulated views for socialisation
- Ability to work with large volumes of complex data"
- Advanced data visualization tools experience required (i.e. Qlikview / Tableau)
- Advanced Excel (with experience using graphs, pivots etc.)
- 4-5 years' experience within an analytical role, preferably in a retail environment
- Previous experience in category clustering would be advantageous

Desirable- Knowledge of Category merchandising principles and processes.
- Knowledgeable in in-store layouts, merchandising processes and tools required.
- Technical Skills: HTML5, SQL, SSIS, SSAS, SSRS, R, Power BI, Tableau, BY Channel Clustering

**Job related skills**:

- Essential- Strong verbal and written communication skills
- Strong focus on quality
- Sound business acumen
- Strategic thinking ability, with an analytical ap



  • Cape Town, South Africa Adidas Full time

    **Purpose & Overall Relevant for the Organisation**: - Directly contribute to the growth, elevation and activation of all retail channels (Own Retail, Franchise and Wholesale), by planning, developing and enabling exceptional consumer experiences, campaign activations and in-store / mall activations across Emerging Markets.**Key Responsibilities**: - Lead...


  • Cape Town, South Africa PULLMAN Full time

    **Company Description** We are far more than a worldwide leader. We welcome you as you are and you can find a job and brand that matches your personality. We support you to grow and learn every day, making sure that work brings purpose to your life, so that during your journey with us, you can continue to explore Accor’s limitless possibilities. **Job...


  • Cape Town, South Africa HotelJobs.co.za Full time

    Assist in the management and optimization of the groups presence across many electronic distribution channels, such as online travel agencies (OTAs), global distribution systems (GDS), metasearch engines, direct booking channels, tour operators and travel agents. - Ensure the group's visibility and competitiveness on global platforms and make strategic...

  • Revenue Analyst

    3 months ago


    Cape Town, South Africa Bradford Jacobs Full time

    Description **Job Title**: Revenue Analyst **Job Overview**: As a Revenue Analyst, you will be responsible for analyzing market trends, competitor performance, and internal data to develop pricing and revenue strategies for a hotel or vacation rental property. Your primary goal is to maximize revenue and occupancy while ensuring the property remains...


  • Cape Town, South Africa AccorHotel Full time

    **Company Description** "Why work for Accor? We are far more than a worldwide leader. We welcome you as you are and you can find a job and brand that matches your personality. We support you to grow and learn every day, making sure that work brings purpose to your life, so that during your journey with us, you can continue to explore Accor’s limitless...

  • Junior Data Analyst

    3 months ago


    Cape Town, South Africa Cullinan Holdings Full time

    Cullinan Holdings is seeking a talented and motivated Junior Data Analyst to join our team. This is a great opportunity for someone who is just starting out with their data analyst career. **Key Responsibilities**: - Collect, analyse, and interpret data to identify trends and patterns to understand where we should optimise our marketing campaigns for...

  • Floor Space Analyst

    3 months ago


    Cape Town, South Africa Clicks Group Limited Full time

    Advert reference: click_013603 Advert status: Online - **Position Summary**: **Industry**:Wholesale & Retail Trade **Job category**:Other: FMCG, Retail, Wholesale and Supply Chain **Location**:Cape Town **Contract**:Permanent **Remuneration**:Market Related **EE position**:Yes **Brand**:Clicks Group **Introduction**: To provide analysis and reviews...


  • Cape Town, Western Cape, South Africa Sanlam Full time

    About the RoleSanlam Private Wealth is seeking a skilled Business Analyst to join our team. As a Business Analyst, you will play a critical role in ensuring that our business requirements are met through effective solutions.Key ResponsibilitiesCompile and deliver quality business requirement specification documents/user stories, including process mapping and...

  • Marketing Analyst

    1 month ago


    Cape Town, South Africa Betway Group Full time

    On average it takes 5 minutes to apply for this role.Kick-start your career in the online gaming world and experience the very latest in technology and innovation. Do you see yourself as one of those “out-of-the-box thinkers”, “Technical masterminds”, “Outstanding creatives”, or “Mind-boggling number crunchers”? If so, we want to welcome you...

  • Mi/data Analyst

    3 months ago


    Cape Town, South Africa TTEC Full time

    MI/Data Analyst Reporting Analyst **Responsibilities**: The Reporting Analyst is fully dedicated to and receives work from the Retail Contact Center Business Intelligence (RCC BI) team. The role solves complex business problems and issues using data from internal and external sources to provide insight to decision-makers. The Reporting Analyst work...

  • Commercial Analyst

    3 months ago


    Cape Town, South Africa Mukuru Full time

    Mukuru is on the lookout for a Commercial Analyst to bolster the Analytics capability within the Commercial team. The role is open to applicants from Cape Town, with remote work possible. Mukuru is a Fintech business offering the emerging consumer access to affordable and reliable financial services. Our foundation is built on international money transfers...

  • CRM Analyst

    3 months ago


    Cape Town, South Africa takealot.com Full time

    takealot.com, a leading South African online retailer, is looking for a highly talented CRM Analyst to join our team in Cape Town.  We are a young, dynamic, hyper-growth company looking for smart, creative, hard-working people with integrity to join us. We offer a market-related, Total Remuneration Package which allows full flexibility according to your...

  • Manager Key Accounts

    2 weeks ago


    Cape Town, South Africa adidas Full time

    **Purpose & Overall Relevance for the Organization**: - To ensure profitable market share and net sales growth within select key accounts across South Africa. - To passionately lead the key account sports function in identifying, developing and implementing strategies through a brand first approach whilst driving profitable growth. **Key...

  • Provincial Executive

    3 months ago


    Cape Town, South Africa Sanlam Full time

    **Who are we?** Sanlam Developing Markets [SDM] (a wholly-owned subsidiary of Sanlam Life Limited) is one of the top financial services providers in the South African entry-level and emerging middle market. It aims to understand the unique requirements of clients and offers a wide range of simple and affordable financial solutions that cover needs such as...


  • Cape Town, South Africa Fiskal Finance Full time

    As a Financial Planning and Analysis Analyst, you will be working closely with clients and Financial Managers to design, implement and consistently improve financial models, budgeting processes, and Management Account and Key performance Indicator Reporting. Challenging yourself through interpreting financial and non-financial data and making recommendations...

  • Junior Data Analyst

    2 months ago


    Cape Town, South Africa VHRS Full time

    Company: Tagmarshal Position: Junior Data Analyst Commencement: Immediately Contract: Permanent position Work hours: 8:30 – 5pm Location: Hybrid - Cape Town CBD in-office: 3 days per week / 2 days WFH Remuneration: Commensurate with qualifications and experience Role summary: We’re looking for a strategic graduate Data Analyst to join the System and...


  • Cape Town, South Africa Unifi Recruitment Full time

    **Job Advert Summary**: **Unifi** is a fast-growing finance and technology company operating in Zambia, South Africa, Uganda and Kenya. Unifi delivers personal lending products through online, mobile phone and branch channels. The company is well supported by strong shareholders and a board of directors with vast experience in entrepreneurship and...

  • Financial Data Analyst

    5 months ago


    Cape Town, South Africa TalentintheCloud PTY Limited (trading as titc.io) Full time

    A dynamic, fast-moving, and rapidly growing fintech lending company is seeking a Financial Data Analyst, which is committed to delivering innovative financial solutions to its clients is currently looking for a Data Analyst, this role is to assist in building and delivering a range of data-driven models across the entire credit life cycle.**Position...


  • Cape Town, South Africa Adidas Full time

    Purpose: Have a sound understanding of integrated paid media principles to guide and support markets to effectively execute global media strategies and frameworks. Drive collaboration across markets to leverage learnings for execution at a cluster level.- Primary: Provide support and guidance across EM clusters to ensure global media frameworks and...


  • Cape Town, Western Cape, South Africa VHRS Full time

    About VHRSVHRS is a dynamic and innovative company that is changing the world of Golf Operations through data. We have developed leading traction in the USA, Europe, Canada, the UK, and South Africa.Job SummaryWe are seeking a strategic graduate Data Analyst to join our System and Analytics team. In this role, you will create and maintain robust...