Analyst - Pricing & Inventory

**Analyst - Pricing & Inventory**

**Position Overview**

**Responsibilities**
**1. Responsible as an Analyst-Pricing**
- Maintenance and development of all pricing models - modify current pricing models or create new pricing models for the organization
- Analyzing the post-performance and effectiveness of vendors to determine the impact of vendor cost increases and to ensure that all pricing reviews and recommendations are based on both cost and pricing impacts
- Based on an analysis of sales expectations, you have developed recommendations for new product pricing according to our company's and brand's GP budgets
- Responsible for managing and preparing the annual pricing recommendation for the department of sales and marketing
- SAP pricing maintenance and processing - list price and vendor price updates
- Based on pricing activity, prepare and analyze reports to ensure that prices and trends are accurate

**2. Responsible as an Analyst-Inventory**
- Generating an inventory management plan to ensure that the necessary inventory levels are maintained
- Determine the root cause of inventory discrepancies and make recommendations to the other departments (sales, marketing and supply chain).
- Identify and analyze the root causes of any negative inventory balances within the assigned locations.
- Provide a monthly report to Supply Chain Management based on the data collected
- Maintaining and processing MRP in SAP

**3. Responsibility as a General Analyst**
- Provide stakeholders with essential information through a suite of reports (PBI & SQL reports)
- Establish, implement, and monitor reporting and analytics to provide other departments with insight and recommendations
- Monitoring the gap between KPIs and budget, where relevant, and providing business stakeholders with actionable insights
- Collaborate with other teams in the actuarial function to facilitate access to data needed in order to complete their projects
- Ensure that reports are accurate and data quality is maintained

**Qualification**
- A bachelor's degree in computer science, economics, mathematics, business administration, information technology, or a related field with a technical focus
- A minimum of three years' experience with MS Power BI and SQL coding as well as the handling of large data sets
- 3 years' experience in the field of data analysis or business analytics
- Expertise in data models, database design and development, data mining, and segmentation techniques.
- Analytical skills with the ability to collect, organize, analyze, and disseminate large amounts of data with great accuracy and detail
- Having the ability to work efficiently and independently or in a cross-functional team environment with mínimal supervision

**Requirements**:

- Expertise in MS Power BI and MS SQL Server Management Studio
- Expertise in Microsoft Excel
- SAP B1 query writing experience is an asset
- Dedicated to solving problems and analyzing data
- Strong problem-solving skills and well-developed analytical skills
- Ability to prioritize and manage multiple requests from a variety of stakeholders
- Ability to work in a team, orientation toward collaboration/teamwork
- Interested in learning and developing on a continuous basis
- Language proficiency in English

**Position Details**:

- Reporting: Director of Virtual Commerce
- Job Type: Permanent
- Schedule: Monday to Friday
- Vacation: 3 Weeks
- Benefits: Heath, Medical and RRSP plans

NOTE: This job description is not intended to be all-inclusive. An employee may perform other related duties as negotiated to meet the ongoing needs of the organization.

**Job Types**: Full-time, Permanent

**Salary**: $39,192.68-$71,212.45 per year

**Benefits**:

- Casual dress
- Dental care
- Extended health care
- Life insurance
- RRSP match
- Vision care
- Work from home

Schedule:

- 8 hour shift
- Day shift
- Monday to Friday

Ability to commute/relocate:

- Mississauga, ON: reliably commute or plan to relocate before starting work (required)

Work Location: Hybrid remote in Mississauga, ON