Business Analyst

• Analyze the effects of inflation on manufacturing costs and pricing structures to identify trends and opportunities
• Collaborate with procurement teams to assess cost drivers such as minimum wage increases and material expenses
• Collect, structure, and evaluate data from hundreds of customers to align bills of materials with pricing models
• Estimate the financial impact of inflation on purchased components for individual customer accounts
• Quantify and document inflation recovery potential to support the commercial team in updating pricing strategies
• Develop and validate price lists using Excel, ensuring accuracy and usability for sales and commercial teams
• Create transparent cost recovery methodologies to ensure fair pricing adjustments for customers
• Regularly review bills of materials and cost structures to ensure alignment with changing input factors, such as labor and materials
• Analyze foreign exchange fluctuations and their influence on material and labor costs
• Utilize advanced Excel skills to build pricing models, automate data analysis, and synthesize complex datasets

• Strong analytical skills with proven ability to solve data-driven problems effectively
• At least 2 years of experience in pricing, business analysis, or finance within a manufacturing setting
• Solid understanding of cost accounting principles and manufacturing cost allocation practices
• Hands-on experience with bills of materials and component-level pricing analysis
• Advanced proficiency in Excel, including pivot tables, vlookups, macros, and formulas (testing may be required)
• Ability to work fully onsite in Southfield, Michigan
• Excellent communication skills to present analytical findings to business stakeholders

Familiarity with foreign exchange impacts and commodity pricing trends such as copper

• medical, vision, dental, and life and disability insurance
• eligible to enroll in our company 401(k) plan