Business Intelligence Analyst

hace 3 semanas


Miguel Hidalgo, México CHANEL A tiempo completo
As a Business Intelligence Analyst, you will be in charge to generate processes and models to solve information needs of different business cells (Chanel & Premium Brands) generate, update, and manage semi-automated data visualization dashboards in Microsoft Power BI and Microsoft Excel, for use by different business areas. You will work closely with all functions (Key Account, Retail, Point of Sale Marketing, Training, Press, Logistics)

You will also be a key contact for our distributors, with whom you will be in regular contact.

You will also act as a facilitator between the IT and Business teams.

You will report to the Beauty Fragrances sales team.

Key Responsibilities

Business Analyst

  • Providing the various company departments and top management with analyses and recommendations to feed into business decisions.
  • You will produce “ad hoc” analyses to identify business risks/opportunities or to respond to specific issues.
  • Redesigning all the dashboards used to monitor Sell In and Sell Out figures for the local market using Power BI
  • Reporting/analyzing results, performance, and communication with the sales team, summarizing key information and making proposals on the strategy to be adopted.
  • Preparing customer meetings (sales & targets).

Category Management

  • Working with the Marketing team on building forecasts and analyses to monitor our campaigns and performance.
  • Working with the Marketing and Sales teams to adapt our range to our customers' needs.

Data collection

  • Establishes connections with customer systems to collect sales and inventory data in an automated manner.
  • Captures relevant data on activations, campaigns, and any other relevant information to generate insights.

Data cleansing and transformation

  • Uses tools such as Microsoft Power Query to cleanse and transform data, ensuring data quality and consistency.
  • Integrates data from different sources to obtain a holistic view.

Reporting and Visualization Dashboards

  • Uses Microsoft Power BI and Excel to create semi-automated visualization dashboards that reflect key KPIs and insights relevant to each business area.
  • Design intuitive and customized dashboards for each user or department, allowing easy access to relevant information.
  • Analyzing needs and setting up dashboards, in line with our new organization
  • Power BI development (Power BI Service, Power BI Desktop, DAX, Power Query) in compliance with the Group's IT rules.

Analysis and Insights Generation

  • Analyze data to identify trends, patterns, and opportunities for improvement.
  • Generate actionable insights that can streamline stakeholder decision making and improve business performance.

Quota Setting and Forecasting

  • Uses historical sales data, activations, and market trends to establish accurate monthly sales targets and forecasts.
  • Defines quotas and forecasts nationally and by SKU for each client, also considering future launches and campaigns.

Support to the Commercial Department

  • Provides continuous support to the commercial area cells, offering analysis and recommendations to optimize their performance.

Generation of the Monthly Close

  • Prepares and communicates the monthly sales report, ensuring the accuracy and completeness of the information collected from all customers.
  • Presents results in a clear and concise manner, highlighting key indicators and trends.

Qualitative and Strategic Analysis

  • Performs a qualitative analysis of the information generated to guide the commercial strategy, identifying areas of opportunity and possible improvements.

What are we looking for?

  • Strong project management skills with excellent attention to detail. 
  • Ability to manage and oversee multiple projects concurrently. 
  • Excellent communication and presentation skills. 
  • Advanced Proficiency in Microsoft Office applications, excel & power BI.
  • Ability to work effectively in a collaborative team environment.
  • Must be an organized team player with solid interpersonal skills.
  • Self-motivated, team player, strong at collaborative working relationships. 
  • Position requires a minimum 2-year relevant work experience as a business data analyst, supply chain analyst.
  • Experience working on multiple projects at the same time. 
  • Fluency in English & Spanish is a must have, French is a plus.

  • Business Intelligence

    hace 2 meses


    Miguel Hidalgo, México Willis Towers Watson A tiempo completo

    Business Intelligence (B.I.) Senior Analyst - Miguel Hidalgo, MX June 28, 2023 - This role will be acting as a Business Intelligence (B.I.) resource for the Manila Global Delivery Center. - This role is expected to lead or support the gathering, preparation, validation, analysis, and presentation of business data as well as call out risks and opportunities...


  • Miguel Hidalgo, México Isomar Capital A tiempo completo

    Somos _**ISOMAR CAPITAL**_ una comercializadora multimarcas a través de diferentes plataformas Ecommerce. Creamos alianzas con empresas, usamos software propio, analítica avanzada y proveemos una ágil cadena de suministro para mejorar ventas de ecommerce. Te invitamos a unirte a nuestro equipo de Trabajo como: - **BUSSINES INTELLIGENCE...

  • Intelligence Analyst

    hace 3 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    **Responsibilities**: **Are you looking for a challenging opportunity in an organization with a dynamic, innovative and diverse environment? if so, your future is at PepsiCo.** PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in...

  • Business Intelligence BI

    hace 2 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes LAY’S ®, DORITOS ®, CHEETOS ®, GATORADE ®, PEPSI ®, QUAKER ®...


  • Miguel Hidalgo, México SYNERGO A tiempo completo

    La descripción del empleo no deberá violar la "Ley Federal para Prevenir y Eliminar la Discriminación", la cual incluye discriminación de sexo, edad, origen, raza, color, estado civil, entre otros. Buscamos tu talento como Business intelligence -Data Analyst **Responsabilidades**: Procesamiento de información y elaboración, de reportes...

  • Business Intelligence

    hace 4 días


    Miguel Hidalgo, Ciudad de México WTW A tiempo completo

    This role will be acting as a Business Intelligence (B.I.) resource for the Manila Global Delivery Center. This role is expected to lead or support the gathering, preparation, validation, analysis, and presentation of business data as well as call out risks and opportunities based on that data. This role is expected to understand the critical and changing...

  • Business Intelligence BI

    hace 2 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    **Overview** PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes LAY’S ®, DORITOS ®, CHEETOS ®, GATORADE ®, PEPSI ®, QUAKER...

  • Business Intelligence

    hace 2 meses


    Miguel Hidalgo, México WTW A tiempo completo

    This role will be acting as a Business Intelligence (B.I.) resource for the Manila Global Delivery Center. - This role is expected to lead or support the gathering, preparation, validation, analysis, and presentation of business data as well as call out risks and opportunities based on that data. - This role is expected to understand the critical and...

  • Business Analyst

    hace 3 semanas


    Miguel Hidalgo, México DESYSNET A tiempo completo

    **Business Analyst** **Modalidad remota** **Años de experiência: +3 años** **Requisitos**: - Experiência en Bancos con la capacidad de entender y conocer la parte del negocio, flujos completos de trabajo. - Dar seguimiento en los nuevos proyectos - Conocer fabrica de crédito hasta DWH (DataWhareHouse) Tipo de puesto: Tiempo completo, Por tiempo...

  • Intelligence Analyst

    hace 4 días


    Miguel Hidalgo, Ciudad de México PepsiCo A tiempo completo

    Responsibilities:Are you looking for a challenging opportunity in an organization with a dynamic, innovative and diverse environment? if so, your future is at PepsiCo.PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue...

  • Business Analyst Sr

    hace 2 meses


    Miguel Hidalgo, México DESYSNET A tiempo completo

    **Business Analyst Jr** **Modalidad: Remota / Sitio** **Años de experiência:+5 años** **Actividades del puesto**: Responsable del ciclo completo de levantamiento de requerimiento, documentación y seguimiento a la implementación con equipos de TI y diversos stakeholders. **Requisitos**: - 4 años de experiência como Business Analyst (en sector...

  • Business Intelligence

    hace 2 semanas


    Miguel Hidalgo, México EMPRESA SOCIA DE AMEDIRH A tiempo completo

    Empresa socia de Amedirh solicita “BUSINESS INTELLIGENCE” **Requisitos**: - Licenciatura con especialidad. - Mínimo 3 años en desarrollo de negocios, inteligencia de negocios e inteligencia de mercado. **CONOCIMIENTOS** - Implementar la estrategia de desarrollo de oportunidades de negocio, es de perfil hunter y analítico. Se encarga del análisis...

  • Business Analyst

    hace 2 meses


    Miguel Hidalgo, México DESYSNET A tiempo completo

    **Business Analyst** **Modalidad: Híbrida ( sitio/ remoto)** **Años de experiência: +3 años** **Importante experiência en SERCTOR BANCARIO Y TESORERIA** **EXPERIENCIA**: - Administración o afines / Ingeniería en Sistemas o afines - +3 años de experiência - Negociación y resolución de conflictos - Experiência en planeación y gestión de...


  • Miguel Hidalgo, Ciudad de México RH21 A tiempo completo

    Importante empresa del giro de tecnología solicita:Business Intelligence Jr.Requisitos:Experiência en Business inteligenceConocimientos deseables en: tecnologías para desarrollo de Querys, conexión entre sistemas de Qliksens y con ambientes de: Mysql, SQL Server y Javascript, Google Data Studio, Kubernetes.Ofrecemos:Excelente ambiente laboral,...


  • Miguel Hidalgo, Ciudad de México SYNERGO A tiempo completo

    La descripción del empleo no deberá violar la "Ley Federal para Prevenir y Eliminar la Discriminación", la cual incluye discriminación de sexo, edad, origen, raza, color, estado civil, entre otros.Buscamos tu talento como Business intelligence -Data AnalystResponsabilidades:Procesamiento de información y elaboración, de reportes administración de...


  • Miguel Hidalgo, Ciudad de México myGwork - LGBTQ+ Business Community A tiempo completo

    This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community. Our Purpose And Growth CultureWe are taking deliberate action to nurture an inclusive culture that is grounded in our company purpose, to refresh the world and make a difference. We act with a growth mindset, take an expansive approach to what's...


  • Miguel Hidalgo, Ciudad de México myGwork - LGBTQ+ Business Community A tiempo completo

    This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community. Our Purpose And Growth CultureWe are taking deliberate action to nurture an inclusive culture that is grounded in our company purpose, to refresh the world and make a difference. We act with a growth mindset, take an expansive approach to what's...

  • Business Intelligence

    hace 4 semanas


    Miguel Hidalgo, México BNN A tiempo completo

    **Vacante para la empresa BNN en Lomas Altas -Miguel Hidalgo, Ciudad de México**: En BNN, buscamos tu Talento para el área de Business Intelligence en Agencia de Marketing Digital, tenemos un lugar para ti. Requisitos para el puesto: - Lic. Mercadotecnia, Actuaría, Administración, o afín. - Dominio de herramientas de Social Listening. - Conocimiento...


  • Miguel Hidalgo, México Comercializadora de Vinos y Licores E. A tiempo completo

    _**Requisitos**:_ - Licenciatura concluida - Mínimo un año de experiência análisis de datos - Desarrollo de KPIS - Conocimiento de sell in sell out - Conocimientos técnicos: Excel Avanzado, SQL Avanzado, Cubos Tabulares y Multidimensionales, Power BI Avanzado, DataFactory, SAP - **Funciones**:_ - Análisis de grandes bases datos que nos ayuden a generar...


  • Miguel Hidalgo, México GSB Consulting Group A tiempo completo

    **Purpose of the role**: Analyze financial and prepare key information in the form of reports and dashboards. Advise on potential risk, improvements and discrepancies. **Responsabilities**: - Collaborarion and coordination on the process of creating the annual budget and forecast. - Collaboration and coordination of the month end closing process. -...