SMS Analyst

Morsco; Dallas (TX); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Medical and Dental Insurance

401(k) Plan

Paid Time Off

Job summary

Reece & Fortiline seeks an analytical SMS Analyst to optimize inventory management and purchasing decisions. Based at the Regional Support Center, you will partner with Branch Operations, Purchasing, Category Management, and Supply Chain to improve product availability and data-driven performance.

You will develop dashboards, maintain data integrity, and drive process improvements across ERP systems to support inventory excellence.

Qualifications

• Bachelor's degree in Supply Chain Management or related field.
• Experience in inventory planning, replenishment, or supply chain analytics (2–4 years).
• Proficiency in Excel and BI tools (Power BI) for reporting.

Responsibilities

• Analyze inventory, sales, and demand data to improve product availability and service levels.
• Maintain and optimize replenishment settings including reorder points and safety stock.
• Develop Power BI dashboards and reports for leadership and stakeholders.
• Collaborate with Branch Operations, Purchasing, and Distribution teams on inventory strategies.

Skills

Inventory Planning

Replenishment

Forecasting

Power BI

Advanced Excel

ERP Systems

Data Analysis

Cross-Functional Collaboration

Education

Bachelor's degree in Supply Chain Management

Tools

Solar Eclipse/e-Term Eclipse ERP

SQL

Job description

Who We AreWorking at Reece & Fortiline means being part of a growing global company that brings our purpose and values to life every day. We celebrate our team members living our values and provide opportunities to build a long and remarkable career. We’re proud to support essential industries helping bring clean air and water to everyone. To learn more about our purpose and values, visit our career site at https://careers.reece.com/us/PurposeWe are seeking an analytical professional who excels at solving inventory and purchasing challenges through data analysis, process improvement, and cross-functional collaboration. Based at the Regional Support Center, the SMS Analyst partners with Branch Operations, Purchasing, Category Management, and Supply Chain to optimize inventory performance, improve product availability, and support data-driven decisions. This role analyzes inventory and purchasing data, develops reporting and insights, and recommends strategies that enhance service levels, inventory investment, and operational performance. The ideal candidate is detail-oriented, collaborative, and passionate about using data to solve business problems.Key ResponsibilitiesInventory Analysis & ReplenishmentAnalyze inventory, sales, and demand data to identify risks and opportunities, and recommend actions to improve product availability, inventory investment, and service levels.Maintain and optimize inventory and replenishment settings, including reorder points, safety stock, forecasting parameters, inventory targets, and buy packs.Monitor inventory performance, including ABC Service Level, Days On Hand, and replenishment effectiveness, and recommend corrective actions.Support inventory optimization initiatives, including new product introductions, product transitions, discontinued items, inventory rationalization, and branch inventory balancing.Data Analysis & ReportingDevelop and maintain Power BI dashboards, reports, and performance metrics to support inventory and purchasing decisions.Present inventory performance, trends, KPIs, and actionable recommendations to leadership and business stakeholders.Support data-driven decision making through reporting and business analytics.Inventory Data Integrity & Process ImprovementMaintain inventory master data integrity and identify root causes of inventory, replenishment, and ERP data issues.Improve inventory processes, replenishment automation, reporting, and system efficiency through continuous improvement initiatives.Coordinate inventory redistribution, vendor return programs, and excess inventory reduction activities across the branch network.Stakeholder Engagement & DevelopmentPartner with Branch Operations, Purchasing, Category Management, and Distribution teams to support inventory strategies and improve service levels.Provide inventory planning guidance and recommendations to branch personnel, including replenishment, inventory transfers, and inventory best practices.Train and support branch inventory contacts and operational teams on inventory management processes and tools.Key Competencies and Skills RequiredInventory Planning, Replenishment & OptimizationInventory Analysis & Demand ForecastingERP Systems & Inventory Master Data ManagementAdvanced Excel, Power BI & Business AnalyticsReporting, Dashboard Development & KPI AnalysisProcess Improvement & Root Cause AnalysisCommunication & Cross-Functional CollaborationCustomer Service & Stakeholder ManagementProblem Solving, Organization & Time ManagementSuccess MeasuresAchieve inventory service level, ABC performance, and Days on Hand targets.Improve inventory accuracy, data integrity, and replenishment effectiveness.Reduce excess, slow-moving, obsolete, and stockout inventory through inventory optimization initiatives.Minimum QualificationsBachelor's degree in Supply Chain Management, Business Administration, Operations Management, Logistics, Data Analytics, or a related field.2–4 years of experience in inventory planning, purchasing, replenishment, demand planning, supply chain analytics, or a related analytical role.Advanced proficiency in Microsoft Excel and experience developing reports and dashboards using Power BI or similar business intelligence tools.Experience working with ERP and inventory management systems; familiarity with Solar Eclipse/e-Term Eclipse or similar ERP platforms.Demonstrated ability to analyze inventory and operational data to support business decisions and process improvements.Ability to manage multiple priorities in a fast-paced, collaborative environment.Preferred QualificationsExperience supporting inventory planning and replenishment across multiple branch locations.Experience working with branch operations to improve inventory performance, service levels, and inventory investment.Experience in wholesale distribution (plumbing, HVAC, electrical, industrial, kitchen & bath, appliance, or similar industries).Experience with inventory optimization, inventory redistribution, vendor return programs, and service-level management.Working knowledge of SQL or other data analytics tools.Experience with Solar Eclipse/e-Term Eclipse ERP.Our commitment to excellent customer service is just part of our story. We’re also dedicated to supporting our most valuable asset, our associates! One of the ways we do this is by offering a variety of high-quality benefits for our associates and their families.All full-time associates are eligible for the following benefits:Medical and Dental InsuranceFlexible Spending Accounts and Health Savings AccountsCompany-paid Life InsuranceShort Term Disability401(k) PlanPaid Time Off (PTO) - plus paid holidaysParental LeaveVoluntary benefits:VisionLong-term DisabilityVoluntary Life and AD&D InsuranceAdditional Voluntary Benefits through CorestreamWe're an equal opportunity employer and we welcome diversity and inclusion! Reece USA is an Equal Opportunity Employer— Employer Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, and any other status protected by law.