BOM Technician in Miamisburg, Ohio at Hearth Products Control Company

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:

Sign-on bonus

Referral bonus