BOM Technician

Hpc-Fire-Inspired; Miamisburg (OH); On-site; USD 55,000 - 60,000; Full time

Job summary

Hpc-Fire-Inspired in Ohio is seeking a BOM Technician to design, maintain, and optimize manufacturing master data across BOMs, routings, product structures, ECOs, and ERP/MRP processes. The role focuses on data accuracy, integrity, and performance to support production planning and engineering change management.

The ideal candidate has strong BOM expertise, hands-on database experience, and familiarity with ERP/MES systems, PLM, and analytics to drive data quality and manufacturing efficiency.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Manufacturing Systems, or related field.

Responsibilities

• Maintain relational database structures supporting manufacturing and engineering operations.

Skills

BOM experience

Database administration

Manufacturing systems experience

SQL development

Performance tuning

ERP systems experience

MRP knowledge

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Manufacturing Systems, or related field

Tools

SQL Server

Oracle

PostgreSQL

Job description

Salary Range: $55,000.00 To $60,000.00 Annually

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.
• 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.
• Medical, dental, vision, 401k, company paid life insurance, 8 paid holidays