BOM Technician

Socket.dev; Miamisburg (OH); On-site; USD 55,000 - 85,000; Full time

Benefits offered by this job

Sign-on bonus

Referral bonus

Job summary

Socket.dev is seeking a BOM Technician to design, develop, and maintain manufacturing data systems that support Bills of Materials, routings, product structures, ECOs, and ERP/MRP processes.

The role focuses on ensuring accuracy, integrity, accessibility, and performance of manufacturing master data across the organization, partnering with Engineering, Manufacturing, and IT teams to optimize data quality and system performance.

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 BOMs, Routings, Item Master Data, Product Structures, Manufacturing Processes.
• Knowledge of MRP, capacity planning, and shop floor execution.

Responsibilities

• Maintain relational database structures supporting manufacturing and engineering operations.
• Create and optimize database schemas for multi-level BOMs, Routings, Work Centers, Item Master Data, Production Resources, 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.
• Develop and maintain systems supporting complex, multi-level BOM structures and automate validation processes.
• Support engineering and manufacturing teams with BOM creation, revisions, and change management.
• Design reporting and analysis tools to identify BOM discrepancies and inactive materials.
• Maintain version control and audit tracking for BOM changes.
• Develop ETL processes and data interfaces between engineering and manufacturing platforms.
• Ensure synchronization of BOMs, routings, and product master data across systems.

Skills

BOM expertise

SQL/DB skills

ERP systems

Routings & BOMs

MRP concepts

Education

Bachelor's degree in CS/IS/Engineering/Manufacturing

Tools

SQL Server

Oracle

PostgreSQL

Job description

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