Office Manager

JM Eagle • Los Angeles, CA

1d • $77,000 - $129,000

About The Position

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. The successful candidate will manage two deeply integrated layers: the Logic Layer (the rules) and the Execution Layer (Master Data), ensuring a seamless flow from the initial sales quote to shop-floor completion.

Requirements

• Experience: 5+ years in manufacturing systems with a concentrated focus on product structures, including multi-level Bills of Materials (BOMs) and Routings.
• Technical Expertise: Strong experience with the CIS Configurator (or similar rules-based CPQ software) and SAP Business One is highly preferred.
• Domain Knowledge: Solid understanding of discrete manufacturing logic and the functional impact of configuration on production scheduling (APS), material planning (MRP), and shop-floor execution (MES).
• Technical Skills: Proficiency in SQL for data modeling and troubleshooting. Advanced Excel skills for auditing system schedules and performing margin analysis.
• Communication: Ability to act as a functional link with effective communication skills to bridge HQ Sales, Engineering, and Shop-Floor operations.
• Precision: Because errors in the "Logic Layer" propagate instantly to the shop floor and procurement, a "zero-error" mindset regarding data entry is required.
• Cross-Functional Bridge: The candidate must be able to communicate effectively across: Sales (pricing/options), Engineering (BOMs/specs), and Operations (scheduling/picking).
• Systemic Ownership: The ability to see how a single checkbox in the CIS Configurator impacts the financial margin in SAP B1 and the physical pick-path in the Ohio warehouse.

Nice To Haves

• Experience with EDI, API-based integrations, or middleware connecting ERP and MES systems is preferred.

Responsibilities

• New Product Configuration & Model Development Directly translate manufacturing requirements and sales/pricing rules into technical system logic within the CIS Configurator for a diverse catalog of SKUs: Complex Model Building: Develop and maintain configuration models for various product lines and new product introductions. Dimensional & Handing 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.
• Master Data & Execution Integrity Maintain the "Single Source of Truth" within SAP Business One to support downstream production and procurement: Item Master Management: Oversee Raw Materials (ingredients), Semi-Finished Goods (Work-in-Progress), and Configured Finished Goods, ensuring consistent Units of Measure (UoM) across departments and systems (CIS, SAP Business One and LYNQ). Configurable BOMs: Build and maintain multi-level Bills of Materials (BOM’s), 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. The Analyst will own the detailed scheduling rules and constraints required to drive accurate LYNQ APS scheduling and delivery dates. MRP Readiness: Ensure that BOM structures and lead times are accurately maintained to support automated Material Requirements Planning (MRP) runs and procurement signals. WMS Integration: Verify that configuration outputs correctly trigger WiSys WMS bin logic and picking instructions.
• Analytical Insights & Optimization Legacy Knowledge Extraction: Actively 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 the ERP (SAP B1) and MES (LYNQ) systems. SOP Development: Create and maintain Standard Operating Procedures (SOPs) for configuration rules to ensure standardized processes across all product lines

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 251-500 employees