About This Role
Analyzing trends in products, categories, customers, and suppliers is the primary focus of this Pricing Analyst role, which also involves creating, structuring, and managing the product database. The position suits an analyst with strong data interpretation and database management skills.
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 current pricing, product, vendor, and customer data using Excel, Power BI, Cognos, and 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, structure customer types, and aggregate products and suppliers
- Prepare and present the results of 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 database information, ensure its compliance, and propose solutions
- 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
- Perform all other related tasks
Requirements
- Bachelor's degree in administration or a 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
- 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
- Basic programming experience
Nice to have:
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
- Company-paid Life Insurance
- Employee-paid disability
Application Process
About the Company
Gescan has over 60 years of industry experience with 29 branches across Western Canada. It is a proud member of the Sonepar Group, the world's largest privately-held electrical distributor, present in more than 40 countries with over 45,000 employees. In Canada, Sonepar is represented by 6 locally managed electrical and industrial distributors and has over 110 locations with coverage in 9 provinces.
