Pricing Analyst

Sonepar Canada, Inc.; Coquitlam; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Benefits package

Employee Assistance Program

Tuition reimbursement

Employee discounts

Life Insurance

Disability insurance

Job summary

Gescan, part of Sonepar Canada, is seeking a Pricing Analyst to join the Pricing team in the Vancouver area. You will analyze trends, build pricing tools, and manage product data with Cognos, Power BI, Excel and SQL.

You will collaborate with internal teams to develop competitive pricing strategies, validate pricing agreements daily, and support IT changes for products, categories, customers and suppliers. A Bachelor’s degree is required and proficiency in MS Office is essential.

Qualifications

• Bachelor's degree in administration or related field.
• Proficient in MS Office (Excel, Access, Outlook, Teams).
• Knowledge of VBA/SQL, Python, Power BI, Power Apps.
• Cognos knowledge is an asset.
• 1-3 years of experience in data analysis or related field.
• Experience in interpretation, data analysis, database management, and dashboard creation.

Responsibilities

• Develop dynamic pricing tools and models to meet business needs.
• Extract, process, and edit reports from Cognos and Power BI (Excel file, Access, pivot tables).
• Perform complex analyses of pricing, product, vendor and customer data using Excel, Power BI, Cognos and databases.
• Analyze market trends with internal teams to develop competitive pricing strategies.
• Prepare and present 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 to support the team.
• Assist for IT changes on products, categories, customers and suppliers.

Skills

Data analysis

SQL basics

VBA basics

Python basics

Team collaboration

Education

Bachelor's degree in administration or related field

Tools

Power BI

Excel

Power Apps

Cognos

Job description

Select how often (in days) to receive an alert:

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.

To explore and learn more about Sonepar opportunities, please visit www.career.sonepar.com

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

• Tool development
• 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, including:

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

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.

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.

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.