BOM Technician - Bill of Materials (BOM) & Manufacturing Data Systems Position Summary We are seeking a BOM Technician to design, develop, maintain, and optimize manufacturing data systems that support Bill of Materials (BOMs), Routings, Product Structures, Engineering Change Management, and ERP/MRP processes . This role will serve as a key technical resource responsible for ensuring the accuracy, integrity, accessibility, and performance of manufacturing master data across the organization. The ideal candidate will possess strong BOM expertise combined with a deep understanding of manufacturing operations, product lifecycle management (PLM), ERP systems, and production processes. Key Responsibilities Database Administration Maintain relational database structures supporting manufacturing and engineering operations. Create and optimize database schemas for: Multi-level Bills of Materials (BOMs) Manufacturing Routings Work Centers Item Master Data Production Resources Engineering Change Orders (ECOs) Costing and Product Configurations Develop and maintain data governance standards for manufacturing master data. Monitor database performance and implement tuning strategies to improve efficiency and scalability. Ensure database availability, security, backup, and disaster recovery capabilities. Bill of Materials (BOM) Management Develop and maintain systems supporting complex, multi-level BOM structures. Create automated validation processes for BOM accuracy and completeness. Support engineering and manufacturing teams with BOM creation, revisions, and change management activities. Design reporting and analysis tools to identify BOM discrepancies, duplicate components, and inactive materials. Maintain version control and audit tracking for BOM changes. Routing & Manufacturing Process Data Develop and support routing data structures that define manufacturing operations and workflows. Maintain work center, labor, machine, and operation data utilized within ERP and MES systems. Partner with manufacturing engineering teams to optimize routing accuracy and production planning. Support capacity planning, scheduling, and production reporting through reliable routing data management. ERP & System Integration Integrate database solutions with ERP, MES, PLM, and other manufacturing systems. Develop ETL processes and data interfaces between engineering and manufacturing platforms. Ensure synchronization of BOMs, routings, and product master data across multiple systems. Support migrations, upgrades, and system implementations involving manufacturing data. Data Quality & Analytics Establish and maintain processes to ensure data integrity and consistency. Develop dashboards, reports, and KPIs related to: BOM Accuracy Routing Accuracy Engineering Change Activity Material Usage Manufacturing Performance Perform root-cause analysis for data issues impacting production, planning, procurement, or inventory. Collaboration & Continuous Improvement Work closely with Engineering, Manufacturing, Supply Chain, Production Planning, and IT teams. Participate in ERP optimization initiatives and manufacturing transformation projects. Recommend improvements to data architecture, processes, and system performance. Document database structures, standards, and procedures. Required Qualifications Bachelor's degree in Computer Science, Information Systems, Engineering, Manufacturing Systems, or related field. 3+ years of BOM experience, database administration, or manufacturing systems experience. Knowledge of SQL Server, Oracle, PostgreSQL, or similar relational database platforms. Understand SQL development and performance tuning skills. Experience supporting manufacturing ERP systems.

Experience working with:

Bills of Materials (BOMs) Routings Item Master Data Product Structures Manufacturing Processes Knowledge of manufacturing planning concepts including MRP, capacity planning, and shop floor execution.

Benefits:

Medical, dental, vision, 401k, company paid life insurance, 8 paid holidays Sign-on bonus $2500 Referral bonus $500