Pricing Analyst Job Coquitlam area,BC Canada,Business

About Us:

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

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

Benefits & Perks

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.

Social Media:

Website:

Facebook:
Gescan Canada

You Tube:
GescanTV

Sonepar places the planet and diversity and…