Pricing & Promotions Analyst

Rexall; Mississauga; On-site; CAD 55,000 - 70,000; Full time

Job summary

Rexall Pharmacy Group Ltd. in Mississauga seeks a Pricing & Promotions Analyst to join a cross-functional initiative to optimize Rexall’s promotional activities.

You will act as a consultant to Category Management partners, delivering fact-based insights to improve sales, margin and promotion effectiveness. You will forecast, track and report impact across categories, work with Category Managers and Directors to optimize promotions, and develop pricing strategies with robust reporting.

Qualifications

• Analytical mindset with strong attention to detail and trend analysis.
• Excellent organizational, time management and multi-tasking skills.
• Customer-focused and a great teammate.
• Excellent written and verbal communication.
• Strong Excel skills; Access experience preferred.

Responsibilities

• Forecast, track, and report sales, margin, and promo impact across front-of-store categories.
• Collaborate with Category Managers and Directors to optimize promotional sales and strategies.
• Provide proactive recommendations on sales, margin and basket-driving promotions.
• Monitor and analyze promotional activities for efficiency and forecast accuracy.
• Analyze data to estimate baseline and incremental sales/margin for promotions.
• Own real-time consolidated forecast and report against targets.
• Develop and maintain promo reports and monthly scorecards.
• Assist in pricing strategy development and market segment strategies.
• Download and organize baseline price data and identify pricing opportunities.

Skills

Analytical skills

Attention to detail

Time management

Communication

Excel

Education

2-3 year college diploma

Tools

Excel

Access

Job description

Salary Range: $55,000.00 To $70,000.00 Annually

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

Main contact for 5 -10 Vendors;

10-20 Files to price per day

• 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

Additional Information:

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