Pricing & Promotions Analyst

Rexall Pharmacy Group Ltd.; Mississauga; On-site; CAD 55,000 - 75,000; Full time

Job summary

Rexall Pharmacy Group Ltd. is seeking a Pricing & Promotions Analyst to support a cross-functional initiative aimed at optimizing Rexall's promotional activities.

You will act as a consultant to Category Management partners, delivering fact-based insights to improve sales, margin and promotions' effectiveness. Reporting to the Manager, Pricing and Promotions, you will forecast, track and report promotional performance across multiple front-of-store categories, and collaborate with Category

Qualifications

• 2-3 year College Diploma in a related field.
• Analytical approach with attention to detail and data exploration.
• Strong organizational and multi-tasking skills.
• Customer-focused and collaborative team player.
• Excellent written and verbal communication skills.
• Solid proficiency with Microsoft Excel; Access preferred.

Responsibilities

• Forecast, track and report sales, margin and promotional impact across categories.
• Collaborate with Category Managers/Directors to optimize promotions and strategies.
• Recommend sales, margin and basket-driving promotions based on trends.
• Analyze data to identify baseline and incremental effects of promotions.
• Own real-time forecast and provide reporting relative to targets and metrics.
• Develop and update promo reports and monthly scorecards.

Skills

Analytical skills

Attention to detail

Time management

Communication

Team player

Education

College Diploma (2-3 years)

Tools

Excel

Access

Job description

Job Purpose Reporting to the Manager, Pricing and Promotions, this role will be an integral member of a high-profile, cross functional-strategic initiative focused on optimizing the effectiveness of Rexall’s promotional activities. The Pricing & Promotions Analyst acts as consultants to key Category Management partners, providing fact-based insights and recommendations to improve total sales, margin and overall promotions' effectiveness.

Job Purpose Reporting to the Manager, Pricing and Promotions, this role will be an integral member of a high-profile, cross functional-strategic initiative focused on optimizing the effectiveness of Rexall’s promotional activities. The Pricing & Promotions Analyst acts as consultants to key Category Management partners, providing fact-based insights and recommendations to improve total sales, margin and overall promotions' effectiveness.

Job Dimensions

DIRECT REPORTS: None
FINANCIAL: None
OTHER: Main contact for 5 -10 Vendors;
400+ Corporate stores
10 Calls per day
50 E-mails per day
10-20 Files to price per day

Principal Responsibilities

• Will be responsible for accurately forecasting, tracking, and reporting the sales, margin, and promotional impact and effectiveness across a range of front of store categories (Cosmetics, Convenience, Beauty and Health etc).
• Work directly with Category Managers and Directors to optimize promotional sales and make recommendations based on trends, targets, promotional strategies
• Provide proactive recommendations on sales-, margin-, and basket-driving promotions
• Monitors and analyzes promotional activities to determine efficiency, accuracy, and performance relative to forecast and identify trends
• Analyze data to calculate baseline sales and margin and estimate incremental sales and margin for promotional within a set of categories.
• Own real-time consolidated forecast; measure and provide reporting relative to category targets and other metrics
• Ad hoc analysis on promotional response to categories
• Support the Manager, Pricing and Promotions to develop and implement product price strategies including segment strategies for the various markets and channels.
• Download and organize baseline price information, analyze and report on inconsistencies, and finds opportunities to optimize sales and profitability through pricing strategies.
• Build various reports such as daily trend report, ad reports, period end reports, etc. for various customers in Merchandising.
• Perform weekly updates to Ad Reporting Tool and develop promo reports on ad hoc basis.
• Update monthly scorecard with new data and present results to team to show performance year over year.
• Perform other duties as assigned including ad-hoc analysis on methods to optimize pricing and promotions through market and pricing strategies.
• Perform other duties as assigned to support Rexall Pharmacy Group Ltd.

Knowledge, Skills And Experience

• 2-3 year College Diploma in a related field.
• Analytical and strong attention to detail: including; exploring data, discovering patterns, relationships, anomalies and trends.
• Excellent organizational, time management and multi-tasking skills.
• Customer-focused and a great teammate.
• Excellent communication skills both written and verbal.
• Solid understanding of Microsoft Office software, specifically Excel. Access is preferred.

Context And Environment

Main liaison for the Merchandise/Marketing division, with the responsibility of ensuring that all analytical requirements are met by collaborating with various internal departments within Rexall Pharmacy Group Ltd. and any external vendors or outsource partners.

Internal Communications

• Marketing
• Merchandise Group /Category Managers
• Operations

External Communications

• Corporate Stores
• Promotion report vendors

Additional Information

Must be flexible and able to travel as required by Rexall Pharmacy Group Ltd.