Mix & Assortment Data Analyst
DEWALT
Medellin, Medellin
hace 2 días

Job Description

  • Teleworking from any city in Colombia
  • As a Revenue Growth Management (RGM) Mix & Assortment Analyst, you’ll be part of the RGM Mix & Assortment pillar, driving margin improvements within our largest regional division at SBD.

    The RGM Mix & Assortment pillar’s mission is to :

  • Rebalance and tailor assortment to better meet customer needs by customer segment and significantly reduce the walk rate, in close collaboration with Sales & Channel teams
  • Deliver new insights into how shoppers perceive and shop the category, revealing category growth opportunities, in partnership with the Brand Strategy teams
  • Analyze the most productive and profitable segments, brands, and products and their impact on revenues
  • Improve category performance, adding variety and reducing duplication and out-of-stocks on power SKUs
  • Reduce complexity of the portfolio with data-driven recommendations to decrease costs but maintain share
  • Specific Responsibilities :

  • Work with the RGM Leads and cross-functional teams to establish analytics findings which is aligned across customer segments and leads to business insights for the RGM & commercial teams
  • Own and execute critical RGM Mix & Assortment analytics : Support the tactical execution of Mix & Assortment strategy;
  • This includes cross-functional participation between Finance, Channel, and Product TeamsTracking & measuring the execution of Assortment initiativesIdentify Assortment opportunities by conducting deep Customer / Store / SKU level analysisAggregate detailed analysis to identify overarching themesModeling what-if scenarios for Assortment optimization by Keep / Delete / Replace analysisCreate actionable reports to improve margin by leveraging data from Data Lake and other databases (QlikView, Snowflake, Amazon Hive, PowerBI)

  • Locate and define new process improvement opportunities
  • Other duties as assigned.
  • Knowledge / Education / Experience :

  • Minimum of 3 years of analysis, merchandising and / or assortment experience, preferable experience with consumer products company
  • Bachelor’s Degree in business or a related field
  • Demonstrated ability to manage a variety of data sources and leverage BI dashboards (PowerBI, QlikView, etc) to analyze data and glean meaningful business insights
  • Proficient in Power BI and all Microsoft Office Software, especially MS Excel
  • Systems knowledge or ability to learn quickly : Alteryx, SAP, Business Warehouse, SQL, QlikView, Snowflake, Amazon Hive, Amazon Workspace, and Salesforce.com
  • Moderate ETL and Analytics tool proficiency (Tableau, Power, BI, Einstein etc.) strongly preferred
  • Proficient in all Microsoft Office Software, especially MS Excel and PowerPoint
  • Demonstrated detail-oriented, self-reliant, problem-solving skills and time management skills
  • Professional verbal and written communication skills in English with comfort in presenting
  • Experience overcoming obstacles with the ability to identify new opportunities within an organization, take risks, and learn from failure
  • Reportar esta oferta
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación