Customer Management Analyst

Overview:
PMA Canada is a leading private agent and distributor of fine wines and spirits in Canada. We represent a number of premium brands in the beverage alcohol industry. We have delivered strong, sales growth since the Company began business over 40 years ago. We pride ourselves on providing Service Excellence for our Suppliers, Customers & Consumers

The objective of the Customer Management Analyst position is twofold:
1) Support the retail Key Account Managers across the business through providing tools, insight, and analytic support in efforts to drive order generation within liquor board customers and 2) Support the Trade Development and Brand Management teams through publishing regular reporting and maintaining/enhancing established tools to support vital business processes

**Responsibilities**:

- Develop and maintain Excel based customer facing inventory management tools to support the retail Key Account Managers
- Integrate outputs from the National forecast process into the inventory management tools to facilitate predictive modelling of future inventory requirements
- Within liquor board markets, review inventory position on a regular basis and highlight future inventory shortfalls to Key Account Managers to support order generation
- Monitor open purchase orders within liquor board markets and engage with the Brand Management team or supplier representatives to address any orders projected to ship later than the customer expected ship date
- Produce regular reporting on inventory availability within the LCBO warehouses for products on promotion and communicate inventory transfer requirements to the Key Account Managers
- Conduct analysis as required to support the Key Account Managers in addressing continual challenges driving out of stock situations with the customer (i.e., inadequate order frequency, timing of order generation, lead times, stock level minimums in regional distribution centres)
- Track actual sales performance and inventory receipts against projections provided by the liquor boards (where applicable)
- Provide regular reporting to the Sales Execution and Brand Teams on stock position within the liquor board markets
- Maintain Excel based retail activity trackers for Trade Development Managers and Budget Planners for Brand Managers. Activities inclusive of product additions/removal, promotional costing updates and regular maintenance
- Update and publish regular reporting (Excel based) to the business on promotional activity (National Grid, Project Trafficking Report), and reporting to support the Brand Teams with budget management in relation to retail promotional activity (Calibration Report)
- Update/Maintain the National Listing Tracker report
- Generate retail promotional activity extracts on a regular basis for the Commercial Finance team to support the National forecasting process
- Provide training to the Brand and Trade Development teams as required on standardized reporting

**Core Competency Requirements**:

- Developing Positive Working Relationships: Builds effective relationships at all levels to gain alignment and co-operation Strategic Orientation: Looks at issues from a broad range of different perspectives; exercises sound judgement in making decisions; takes timely decisions based on analysis, experience, wisdom and judgement
- Entrepreneurial risk taking: Champions new ideas and new business opportunities and fosters innovation
- Analytical Acumen: Understands key indicators of performance. Analyses trends and information relating to an opportunity to glean insights before providing recommended actions. Identifies information gaps and makes specific inquiries to verify facts and make reasonable assumptions
- Influencing: Promotes ideas and proposals effectively, projects a positive image, presents a strong business cases
- Delivering Results: Strong personal commitment to deliver to expectations or above
- Communicating with Impact: Expresses self in a clear, succinct and compelling manner in both individual and group situations; outstanding communication styles and to different audiences and levels

Qualifications:

- 3+ years’ experience in an analyst role supporting sales or marketing teams
- Experience within the Canadian Beverage Alcohol industry is not a requirement but considered an asset
- Completion of Post-Secondary education with a degree in Business Administration or any related field combined with training in sales and business management
- Practical Experience within and understanding of supply chain / demand planning processes
- Highly developed organizational, communication and presentation skills
- Strong attention to detail and accuracy
- Ability to quickly learn a business process and identify/recommend improvements
- Ability to identify and manage various stakeholder priorities
- Exercise professional conduct and sound judgement in all areas
Computer literacy: Advanced working knowledge of Microsoft Excel with an ability to underst