Pricing Data Analyst

Jeld-Wen • Garland, TX

440d

About The Position

The Pricing Data Analyst at Jeld-Wen Inc. plays a crucial role in customer analysis and internal analytics to enhance decision-making processes and ensure pricing accuracy across Canada. This position involves creating actionable customer reports, developing data analysis tools, and generating SOX-compliant reports while collaborating with various departments to resolve pricing discrepancies and errors.

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.

Nice To Haves

• Experience with large datasets and handling high data volumes.
• Familiarity with retrieving data from multiple systems and producing comprehensive reports.

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.

Benefits

• Competitive compensation & benefits packages including medical & dental coverage and retirement program.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Wood Product Manufacturing
• Education Level: No Education Listed