Master Data Management Anaylyst

Ideal Tridon•Auburn Hills, MI

About The Position

The Ideal Tridon Group comprises a family of brands that support, secure, and connect the movement of air, fluid, and electricity in critical applications. With over 100 years of proven quality and a strong culture of service, we are the worldwide leader in clamps, strut, hose supports, conduit, fittings, and coupling solutions. Our products are engineered to meet the highest standards across a range of industries, and our commitment to innovation, reliability, and customer support ensures we’re ready to meet the demands of today and tomorrow. At the Ideal Tridon Group, connections aren’t just what we make—they’re the heart of everything we do. Summary: The Macola Master Data Lead is responsible for owning, governing, and optimizing all material master data and bill of materials (BOMs) within the Macola ERP environment. This role ensures data accuracy, integrity, and alignment across production, planning, and supply chain functions. The Lead will support manufacturing operations by maintaining clean, reliable data that enables accurate MRP, inventory control, and efficient production execution.

Requirements

5+ years of experience in Master Data, Inventory Control, or BOM Management, preferably in a manufacturing environment.
Extensive hands‑on experience with Macola ERP (advanced proficiency).
Strong analytical skills with a data‑driven mindset.
Experience with MRP, replenishment, and raw material planning.
Proficiency in Microsoft Excel (VLOOKUP/XLOOKUP).
High attention to detail, accuracy, and process discipline.

Nice To Haves

Bachelor of Science Degree in Business, Supply Chain, Logistics or related area of study.
Experience in steel manufacturing or heavy industrial operations.
APICS/ASCM CPIM certification.
Knowledge of root‑cause analysis and corrective action methodologies.

Responsibilities

Manage and maintain all material master records in Macola to ensure accuracy of key fields (item attributes, costing, planning parameters, units of measure, routing/BOM linkages, etc.).
Establish and enforce data governance standards, validation rules, and change-control procedures.
Lead continuous data cleanup, classification, and standardization efforts to support system accuracy and performance.
Maintain and update Bills of Materials (BOMs) to ensure structural integrity and alignment with production requirements.
Audit BOMs for completeness, accuracy, and alignment with engineering and operational changes.
Collaborate with production, engineering, and planning to ensure BOM updates are properly reviewed and executed.
Serve as the subject matter expert (SME) for Macola system transactions, configuration related to master data, and inventory control functions.
Partner with IT and operations to troubleshoot Macola data issues and recommend system improvements.
Support enhancements, testing, and training associated with Macola data processes.
Partner with planning, production, logistics, procurement, and suppliers to ensure data accuracy supports operational performance.
Communicate data requirements, process changes, and data quality expectations.