Pricing & Margin Analytics Analyst

Lynden Door Inc.; Lynden (WA); On-site; USD 34,440 - 44,083; Full time

Benefits offered by this job

Medical/Dental/Vision insurance

Health Savings Accounts with employers

401(K) options including profit-share

8 Paid Holidays

2-3 Weeks Paid Time Off

Paid Bereavement Leave

Job summary

Lynden Door Inc. in Lynden, WA is seeking a Reporting Analyst to support leaders with costing, price guides, and robust reporting of business operations.

You will transform raw data into actionable insights, focusing on pricing, margin, and performance analyses using SQL, PowerBI, and advanced Excel. In this role, you’ll own pricing data, build dashboards, and collaborate across Estimating, Sales, Purchasing, and Production to drive decisions and continuous improvement.

Qualifications

• Experience writing SQL and leveraging PowerBI.
• Advanced Excel skills.
• Strong organizational skills and attention to detail.
• Discretion and professionalism.
• Strong communication and cross-team collaboration.

Responsibilities

• Perform margin and pricing analysis to support key business initiatives.
• Own and maintain Costing Books alongside Estimating, Sales, and Purchasing.
• Manage Residential price books — including deep-dive margin and price gap reviews.
• Manage Commercial/Architectural Price Guides and multipliers.
• Leverage Power BI to create and maintain production reporting.
• Work with a broad range of stakeholders to understand and document their data needs.
• Establish and maintain connections between data sources and solutions.
• Employ reporting and data modeling best practices.
• Partner with stakeholders across the company to understand and document their data needs.
• Work with Production to build consistent costing methodologies for material, labor, and freight.
• Surface margin performance trends tied to mix shifts and volume commitments.
• Build ad-hoc reports and dig into data issues — researching root causes, correcting master data, and documenting solutions.
• Maintain department KPIs and help evolve how the whole team experiences reporting.

Skills

SQL

PowerBI

Advanced Excel

Attention to detail

Communication

Collaboration

Tools

Power BI

Excel

SQL

Job description

Lynden Door Inc. in Lynden, WA is seeking a Reporting Analyst to support leaders with costing, price guides, and robust reporting of business operations.

You will transform raw data into actionable insights, focusing on pricing, margin, and performance analyses using SQL, PowerBI, and advanced Excel. In this role, you’ll own pricing data, build dashboards, and collaborate across Estimating, Sales, Purchasing, and Production to drive decisions and continuous improvement.