Commercial Analyst

REPORTS TO:

Commercial insight & Forecasting Manager

PURPOSE

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

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

PERSON SPECIFICATION

• 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

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.