Pricing Data Analyst

JELD-WEN is currently seeking a Pricing Data Analyst to join our growing team.

Reporting to the Canadian Pricing Manager, you will be part of a team responsible for customer analysis and reporting, as well as internal analytics to enhance decision-making processes. This team also ensures pricing accuracy across Canada. Your role will involve creating customer reports that provide actionable insights and developing data analysis tools for both internal and customer use. The ideal candidate will possess strong analytical skills to extract, organize, manipulate, and summarize large pricing datasets, focusing on identifying and resolving pricing discrepancies and errors. You will also be responsible for generating SOX-compliant reports and ensuring all data aligns with industry-mandated controls. A passion for data analysis is essential, along with experience working with large datasets and handling high data volumes. Familiarity with retrieving data from multiple systems and producing comprehensive reports is also required. Additionally, excellent communication skills are vital, as you will collaborate with teams across multiple departments and global locations.

Duties & Responsibilities:

• Analyse customer data to identify key insights and trends.
• Develop data analysis tools to identify any incomplete data.
• Support sales on customer quotes.
• Manage/update price lists.
• Develop both internal and customer facing reports to present the data in the most easily consumable way and surface the key insights from the data.
• Maintain and improve existing data analysis tools and reports.
• Perform Daily SOX CONTROL audit for various Canadian Plants
• Verify potential price discrepancies against the master database pricing in the company’s ERP.
• Utilize query tools to pull custom reports and data to help in analyzing and finding the root cause of any price discrepancy.
• Run BOM (Bill of material) queries for internal stakeholders to aid in item cost analysis.
• Create and maintain Power BI or equivalent visual dashboard showing SOX KPI and audit performance for each plant.
• Chair monthly audit control sessions with each plant to go over data to identify trends or potential areas of concern.
• Track corrective action tickets for discovered pricing errors.

Job Requirements:

• Excellent communication skills - written and verbal.
• Able to proactively work independently while supporting a team.
• Strong ability in prioritizing time sensitive tasks whilst maintaining high levels of attention to detail.
• Intermediate to advance Microsoft Excel skills; using VLOOKUPS and PIVOT tables to sort and organize large data sets.
• Intermediate knowledge of the rest of the Microsoft Office suite including WORD and POWERPOINT.
• Ability to work in a fast-paced environment and function under pressure to meet deadlines.
• Excellent customer service and interpersonal skills to communicate across multiple departments and geographic locations.
• Strong analytical and organizational skills
• Working knowledge and experience using an ERP system is an asset.
• Working experience of SQL Server and/or QlikView (or other, similar reporting databases)
• Experience of using relevant software packages, i.e. SAS, SQL, Excel, QlikView, Tableau, Power BI, Access
• Knowledge of designing/ developing/ maintaining reporting systems
• Have a passion for data and analytics.

#LI-HS1

About JELD-WEN Holding, Inc. 

JELD-WEN Holding, Inc. (NYSE: JELD) is a leading global designer, manufacturer and distributor of high-performance interior and exterior doors, windows, and related building products serving the new construction and repair and remodeling sectors. Based in Charlotte, North Carolina, the company operates across North America and Europe. Our associates are dedicated to bringing beauty and security to the spaces that touch our lives through our market-leading product brands across the world. The JELD-WEN family of brands includes JELD-WEN® worldwide, LaCantina® and VPI™ in North America, and Swedoor® and DANA® in Europe. For more information, visit corporate.JELD-WEN.com or follow LinkedIn.

JELD-WEN has been named by Forbes as one of ‘America’s Best Employers’ and by Newsweek as one of the ‘World’s Most Trustworthy Companies’. 

What We Offer

Investing in People is one of our Core Values, we strive to attract & retain great people! As such, JELD-WEN offers competitive compensation & benefits packages. As a global organization, specific benefits may vary, however typically including medical & dental, retirement program, etc.

JELD-WEN is an equal employment opportunity employer and does not tolerate discrimination, harassment, and/or retaliation based on individuals’ physical traits, beliefs, and/or other characteristics that are protected under applicable laws.

JELD-WEN does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services.