ERP Analyst / Administrator – ETO/CTO, MRP/DRP, WMS, Supply Chain, Logistics & SQL; AS400 a +

KORE1; Los Angeles (CA); Hybrid; USD 80,000 - 130,000; Full time

Job summary

KORE1 is actively seeking an ERP Analyst / Administrator to support ETO/CTO, MRP/DRP, WMS, and SQL in a fiberglass door manufacturing environment. The role combines techno-functional ERP work with hands-on configuration, testing, and optimization on Friedman AS400 or comparable platforms.

The position offers a hybrid schedule—onsite Monday through Thursday and remote Friday—along with a full-time direct-hire arrangement and a compensation range of $80,000 to $130,000 per year.

Qualifications

• 6+ years of techno-functional ERP experience.
• Experience with manufacturing-focused ERP systems.
• Knowledge of ETO/CTO processes, BOMs, MRP/DRP.
• Strong SQL for reporting and data analysis.
• Bachelor's degree in IS/CS/Engineering/Supply Chain or equivalent.
• Experience in ERP implementation, UAT, deployment, and post-implementation support.

Responsibilities

• Analyze and improve ETO/CTO workflows and manufacturing readiness.
• Support BOMs, routings, work orders, MRP/DRP, and inventory.
• Improve warehouse and logistics workflows.
• Gather requirements and translate needs into ERP configurations.
• Perform hands-on ERP configuration, testing, and documentation.
• Develop SQL queries, reports, KPIs, and data validation.
• Design integrations using APIs, EDI, and file-based interfaces.
• Participate in small-to-medium ERP implementations.

Skills

Techno-functional ERP experience

SQL proficiency

Manufacturing ERP configuration

ETO/CTO processes knowledge

Education

Bachelor's degree in Information Systems/CS/Engineering/Supply Chain or equivalent

Tools

Friedman ERP (IBM AS400)

Infor/SAP/Oracle

Job description

ERP Analyst / Administrator – ETO/CTO, MRP/DRP, WMS, Supply Chain, Logistics & SQL; AS400 a +

Work Arrangement: Hybrid – Onsite Monday through Thursday; Remote Friday

Employment Type: Full-Time, Direct Hire

Compensation: $80,000–$130,000 annually

Bonus: Discretionary, not guaranteed; generally considered beginning in the second year of employment

Workplace Attire: Business attire required on most onsite days; casual Thursdays.

KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a ERP Analyst / Administrator – ETO/CTO, MRP/DRP, WMS, Supply Chain, Logistics & SQL; AS400 a +

We are seeking an experienced, hands‑on ERP Systems Analyst to support the modernization, configuration, implementation, and ongoing optimization of enterprise resource planning systems for a manufacturing organization specializing in fiberglass doors.

This techno‑functional position supports manufacturing operations, product configuration, production planning, supply chain, warehousing, logistics, and distribution. The ideal candidate combines strong manufacturing business‑process knowledge with technical ERP configuration, SQL, integrations, testing, and implementation experience.

The organization currently utilizes Friedman ERP on an IBM AS400 platform, with a graphical front end and legacy AS400 back end. Experience with Friedman or AS400‑based ERP systems is highly desirable; however, candidates with strong hands‑on experience implementing and configuring comparable manufacturing ERP platforms, including Infor or SAP, will also be considered.

The position will play an important role in ongoing ERP modernization initiatives, including activating underutilized functionality, improving system configurations, streamlining workflows, and supporting small‑to‑medium‑scale implementation projects.

Key Responsibilities

• Analyze and improve Engineer-to-Order (ETO) and Configure-to-Order (CTO) workflows, product configuration, product rules, and manufacturing readiness.
• Support bills of materials (BOMs), routings, work orders, MRP/DRP, production planning, inventory management, and shop‑floor transactions.
• Improve warehouse receiving, inventory control, picking, staging, transfers, cycle counts, shipping, dispatch, and logistics workflows.
• Gather business requirements, map existing processes, identify gaps, and translate operational needs into ERP configurations and functional specifications.
• Perform hands‑on ERP configuration, testing, documentation, troubleshooting, and ongoing system enhancements across manufacturing, planning, warehousing, and distribution.
• Support the implementation and optimization of previously unused, underutilized, or incompletely configured ERP modules and functionality.
• Create and improve SQL queries, reports, dashboards, operational KPIs, and data validation routines.
• Design, implement, troubleshoot, and improve integrations and automation using APIs, EDI, file‑based interfaces, and workflows.
• Develop or support custom reports, interfaces, scripts, data utilities, and ERP enhancements.
• Participate in small‑to‑medium‑scale ERP implementation and modernization projects, including requirements gathering, configuration, testing, deployment, and stabilization.
• Develop test plans and user acceptance testing (UAT) scripts; coordinate testing, defect resolution, and validation with business stakeholders.
• Partner with manufacturing, production planning, supply chain, warehouse, logistics, and other business teams to identify system improvements and resolve operational issues.
• Coordinate with ERP vendors and other technical resources to troubleshoot issues, implement enhancements, and improve system functionality.
• Identify opportunities to improve operational efficiency, automation, system scalability, and business‑process consistency.
• Support end‑user training, system documentation, production issue resolution, and post‑implementation support.

Required Qualifications

• 6+ years of techno‑functional ERP experience, with substantial hands‑on involvement in manufacturing ERP configuration, implementation, enhancement, and support.
• Experience with manufacturing‑focused ERP systems, including direct responsibility for configuring functionality, implementing changes, and troubleshooting technical or functional issues.
• Experience with Engineer-to-Order (ETO) and/or Configure-to-Order (CTO) processes, product configuration, BOMs, routings, work orders, MRP/DRP, production planning, and inventory transactions.
• Strong understanding of manufacturing operations and the relationships between product configuration, materials, production, inventory, warehousing, and distribution.
• Knowledge of warehouse operations, inventory management, shipping, logistics, dispatch, and order fulfillment.
• Strong SQL proficiency for reporting, data analysis, validation, troubleshooting, and supporting ERP enhancements.
• Experience gathering business requirements, documenting processes, preparing functional specifications, configuring ERP solutions, and testing system changes.
• Direct participation in ERP implementation, enhancement, or modernization projects, including configuration, UAT, deployment, and post‑implementation support.
• Ability to translate manufacturing and operational requirements into practical, scalable ERP solutions.
• Strong analytical, problem‑solving, troubleshooting, and documentation skills.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with business users, technical resources, and external vendors.
• Bachelor's degree in Information Systems, Computer Science, Engineering, Supply Chain, Business, or a related field, or equivalent practical experience.

Preferred Qualifications

• Friedman ERP experience, particularly within manufacturing, product configuration, production planning, or distribution environments.
• IBM AS400 (IBM i) experience, including Friedman or other AS400‑based ERP platforms.
• Experience with Infor, SAP, Oracle, or other comparable manufacturing ERP systems.
• Experience configuring or implementing ERP functionality for discrete manufacturing, particularly Engineer-to-Order or Configure-to-Order production environments.
• Experience supporting ERP integrations using APIs, EDI, file‑based interfaces, or other integration technologies.
• Experience with ERP data conversions, master data management, reporting enhancements, and workflow automation.
• Additional programming or scripting experience with RPG, C#, .NET, PowerShell, Python, or comparable technologies.
• Experience working directly with ERP vendors on configurations, enhancements, troubleshooting, or implementation projects.
• Experience identifying and implementing automation, process optimization, or system scalability improvements.