Commercial Analyst

The Estée Lauder Companies Inc.; Madrid; Presencial; COP 116.658.000 - 174.989.000; Jornada completa

Descripción de la vacante

A leading cosmetics firm seeks a Commercial Support Analyst in Colombia to analyze sales performance and provide strategic insights. The ideal candidate will have a Bachelor's degree and 2 years of consulting experience, with strong skills in Excel and Power BI. Fluent English is mandatory. This role is crucial for driving sales and supporting brand expansion initiatives.

Formación

• Bachelor’s degree is required.
• Fluent English is essential.
• 2 years’ experience in consulting is highly valuable.

Responsabilidades

• Analyze sales performance and profitability across markets.
• Develop and maintain dashboards and reports for business decisions.
• Collaborate with cross-functional teams to ensure data quality.

Conocimientos

Analytical skills

Problem-solving skills

Collaboration

Organizational skills

Willingness to learn

Educación

Bachelor’s degree

MBA is valuable

Herramientas

Excel

PowerPoint

Power BI

Descripción del empleo

Overview

Position Summary: Support the Commercial Team across all channels (Perfumeries, ECI, Retail, Pharma, and Commercial Director) through data analysis, reporting, and delivering strategic insights to drive sales, profitability, and brand expansion initiatives.

Responsibilities

• Analyse sales performance, forecasts, and profitability across Retail, ECI, Perfumeries, Pharma, and Tourist markets, identifying trends, and areas for improvement.
• Monitor door productivity in Retail and ECI on a regular basis proposing improvement measures.
• Track price evolution of top SKUS and ELCO MS in wholesale and provide insights for decision-making.
• Develop and maintain dashboards, reports, and presentations to support business decisions, track KPIs, and assess brand/channel performance.
• Assess the impact of specific promotions, pricing, and marketing initiatives on sales and P&L, providing actionable recommendations.
• Support brand distribution expansion projects, including store openings, customer analysis, and market benchmarking.
• Conduct ad hoc studies to evaluate competitor performance, market share, and channel opportunities.
• Improve operational efficiency through stock review, channel productivity evaluation, and process optimization.
• Collaborate with cross-functional teams to ensure data quality and contribute to strategic initiatives and corporate projects.
• Support to implement the new processes, templates and reporting intelligence in the commercial team.
• Support in ad-hoc commercial / business analysis and presentations
• Support to the Commercial Director in specific strategic initiatives.

Competences

• Strong analytical and problem-solving skills
• Capacity to organize and prioritize effectively in complex and fast-paced environments
• Ability to work collaboratively across different departments and organizational levels
• Strong willingness to learn and continuously develop new skills

Requirements

• Bachelor’s degree
• Fluent English is a must
• Advanced in excel, power point and reporting tools (Power BI)
• Highly valuable 2 years’ experience in consulting
• MBA is valuable