Microsoft-excel Careers in lawrenceburg ∙ Page 1

Campari Group today is a major player in the global branded spirits industry, with a portfolio of over 50 premium and super premium brands, marketed and distributed in over 190 markets around the world, with leading positions in Europe and the Americas.

Headquartered in Milan, Italy, Campari Group owns 22 plants worldwide and has its own distribution network in 22 countries, and employs approximately 4,000 people.

Shares of the parent company Davide Campari - Milano N.V. are listed on the Italian Stock Exchange since 2001. Campari Group is today the sixth-largest player worldwide in the premium spirits industry.

General Description of the Role 

Responsible for coordinating the liquid fulfillment and transportation needs from the Warehousing dept. to internal and external customers (Packaging dept., Campari facilities, third parties). This role manages tank availability for holding liquid and conveys information through the production schedule as tank allocation and usage. Bulk transfer coordinator organizes and administers all Warehouse TTB required documentation. 

Mission/Objectives 

The Bulk Transfer Coordinator will coordinate the liquid fulfillment and transportation needs, convey planning initiatives and administer legal paperwork to help drive an efficient operation  

Key Responsibilities and Activities 

• Compile liquid needs and distribute Production Schedule, a minimum of one month in advance for dump needs based on shipping needs for Bulk, Customer Barrels, Single Barrel and Samples.  

• Receive orders from Export and Third-Party Customers. Schedule minimum of one month in advance in US, six weeks minimum for exports depending on requested ETA. 

• Maintain Communication with Export Carriers, Customer Service and Trucking Companies for load out dates, Vessel Bookings and arrivals. 

• Track POs, OAs. Containers, Weights, ETA, PGS, OLA, Cost, AUD, Taxes, TTB Form Requirements and POEs in 2 different excel sheets. Track bulk of information for Campari Australia and Global Logistics Manager. Track Taxable amounts for Finance in a separate document. 

• Create Sales Orders in SAP for Third Party Sales of new distillate or sales of Wild Turkey Product. 

• Transfer ownership of product in DRAMS operating system. 

• Provide Inventory of Third-Party inventory as requested by Customer Managers and Planners. 

• Prepare all paperwork needed for tanker and single barrel shipments, i.e., bill of lading, transfer in bond, Application for Transfer of Spirits for domestic shipments for export shipments BOL, Withdrawal of Spirits TTB documents, Commercial Invoice, NAFTA, Quarantine Declaration for export shipments.  

• Coordinate internal and external shipments.  

• Distribute and administer legal documentation. Convey necessary information to internal and external parties. 

• Coordinate logistics and documentation with Operators and Operations Supervisors  

• Monitor and Cistern Room Fillings and make live in Drams daily. 

• Log all Distillate Tanks in Cistern Room created through PCI and sent to Drams with Monthly Log per day. Enter these tanks into SAP with a Goods Issue. 

• Make all Parcels Live and Dip tanks all day to keep system moving. 

• Monitor Daily automated Cistern Room HMI RFID Data Report, save and print for filling with Daily Tanks. 

• Log all Barrels not scanned to Trailers for research evidence of possible ghost barrel creation 

• Administer all required TTB documentation  

• Assist Manager and Supervisors with Drams Error System Issues. If unable to resolve send to Trapeze for Assistance. If it is a PCI specific issue Send to Josh Bryant. 

• Create new information or Maintenance in Drams as needed such as SKUs, Carriers, Locations. 

• Sign off on Certificates of Analysis for Bulk and Finished Goods for Chemist as site Notary. 

• Provide backup Power of Attorney Signature for Export Finished Goods Withdrawal of Spirits for Compliance and Analysis Accountant. 

• Provide Single Barrel Pulls for Eddie and Bruce Russell to Warehouse A as needed for on-site tasting sales. 

• Manage Master Single Barrel Location Tracking Log and Private Barrel Team Site with yearly Private Barrel Sales Log. 

• Create Pulls for Single Barrels as Private Label and Marketplace. 

• Coordinate with Warehouse Manager, Marketing and Eddie Russell on Single Barrel and Private Barrel planning 

• Manage single barrel spreadsheet and documentation 

• Daily Communication with the Marketing Coordinator for Private Labels Sales, shipments or potential problems. 

• Lead a Meeting 2 – 3 times per year with all Departments involved with Sales, Orders, Customer Service and Planning (more than 3 meetings held per year.) 

• Assist Finance with end of the month closing of Warehouse Dept. portion in DRAMS. 

• Work with Finance and Packaging leading up to the End of the Month to correct any PG or Cost Errors in DRAMs and SAP. Cancellations or Reversals in SAP or entering liquid back in tanks in Drams to correct shipment or inventory.  

• Every Quarter log Proof Gallon information on an Affidavit for the Tank Room and Cistern Room. 

• Sign as Power of Attorney of the Warehouse Dept. for TTB Affidavit Submission. The Tank Room Operator signs for Tank Room, Dump Room Supervisor Signs for Drums in the Dump Room and the Cistern Room Supervisor signs for the Distillate.  

• Work with TTB Compliance Analyst to ensure all legal documentation is properly administered and filed 

Key Relationships 

Internal:  

• Packaging Team 

• Marketing Team 

• Quality Department 

• Warehousing Operations 

• Accounting/Finance 

External:   

• Third Party Customers 

• Transportation Companies 

• External Campari facilities and departments 

Managerial  

QUALIFICATIONS/REQUIREMENTS: 

1. Education 

• Bachelor’s degree is preferred or relevant experience 

2. Experience 

• A minimum of 1-3 years of experience in logistics 

• A minimum of 1-3 years of experience with operating systems  

• Experience with SAP and Microsoft Excel is preferred.  

• Experience in inventory management, material handling and transportation systems is preferred. 

• Experience in the spirits industry is a plus. 

3. Knowledge/Skills/Abilities 

• Working knowledge of inventory management  

• Proven ability to multi-task and problem-solve in a fast-paced manufacturing environment 

• Working knowledge of operating systems such as SAP 

• Collaborative work ethic, especially across department lines at all levels in plant operations – influencing effectively with management as well as line staff 

• Strong attention to detail and customer service orientation 

• Proficiency in SAP and Microsoft Office 

• Working knowledge of TTB regulations, ISO requirements and Food Safety processes a plus 

Our commitment to Diversity & Inclusion:

At Campari Group we believe in building more value together, thus we see diversity in all forms as a source of enrichment. Our employment policies and practices ensure that we are committed to providing equal employment opportunities in all aspects of employment without regard to any individual’s race, religion, creed, color, national origin, ancestry, physical disability, mental disability, medical condition, genetic information, marital status, sex, sexual orientation, gender identity or characteristics or expression, political affiliation or activity, age, veteran status, citizenship, or any other characteristic protected by law.

Note to applicants:

Your application will be assessed based on your abilities, expertise, general knowledge and experience, not because of any confidential, proprietary or trade secret information you may possess. You must not disclose to Campari Group any such information. In the event that you are asked a question that cannot be answered without disclosure of any confidential, proprietary or trade secret information (including from a current or prior employer or their vendors or customers), you must decline to answer the question.

Notice to third party agencies:

Please refrain from cold-calling or emailing our executive leadership team or the HR community directly. The Talent Acquisition department manages centralized recruiting operations globally, including the selection and management of external suppliers. Currently, our preferred supplier list is at full capacity. To ensure we have your information on file for future consideration, we kindly request that you complete the online form provided here.