Pricing Analyst

Job summary

The Pricing Analyst is responsible for analyzing trends across products, customers, and suppliers to develop competitive pricing strategies. This includes creating dynamic pricing tools, managing the product database, and presenting profitability analyses to management.

Job details

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. 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). Benefits & Perks 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: Website: www.Gescan.com Twitter: @gescanwest Facebook: Gescan Canada LinkedIn: Gescan YouTube: GescanTV 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. Next steps: We are interested in knowing more about you. Start an exciting new career and enjoy a number of benefits by applying online. While we are very grateful for your interest in joining the team, only those selected for an interview will be contacted.

What you’ll do

The Pricing Analyst is responsible for analyzing trends across products, customers, and suppliers to develop competitive pricing strategies. This includes creating dynamic pricing tools, managing the product database, and presenting profitability analyses to management.

Requirements

Candidates must hold a bachelor's degree in administration or a related field with 1-3 years of experience in data analysis and database management. Proficiency in Microsoft Office and tools like Power BI, SQL, or Python is required.

Benefits

• Medical Insurance • Dental Insurance • Vision Insurance • Health Spending Account • RRSP Matching • Employee Assistance Program • Tuition Reimbursement • Employee Discounts • Life Insurance • Disability Insurance

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Data analysis · Preferred
• Microsoft Excel · Preferred
• Reporting · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Pricing Analysis
• Data Analysis
• Database Management
• Dashboard Creation
• Microsoft Excel
• Microsoft Access
• Power BI
• Cognos
• SQL
• Python
• VBA
• Power Apps
• Market Trend Analysis
• Financial Modeling
• Profitability Analysis
• Reporting

Job areas

• Data & Analytics
• Finance & Accounting
• Energy
• Logistics
• Retail