Senior Business Solutions Analyst
Summary:
The Senior Business Solutions Analyst – Supply Chain supports the Supply Chain team by turning supply, demand, and inventory data into actionable insights that improve planning accuracy, inventory performance, and decision-making. This role is responsible for analyzing inventory trends and E&O exposure, building and maintaining KPI dashboards that provide clear visibility to Planning, Procurement, Finance, and leadership, and ensuring MRP planning parameters are accurate, current, and aligned with business needs. The ideal candidate combines strong data analytics skills, hands-on Power BI and Excel capability, and practical supply chain knowledge to identify risks, recommend improvements, and support consistent, data-driven execution across the materials organization.
Responsibilities:
Act as a data and analytics resource for Supply Chain Planning and Procurement through collaboration with FP&A, Operations, and IT
Gather data, conduct analysis, and present solutions for product line segmentation/categorization, inventory analysis, supply and demand analysis, and procurement analysis
Investigate root causes of excess and obsolete build-up and recommend corrective parameter or process changes;
Support quarterly E&O review meetings with data-backed reporting and prioritized action lists
Support ad hoc analyses tied to new product introductions, supplier transitions, and product line rationalizations;
Leverage AI tools to improve speed and efficiency; develop and maintain Power BI business intelligence tools for inventory analysis, procurement analytics, and E&O exposure
Design and improve KPI visuals and Power Query data models
Keep dashboards accurate as source data, parameters, and business definitions evolve
Present findings and recommendations to leadership
Act as a primary gatekeeper for MRP parameter maintenance in Dynamics 365
Update core MRP parameters on monthly, quarterly, and annual cadences
Validate changes against historical usage, service-level targets, and supplier performance
Identify and correct data anomalies prior to the MRP run
Serve as a primary point of contact for ERP improvements to Procurement and Material Planning through sprint meetings with IT
Positional Requirements & Qualifications:
Education & Experience:
Bachelor’s degree in supply chain management or related field, or equivalent experience
2–5+ years of experience in supply chain planning, inventory analysis, or a business analyst role within a manufacturing or distribution environment
Advanced Excel skills
Hands-on experience building and maintaining Power BI dashboards and data models using Power Query
Working knowledge of MRP/ERP systems and core planning parameters including lead time, safety stock, reorder points, and lot sizing
Experience with SQL, Tableau, Python/R, and Microsoft Copilot or similar AI tools is a plus
demonstrated experience analyzing large, imperfect datasets and translating results into practical recommendations.
Skills & Abilities:
Proficiency in Power BI, including data modeling and Power Query transformations
Detail-oriented with strong process and documentation discipline
Strong analytical and data-cleansing skills
Ability to reconcile data across multiple systems and formats
Clear written and verbal communication, including presenting data-driven recommendations to non-technical stakeholders
Ability to manage recurring monthly deliverables while balancing ad hoc requests
Collaborative mindset with the ability to influence cross-functional partners without direct authority.
Essential Physical Functions
Lifting up to 25 pounds
Bending, stooping, ability to stand for extended periods of time
Must be able to travel and have a clear driving record in accordance to company driving guidelines
This job description is intended to describe the general nature and level of the work being performed. This is not an exhaustive list of all duties and responsibilities. The company reserves the right to amend and change responsibilities to meet business and organizational needs as necessary.