Pricing Analyst: Data-Driven Pricing & Market Insights

Gescan; Coquitlam; On-site; CAD 70,000 - 95,000; Full time

Benefits offered by this job

Benefits package with Medical, Dental,

RRSP matching

Employee Discounts

Job summary

Gescan, a member of the Sonepar Group with over 60 years of experience in Western Canada, is seeking a Pricing Analyst in the Metro Vancouver region to join the Pricing Manager's team. You will develop pricing tools, analyze data with Excel, Power BI, Cognos, and drive pricing strategies across products and suppliers.

A Bachelor's degree and 1–3 years of experience, plus strong Office and SQL skills, are required.

Qualifications

• Bachelor’s degree in administration or related field.
• Excellent command of Microsoft Office suite tools (Excel, Access, Outlook, Teams).
• Good knowledge of technological tools such as MS VBA/SQL, Python, Power BI, Power Apps.
• Knowledge of Cognos (an asset). A minimum of 1-3 years of experience in the field and/or related field.
• Experience in interpretation, data analysis, database management, and dashboard creation.
• Programming experience (basic).

Responsibilities

• Develop dynamic pricing tools and models to effectively meet business needs.
• Extract, process, and edit reports from Cognos and Power BI (Excel file, Access, pivot tables).
• Perform complex analyses of our current pricing, product, vendor and customer data using Excel, Power BI, Cognos, and databases.
• Analyze and interpret market trends with internal teams to develop competitive pricing strategies.
• Analyze data from various sources to better understand pricing strategies and aggregate products and suppliers.
• Prepare and present the results of pricing and profitability analysis to management.
• Keep abreast of price analysis methods, industry trends, and database management.
• Develop dynamic tools to improve database management.
• Validate and approve pricing agreements daily and support the team as needed.
• Assist the team in IT changes on products, categories, customers and suppliers.
• All other related tasks.

Skills

Excel

Access

Outlook

Teams

MS VBA/SQL

Python

Power BI

Power Apps

Cognos (asset)

Education

Bachelor's degree in administration or related field

Tools

Job description

Gescan, a member of the Sonepar Group with over 60 years of experience in Western Canada, is seeking a Pricing Analyst in the Metro Vancouver region to join the Pricing Manager's team. You will develop pricing tools, analyze data with Excel, Power BI, Cognos, and drive pricing strategies across products and suppliers.

A Bachelor's degree and 1–3 years of experience, plus strong Office and SQL skills, are required.