MIS Product Configurator and Data Analyst

Position Summary We are seeking a detail‑oriented MIS Product Configurator and Data Analyst to serve as the lead architect of our sales and production logic. As we transition from legacy systems to a modern integrated stack (SAP Business One, CIS Configurator, LYNQ MES, and WiSys WMS from AS/400 Friedman), this role is essential to ensuring that complex entry door configurations are accurately translated into system logic. Key Responsibilities New Product Configuration & Model Development Complex Model Building: develop and maintain configuration models for various product lines and new product introductions. Dimensional & Handling Logic: create and maintain rules for standard vs. custom specifications and automated calculations. Component Compatibility: build dependency rules for glass inserts, hardware mapping, and hole alignments based on door thickness. Pricing & Margin Rules: program “If/Then” logic for material adders, finish types (smooth vs. woodgrain), and hardware upgrades, integrating customer‑specific pricing tiers from SAP B1. System Validation: lead User Acceptance Testing (UAT) for configuration modules to ensure “Order‑to‑Cash” integrity and error‑free ordering. Item Master Management: oversee Raw Materials, Semi‑Finished Goods, and Configured Finished Goods, ensuring consistent Units of Measure across departments and systems (CIS, SAP Business One, and LYNQ). Configurable BOMs: build and maintain multi‑level Bills of Materials, utilizing “Phantom BOMs” for common assemblies to streamline processing. Routing & Work Centers: define precise operation sequences (CNC, Glass Insertion, Painting) and maintain standard setup/run times; own detailed scheduling rules and constraints for LYNQ APS scheduling and delivery dates. MRP Readiness: ensure BOM structures and lead times are accurately maintained to support automated Material Requirements Planning runs and procurement signals. WMS Integration: verify that configuration outputs correctly trigger WiSys WMS bin logic and picking instructions. Legacy Knowledge Extraction: collaborate with internal legacy experts to extract and document “tribal knowledge” from the AS/400 Friedman system, translating manual workarounds into standardized SAP B1/CIS logic. Root‑Cause Analysis: investigate and resolve data gaps, routing discrepancies, or order errors originating from system configurations. SQL Data Modeling: apply proficiency in SQL for advanced data modeling, complex querying, and technical troubleshooting across integrated platforms. Margin Validation & Audit: utilize Excel to perform margin validation and audit the accuracy of system‑generated schedules against actual plant performance. System Integration: monitor and support EDI, API‑based integrations, or middleware connecting ERP (SAP B1) and MES (LYNQ) systems. SOP Development: create and maintain Standard Operating Procedures for configuration rules to ensure standardized processes across all product lines. Analytical Insights & Optimization: analyse system data to identify opportunities for process improvement and cost savings. Qualifications 5+ years in manufacturing systems with a concentrated focus on product structures, including multi‑level BOMs and routings. Strong experience with the CIS Configurator (or similar rules‑based CPQ software) and SAP Business One. Solid understanding of discrete manufacturing logic and the functional impact of configuration on production scheduling (APS), material planning (MRP), and shop‑floor execution (MES). Proficiency in SQL for data modeling and troubleshooting. Advanced Excel skills for auditing system schedules and performing margin analysis. Experience with EDI, API‑based integrations, or middleware connecting ERP and MES systems. Excellent communication skills to act as a functional link between HQ Sales, Engineering, and Shop‑Floor operations. Critical Success Factors Precision: a zero‑error mindset regarding data entry in the “Logic Layer” to prevent cascading shop‑floor and procurement issues. Cross‑Functional Bridge: effective communication across Sales (pricing/options), Engineering (BOMs/specs), and Operations (scheduling/picking). Systemic Ownership: understanding how a single checkbox in the CIS Configurator affects financial margin in SAP B1 and the physical pick‑path in the Ohio warehouse. #J-18808-Ljbffr