Formula & Master Data Manager

Summary: 

The Formula & Master Data Manager serves as the primary point of contact for all customer-owned formula, Bill of Materials (BOM), and batch sheet data. This newly created role is responsible for developing, standardizing, centralizing, and maintaining end-to-end processes that ensure accurate, approved, and production-ready manufacturing documentation across all Carolina Beverage Group facilities.

 This position partners closely with customers, plant operations, quality, procurement, and planning teams to ensure product data integrity, regulatory compliance, and on-time execution of new and existing products.

This position can be located at any of our three locations: Mooresville, NC, Fort Worth, TX or Cold Spring MN. 

Essential Duties and Responsibilities:  include the following. Other duties may be assigned.

Customer & Product Data Ownership

• Act as the primary customer point of contact for all BOM, formula, and batch sheet data.
• Will establish and maintain relationships with key data management teams from each customer to ensure that the information provided is accurate from customer’s ERP systems. 
• Ensure that all required data is provided by the customer or process owner before set up.
• Ensure that the date for the implementation is accurate and if it is a soft or hard change there is an adequate plan for production.
• Maintain expert knowledge of CBG-sourced ingredients and materials versus customer-owned materials, including ownership, responsibility, and documentation requirements.
• Attend customer meetings to review formulations, approvals, timelines, and process changes as needed.

BOM, Formula & Batch Sheet Management

• Own the creation, revision, and lifecycle management of batch sheets across all production sites.
• This person will receive and review all incoming new formulas as well as updates to existing formulas and will create versioned batch sheets for each facility according to plant-specific capabilities for production.
• Will manage the implementation of the new formulas to ensure proper approval, timeliness and accuracy.
• Standardize batch sheet formats, processes, and controls across all facilities.
• Develop and maintain a second-check verification process requiring plant review and validation of batch sheets prior to production.
• Ensure all batch sheets and BOMs meet internal quality, food safety, and customer requirements before release.

Approval & Automation Processes

• Develop, automate, and monitor batch sheet approval workflows for customers.
• Develop, automate, and monitor BOM approval workflows for customers.
• Track approval status and proactively resolve delays or discrepancies impacting production readiness.

New Finished Good (FG) & Production Readiness

• Develop and manage the Inbound New Finished Good (FG) process, including data intake, validation, and system setup.
• Maintain a strong understanding of production line capabilities, setup lead times, and sequencing requirements for new and existing products.
• Partner with operations and planning teams to ensure accurate timelines for product launches and production runs.

SAP & Systems Support

• Manage SAP portal requests related to BOMs, formulas, batch sheets, and product setup.
• Address urgent SAP requests impacting production or customer commitments.
• Ensure system data accuracy and alignment with approved documentation.
• Work with operations to establish and enforce (as possible) CBG standards as related to coding, labeling, pallet patterns, shrink and stretch utilization etc. 

 Documentation & Continuous Improvement

• Write, maintain, and update Standard Operating Procedures (SOPs) related to product data management, approvals, and batch sheet controls.
• Identify process gaps and recommend improvements to enhance efficiency, accuracy, and compliance.
• Design and maintain metrics/KPI’s to track performance and progress
• Support internal audits, customer audits, and regulatory inspections as needed.

Other Duties and Responsibilities:

Required Qualifications

• Bachelor’s degree in Supply Chain, Operations, Food Science, Engineering, Business, or a related field; or equivalent combination of education and experience.
• Minimum 3–5 years of experience in manufacturing operations, product data management, formulation, or related roles.
• Demonstrated experience with BOMs, batch sheets, formulas, and production documentation in a manufacturing environment.
• Working knowledge of ERP systems, preferably SAP.
• Strong understanding of manufacturing processes, production scheduling, and change control.
• Ability to communicate effectively with customers, plant teams, and cross-functional stakeholders.

Preferred Qualifications

• Experience in beverage, food or consumer packaged goods manufacturing
• Experience in standardizing processes across multiple manufacturing sites
• Familiarity with quality systems, food safety programs and documentation controls. 

Key Competencies:

• High attention to detail and data accuracy
• Strong project and process management skills
• Customer focused mindset
• Ability to manage competing priorities and urgent requests
• Clear written and verbal communication skills
• Must be a moderate to advance used in Excel, Word and Microsoft Teams