Senior Business Solutions Analyst

Vytl-Controls-Group; Houston (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Vytl-Controls-Group in Houston seeks a Senior Business Solutions Analyst – Supply Chain to turn supply, demand, and inventory data into actionable insights that improve planning accuracy, inventory performance, and leadership decision-making. The role focuses on building and maintaining KPI dashboards in Power BI and Excel, analyzing E&O exposure, and ensuring MRP parameters are accurate.

You will collaborate with Planning, Procurement, Finance, and IT to deliver data-driven recommendations and

Qualifications

• Bachelor’s degree in supply chain management or related field
• 2–5+ years of experience in supply chain planning, inventory analysis, or a business analyst role in manufacturing or distribution
• 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

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

Skills

Power BI

Advanced Excel

Data analytics

MRP/ERP knowledge

Cross-functional collaboration

Power Query

Data storytelling

SQL experience

Education

Bachelor’s degree in supply chain management or related field

Tools

Power Query

SQL

Tableau

Python/R

Copilot/AI tools

Job description

Posted Monday, August 10, 2026 at 6:00 AM

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.