Vendor Pricing Analyst

Vallen Distribution, Inc; Edmonton; On-site; CAD 65,000 - 85,000; Full time

Job summary

Vallen Distribution, Inc. seeks a Vendor Pricing Analyst to support pricing records and data maintenance in the SXe database, reporting to the Vendor Pricing Manager.

Responsibilities include pricing reviews, data updates, troubleshooting inaccuracies, and facilitating pricing changes with the internal supply chain team. Strong Excel/Access skills and familiarity with VBA/SQL/Python are valued.

Qualifications

• College/University Diploma in Computer Sciences and/or BComm required.
• MS Office proficiency with strong Excel and Access skills.
• VBA, SQL, and/or Python knowledge is an asset.
• BI tools Power BI and Cognos are assets.

Responsibilities

• Provide analysis and reporting on impacts from proposed vendor pricing changes.
• Work with large data sets to update and maintain vendor pricing records.
• Troubleshoot pricing issues and inaccuracies.
• Facilitate pricing updates with internal supply chain team.
• Facilitate product data change requests.
• Administer active vendor price list files and SXe database maintenance.
• Prepare reports for distribution to the Supply Chain team.
• Suggest improvements to existing pricing processes.

Skills

Pricing analytics

Data analysis

Excel

Access

SQL

Python

Power BI

Education

College/University Diploma in Computer Sciences and/or BComm

Tools

Power BI

Cognos

SXe database

Job description

Reporting to the Vendor Pricing Manager, the Vendor Pricing Analyst is responsible for maintaining vendor pricing records and assisting with product data maintenance in the SXe database. This includes conducting pricing reviews, troubleshooting pricing inaccuracies, maintaining promotional pricing, mass maintenance of product data, preparing reports and other documents, as well as the continuous improvement of existing processes.

Key Responsibilities:

• Provide analysis and reporting on impacts from proposed vendor pricing changes.
• Work with large sets of data to update and maintain vendor pricing records.
• Troubleshoot pricing issues and inaccuracies.
• Facilitation of the pricing update process from our internal supply chain team
• Facilitation of product data change requests
• Control lifecycle of promotional pricing opportunities
• Administration of active vendor price list files
• Ongoing SXe database maintenance and improvement
• Administration and data entry for Vendor Pricing Database including vendor price updates, discount structures, unit conversions, and more.
• Prepare reports and other documents for distribution to the Supply Chain team.
• Work with Vendor Pricing Manager to detail and improve existing pricing processes.
• Read, understand, and follow Vallen's health, safety, and environment policies and all applicable OH&S legislation/regulations.
• Other duties as required.

Requirements

Education & Training:

• College/University Diploma in Computer Sciences and/or BComm required.
• Knowledge of Microsoft Office required, including strong Excel and Access skills.
• Knowledge of VBA, SQL, and/or Python an asset.
• Knowledge of BI Tools (Power BI, Cognos) an asset.

Additional Locations

Edmonton , Alberta , Canada