Hiring Business Pricing Analyst (Pricing Strategies, SKUs, Power Query, Advanced Excel Formulas, Macros, DAX, MS Access, SQL, Financial Analysis & Reporting, Ad hoc Analysis). Preference will be given to candidates whose resumes clearly meet the required experience and requirements outlined below. Professionals with suitable experience may send their updated resume to Requirement SummaryJob Role/Title: Business Process & Pricing AnalystJob Type: Contract Opportunity. Initial 6-month contract with good possibilities for extensions.Job Location: North York, Ontario M2J 4W8, Canada. Work Style: Hybrid Work Setting - 4 days in the office required Work Hours: 35 hours/week, typically Monday-Friday 9:00 am to 5:00 pmRate Cap: $35-40/Hr. (on Incorp.). The compensation will be negotiated between the contractor and recruiter based on experience and engagement terms.Interview: Teams interviews; 2 interviews___________________________________________________________Position Overview: The Business Pricing Analytics consultant will be reporting directly to the Sr. Director, Front Store Pricing. The incumbent analyzes, recommends, implements, and monitors the effectiveness of pricing initiatives by SKU by price zone, ensuring that products are priced and stores are zoned in accordance with the Client's (Retail Pharmacy) Pricing Strategy.Responsibilities:The incumbent is responsible for maximizing regular sales and margin rate/dollars and accountable for delivering annual margin rate improvements. The incumbent will provide support to and liaise with stores, internal departments, and regional teams regarding pricing initiatives, issues, and opportunities.Analyzes and recommends changes to ensure that each product is priced and each store is assigned to zones in accordance with our client's Pricing Strategy.Analyzes and monitors category sales, units, and margin rate/dollars to maximize regular sales and margin rate/dollars.Analyzes the regional Competitive Price Index to ensure indices are in line with our client's Pricing Strategy by changing product retail prices.While conducting all activities, be able to identify and proactively act upon any regular sales and margin rate/dollar opportunities and challenges.Analyses and recommends the price zone assignment to be implemented in new capital stores and coordinates with all parties.Analyzes weekly Flyer items and creates Corporate Brand Shielding items to increase Corporate Brands' sales and maximize category regular sales and margin dollars. Coordinates SKUs with Inventory Management to ensure a high service level.Investigates and addresses inquiries on pricing from stores and/or customers and makes necessary adjustments.Creates Category Retail Reviews (a comprehensive review of all SKUs by zone, including relationships between brands, sizes, competitors, etc.), resulting in retail change recommendations to maximize category regular sales and margin rate/dollars.Reviews, recommends, and maintains the relevancy of Key Value Indicator SKUs.Liaise with relevant stakeholders (e.g., Category Managers, Regional Directors, District Managers, etc.) to resolve pricing issues and drive forward various pricing initiativesDevelop store-level communication: direction, reference, etc.Prepares ad hoc analyses for management requests.Recommends and executes price changes based upon observations of competitive retailers observed while on periodic store audits.Supports the Merchandising Promotions team in the resolution of pricing-related issues in promotional events. Required Capabilities:This position requires a demonstrated level of analysis capability, initiation, and judgment to organize and prioritize tasks, workload, and projects. Courtesy, tact, and diplomacy are required in dealing with colleagues in everyday working relationships.Excellent organization, written and verbal communication skillsAdvanced MS Office skills ( Excel, Word, Access)Experience writing SQL queries and using Power Query (or similar platform) to join data from multiple sourcesFinancial analysis skillsStrong analytical ability, problem-solving, and attention to detailAbility to work with all levels of managementStore experience is considered an assetProfessional manner, tact, diplomacy, and discretion in dealing with associates and colleagues, including senior management.Adaptable to set and prioritize work with varying exceptions. Able to work with diverse personalities and styles.Understanding of pricing strategiesPost-secondary education equivalent to a university degree in business, finance, economics, or a related fieldMinimum 2 years of business analysis or equivalent experience.___________________________________________________________ How to Apply: Please email your up-to-date Resume/CV to We appreciate all the applicants for their interest in working with us; however, only those candidates shortlisted for the next steps in the hiring process will be contacted.Thank you, and have a wonderful day!
Job Title
Retail Pricing & Procurements Analyst (ad-hoc projects and business process anal