Market Insights & Business Intelligence Lead

Role: Market Insights & Business Intelligence Lead

General Description: Drive and implement the market insights and business intelligence action plan by providing high-quality deliverables into the growth strategy of the business. Analyze product performance, competition, sales (actuals and prospective). Automatize data collection and consolidation to enable more data driven decision making.

Responsibilities

• Automatize sell-out data collection and consolidation for local and regional reporting (One Market, Beauty Market Sell Out, Sell-ins, E-commerce, 3Y plans, Beauty Marche)
• Leverage and develop synergies with data analysts and harmonize sell out templates across divisions for local reporting.
• Capture category x country x channel dynamics to provide management with thorough reports and results, including insights to forecast beauty market trends.
• Conduct SWOT on competitors / categories to assess opportunities for L’Oreal Middle East
• Build and update 3Y market projections
• Improve reliability of estimates O+O
• Coordinate relationship and deliverables with Nielsen retail Intelligence team including trainings, panel delivery and prepare note for management.
• E-commerce mapping and market sizing (pure players, e-retailers, D2C) definition, update and forecast per category per country.
• Lead key strategic pieces of work like panel coverage, e-commerce market construction, etc.
• Present insight findings to key stakeholders, with actionable recommendations for decision making. Align stakeholders on data.
• Provide quality assurance across insight outputs produced across CMI (panels, sell-out, retailer, social data..)
• Undertake statistical analysis of CMI data using Excel and/or data visualization tools
• Contribute to research presentations, reports and briefings across the range of management and leadership challenges.
  
  

Knowledge & Experience

Education/ Qualification: Educated to degree level or equivalent, training in data mining field or equivalent is a plus.

No of years’ experience: 3 / 4 years

Essential experience: 2+ years in sales/marketing/ market research analytics generation experience. Excellent working knowledge of data analysis programs (Advanced Excel, SQL, R, SPSS, etc.) and data visualization (Microsoft BI, Tableau, etc.).

Skills & Abilities

• Ability to derive insight from data.
• Experience of carrying out advanced analysis of large datasets, using Excel or else. Ability to integrate multiple data sources (retailer panels, financial data, channel, shopper, etc.) to create meta-analysis.
• Ability to collaborate seamlessly with agency partners and internal teams to collect, present data and insights.
• Contribute to research presentations, reports and briefings across the range of management and leadership challenges.
• Work flexibly within the research and insight team to contribute to support wider strategic projects across CMI as and where appropriate.