Reporting 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 in Lynden, WA has an immediate opening for a Reporting Analyst. At Lynden Door we strive to be a relational company that provides world class industry leading quality, value, service, and innovation.

Role Overview

The Reporting Analyst supports business leaders and core team members by maintaining costing, price guides and other sales tools, and by providing timely and accurate reporting and analysis of business operations. The Reporting Analyst will have the opportunity to build momentum in our ongoing transformation of data and enhancing our platforms and business processes. Do you love turning raw numbers into decisions that actually move a business? We're looking for a Reporting Analyst to be a go-to person for pricing, costing, and performance data across our organization. If you are someone who is confident writing SQL queries and leveraging PowerBI, finds real satisfaction in clean data, performs reasoned analysis, and appreciates high-functioning excel-based business tools, read on!

Hours: Full-time, in-office, 8:00- 5:00 Monday to Friday.

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.

What You Bring

• Knowledge and experience writing SQL and leveraging PowerBI.
• Strong organizational skills and sharp attention to detail.
• A problem-solving, analytical mindset.
• Advanced proficiency in Microsoft Excel.
• Discretion and professionalism when handling sensitive data.
• Strong communication skills and the ability to build trust across teams and cultures.
• A collaborative, service-minded approach to work.

Role

What Makes This Role Rewarding for a Data-Minded Person

• You'll own the numbers that matter. From margin analysis to KPI tracking, your work shapes pricing strategy and business decisions — not just reporting after the fact.
• Variety. Solving pricing puzzles, investigating data discrepancies, and translating findings into action across multiple business functions.
• Excel is your playground. This role rewards advanced Excel skills — building, modeling, and collaborating at a level that goes well beyond most user's knowledge and ability.
• Ad-hoc analysis means chasing down root causes, cleaning up master data, and documenting solutions that stick.
• Cross-functional work. Partner with Estimating, Sales, Purchasing, and Production, giving you visibility into how data connects every part of the business.
• You'll help shape how the company's platforms and reporting processes grow and improve — not just maintain the status quo.

Compensation And Benefits

• Hourly Wage $25 - 32/Hr DOE
• Medical/Dental/Vision insurance and Health Savings Accounts (HSA's) with employer contributions $500 - $1,500 annually
• 401(K) options including profit-share eligibility after 1 calendar year of employment.
• 8 Paid Holidays
• 2-3 Weeks Paid Time Off
• Paid Bereavement Leave

More About Us

We are an equal opportunity employer and one of North America's leading manufacturers of quality residential and commercial interior wood doors. The great service and products we deliver are a result of the hard work and talent of our exceptional team. We work very hard to hire the best team members who share our core values in respect for all people, integrity in every situation, and quality in everything we do. A supportive team with diverse backgrounds and career experiences from all around the world strengthens who we are and provides many opportunities for continuous growth and development within our Company.

This job is Safety Sensitive and therefore is contingent upon a pre-employment drug test including marijuana. Additionally due to dealing with sensitive data and systems, a Criminal Background Check will be required for this role.