Pricing Analyst

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

With over 60 years of industry experience, Gescan has 29 branches located across Western Canada. At Gescan, we leverage our strong global resource base, our local expertise, and our family-oriented values to deliver the best service to our customers and suppliers.

We are a proud member of the Sonepar Group, the world's largest privately-held electrical distributor. The Sonepar Group is present in more than 40 countries with over 45,000 employees. In Canada, we are represented by 6 locally managed electrical and industrial distributors and have over 110 locations with coverage in 9 provinces.

What’s In It For You?

• You will be joining a market leader with over 40 years of experience to help you elevate your potential.
• You will be working for the world's #1 privately held business to business distributor of electrical products and related solutions.
• A chance to get involved in the forever growing electrical industry.
• We house the largest inventory to better service our customers and deliver on sales commitments.
• An opportunity for career development across many business departments within our organization.

Scope

Under the supervision of the Pricing Manager, the primary mandate of the Pricing Analyst is to analyze any trend, from products, categories, customers and suppliers. The analyst will be responsible for the creation, structure and management of the product database.

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 customer data using Excel, Power BI, Cognos, and our internal and external databases.
• Analyze and interpret market trends in collaboration with internal teams for the purpose of developing competitive pricing strategies;
• Analyze data from a variety of sources to better understand pricing strategies, better structure our customer types, and better aggregate our products and suppliers.
• Prepare and present the results of the pricing and profitability analysis to management.
• Keep abreast of different methods of price analysis, industry trends, and database management
• Develop dynamic tools to improve database management.
• Participate in the management of the information of the database and ensure the compliance of the information found therein and propose solutions.Team Support
• Validate and approve pricing agreements on a daily basis to understand the pricing cycle and support the team as needed.
• Assist the team in preparing for IT changes on products, categories, customers and suppliers.
• All other related tasks.

Required

• 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).

We offer a competitive salary, plus a full set of benefits.

• Benefits program allowing you to choose from options that best fit you and your dependents’ needs. Benefit options include: Medical, Dental, Vision, Health Spending Account & RRSP matching.
• Employee Assistance Program, Tuition Reimbursement, Employee Discounts and a career path.
• Regardless of your benefits program, you will receive company paid Life Insurance, and employee paid disability.

Social Media:

Sonepar places the planet and diversity and inclusion at the core of its vision driving our business ethos.

Today, Sonepar is the leading distributor of energy-efficient products, pioneering the energy transition and making sustainability a priority. At Sonepar, we firmly believe that every action is crucial in safeguarding the environment, driving our commitment to a more sustainable future. We have accelerated our own transition to efficient generation and use of electrical energy across our business and champion the innovation of sustainable solutions in the market.

This commitment is tangible in our detailed Global CSR report, to learn more please visit https://www.sonepar.com/en/commitments/sustainability.

Sonepar has been recognized as a Diversity Leader by the Financial Times’ 2024 Diversity Leaders ranking and was awarded GEEIS Certification in 2022. We are proud to be an equal opportunity employer, welcoming submissions from all candidates. We believe in creating a work environment where everyone can feel safe, use their voice, and know that they belong. Diversity and Inclusion (D&I) is a central focus of our global, strategic impact plan. We value diversity and inclusion in the workplace because it allows us to better meet the needs of the communities we serve. It helps us foster greater creativity, breadth of experience, and it’s essential to our success as an organization. All qualified individuals, regardless of race, ethnic or national origin, colour, religion, sex, sexual orientation, age, marital status, neurodiversity, disability status, gender identity, veteran status or any other aspect which makes them unique are encouraged to apply.

For more information about our Inclusion and Diversity initiatives, please visit https://www.sonepar.com/en/commitments/diversity-and-inclusion.

Sonepar is an equal opportunity employer and welcomes submissions from all candidates. Accommodation is available to all applicants upon request. If selected for an interview, please advise the Sonepar representative of your accommodation needs at that time. We will work with all applicants to accommodate their accessibility needs.