DIOR Commercial Analyst

Parfums Christian Dior; Greater London; On-site; GBP 45,000 - 60,000; Full time

Job summary

Parfums Christian Dior in London is seeking a Commercial Analyst to turn data into actions that drive UK & Ireland retail growth.

You will prepare daily, weekly and monthly sales reports, own Power BI rollout, collaborate with finance and retailers, monitor KPI and stock, and provide insights to management.

Qualifications

• Degree qualified with a high level of mathematical ability.
• Strong analytical mindset with commercial awareness.
• Experience with Power BI and data visualization preferred.

Responsibilities

• Prepare daily, weekly and monthly retail sales reports for management.
• Champion Power BI rollout and train super users.
• Create and roll out Power BI company-wide and manage rollout.
• Provide weekly data insights and KPI reporting.
• Collaborate with Finance and Retail teams on sales vs. stock.
• Set and review group retail sales targets with Commercial Managers.

Skills

Power BI

Advanced Excel

PowerPoint

Mathematical ability

Education

Degree level

Tools

MS Office suite

MS MapPoint

Access DB

Job description

Position

POSITION: Commercial Analyst

DEPARTMENT: Commercial

LOCATION: London

REPORTS TO: Commercial insight & Forecasting Manager

PURPOSE

To turn business insights into actions which deliver increased retail growth in the UK and Ireland market.

Job responsibilities

Main Responsibilities

• To prepare daily, weekly and monthly retail sales reports for management ensuring accuracy and timely delivery.
• Be the commercial champion for Power BI - Work in partnership with the Business Application Manager and the Commercial Managers for all retailers, to ensure the successful implementation of Power BI for the UK sales team.
• Be the lead for PBI roll out including creating and training super users and successfully manage the rollout company wide
• Use Power BI to provide weekly data and insights
• Find new ways to amalgamate current reports between retail and commercial opps
• Provide commercial Insights: Weekly, Monthly, Quarterly insights into sales performance and the impact to company and stock. Work with circana data to check sales data and provide data v market. To identify, on an ongoing basis, opportunities to enhance and issues which are negating retail sales. To work with the management team to define KPI’s and prepare a KPI report monthly.
• To create and analyse sales trackers for newness, Seasonal lines and key lines trackers, providing accurate sales data and analysis.
• To prepare weekly inventory reports and recommended action plans to Sales Managers.
• To work with the Finance Brand Analyst/Controller daily to ensure consistency and accuracy of sales and financial data, and to track retail sales performance versus wholesale sales.
• To manage the process of setting and reviewing group retail sales targets with the Commercial Managers and the store targets.
• To provide retailer sales data for commercial managers on a monthly basis, providing sales and intake performance.
• To support with AD HoC reports for commercial team

Profile

PERSON SPECIFICATION

Key Competencies

• Analytical: The desire to understand the underlying root causes of issues
• Project Management: The ability to initiate, scope and manage complex cross functional projects. Confident at working on ad hoc projects which may have short deadlines.
• Commercial Awareness: An understanding the impact of actions upon the P&L and sensitive to the differing objectives of retailers and internal cross functional teams
• Problem solving: A constant quest to improve the status quo and improve effectiveness, through identification of and recommending solutions to resolve issues and maximize opportunities
• Presentation Skills: Strong ability to articulate analysis into recommended action plans to senior management and retailers

Technical Skills

• Power BI efficient
• MS Office, including MS MapPoint and Access DB
• Advanced Excel and Powerpoint
• Degree qualified with a high level of mathematical ability

Profile

The Commercial Analyst will be an inquisitive, self motivated, team player, who will create opportunities and be able to articulate them across the organisation. The Analyst may be Finance trained and wishing to develop their career in a more commercial role, whilst still working closely with Finance.