Business Analyst

Job description / Role

GENERAL DESCRIPTION
• The business analyst has to be the centre of our business intelligence for sell in and sell out, sharing all insights with the wider cross-functional teams in order for them to drive actionable plans. Covers total GCC

DUTIES AND RESPONSIBILITIES
• Monitor updates – sell out data management
• Consolidate all raw data received by countries s on a monthly basis and produce clear and concise summary
• Update the master database monthly with all new SKU’s in order to categorize them by brand, category, franchise, format
• Produce summary overviews by country on a monthly basis to read performance across the total market by retailer and compare with total market panel data
• Market analysis and recommendations
• Thorough analysis monthly of market, channel, retailer and brand performance which is communicated to the total division
• Highlight risks and opportunities for the business with clear analytical reasoning plus knowledge of in-market activity and dynamics
• Hair Market phasing, Distribution report, Salon Panel
• Clear reporting of sell out by month O+O
• Monthly market estimation
• Budget and pre-budget revision on a quarterly basis
• Designing new business tracking tools
• Developing tools that aid business tracking of sell in and sell out in a clear and timely way
• Monitor updates – sell out data management
• Consolidate all raw data received by countries s on a monthly basis and produce clear and concise summary
• Update the master database monthly with all new SKU’s in order to categorize them by brand, category, franchise, format
• Produce summary overviews by country on a monthly basis to read performance across the total market by retailer and compare with total market panel data
• Market analysis and recommendations
• Thorough analysis monthly of market, channel, retailer and brand performance which is communicated to the total division
• Highlight risks and opportunities for the business with clear analytical reasoning plus knowledge of in-market activity and dynamics
• Consumer Insights
• Manage Insights projects to provide intelligence to the business for strategy and media decisions
• Hair Market phasing, Distribution report, Salon Panel
• Clear reporting of sell out by month O+O
• Monthly market estimation
• Budget and pre-budget revision on a quarterly basis
• Designing new business tracking tools
• Developing tools that aid business tracking of sell in and sell out in a clear and timely way
• Integrating the use of current business tools available along with unique solutions for specific business cases
• Constantly seeking ways of better and more efficient data management either through new processes or tools
• CMI requests
• Work closely with CMI team to provide division and market estimations
• Inputs on the market to support presentation to CMO and CEO
• Zone projects: O+O
• Participate to enhance and implement zone reports on offline and online channels
• Weekly DSR
• Weekly TO report by brand and by country

Requirements

KNOWLEDGE AND EXPERIENCE
• Experience in roles handling significant amounts of data which need to be simplified ideally close to real business cases
• Excel, Microsoft Access and PowerBI skills required
• 2-5 years working experience required
• Written and spoken English

SKILLS AND ABILITIES
• Analytical with strong excel skills coupled with the ability to draw summaries from large data sets, taking out the ‘so what’
• Strong sense of urgency and timely delivery
• Can remain close to the business dynamics in order to understand the context of analysis
• Continually seeking to perfect and improve current processes and databases to increase business usability and insight

About the Company

For more than a century, we have devoted our energy and our competencies solely to one business: beauty. We have chosen to offer our expertise in the service of women and men worldwide, meeting the infinite diversity of their beauty desires. We are committed to fulfilling this mission ethically and responsibly.