3PM Supply Execution & Inventory Analyst

Constellation Brands; Chicago (IL); On-site; USD 75,000 - 95,000; Full time

Job summary

Constellation Brands is seeking an Analyst to support acquisitions, innovation and New-to-World brands through end-to-end supply execution with third-party manufacturers, warehouses, and logistics partners. You will drive production transactions, materials control, customer orders, and lifecycle dispositions while leveraging SAP, Excel and Power BI for data integrity and cost visibility.

The role emphasizes cross-functional collaboration, process improvement, and centralized analytics to

Qualifications

• Bachelor’s degree in Supply Chain, Business, Engineering, Operations or related field.
• Progressive experience in supply chain, planning or analytics.
• ERP experience; SAP preferred; advanced Excel; BI/reporting skills.

Responsibilities

• Execute daily production, inventory, orders and logistics across the supply network.
• Review schedule status, confirmations, usage and exceptions for readiness.
• Coordinate SAP transactions; resolve incomplete or incorrect activity.
• Maintain orders and execution data; resolve blocks and constraints.
• Track inbound/outbound shipments and inventory in transit.
• Perform inventory reconciliations; investigate variances and corrective actions.
• Support month-end close and financial controls with inputs and discrepancies.

Skills

Data-driven decisions

Cross-functional collaboration

Analytical skills

Problem solving

Communication

Education

Bachelor's degree in Supply Chain, Business, Engineering, Operations or related field

APICS/ASCM certification

Tools

SAP

Power BI

Excel

Ariba

SAP IBP

Job description

Job Description Position Summary

As part of the New Business Ventures and Third-Party Manufacturing organization, this role supports acquisitions, innovation and New-to-World brands through end-to-end supply execution across third-party manufacturers, warehouses, logistics providers and customers. The Analyst executes and improves activities spanning production transactions, materials and inventory control, customer orders, deployment, shipments, service exceptions, financial controls and product lifecycle disposition. Work assignments may flex across these areas based on business priorities, workload and team capability, enabling two analysts in the role to provide cross-functional coverage and scalable support. In a hyper-care integration environment, the role combines disciplined manual intervention with analytics, process documentation and continuous improvement to strengthen service, data integrity, inventory accuracy, cost visibility and execution controls.

Key Responsibilities

• Execute daily production, inventory, customer order, deployment and logistics activities across third-party manufacturers and the broader supply network, with assignments flexed based on business priorities.
• Provide visibility to production readiness and execution by reviewing production orders, schedule status, confirmations, actuals, material usage, finished goods receipts and related exceptions.
• Coordinate timely and accurate production confirmations, goods receipts, stock transfers, post goods issue activity and other supporting SAP transactions; resolve or escalation incomplete or incorrect activity.
• Create and maintain customer orders and execution data, validating quantities, dates, locations and status while coordinating resolution of order blocks, supply constraints and fulfillment exceptions.
• Track inbound materials, finished goods shipments, carrier milestones, inventory in transit and delivery status across suppliers, third-party manufacturers, warehouses, logistics providers and customers.
• Perform inventory reconciliations between SAP, warehouse records and third-party manufacturer reports; investigate variances, document root causes and coordinate corrective actions.
• Support service recovery and supply risk mitigation by maintaining visibility to allocation decisions, shipment delays, system-to-physical mismatches and required stakeholder actions.
• Support month-end close and financial controls by compiling production, receipt, consumption, inventory, accrual and variance inputs and researching invoice discrepancies involving quantities, purchase orders, rates or documentation.
• Support inventory health and product lifecycle execution, including aging, excess and obsolete exposure, donation, disposition and required documentation for approved inventory actions.
• Maintain KPI and scorecard inputs related to schedule adherence, transaction timeliness, yield, inventory accuracy, order status, on-time delivery, service and cost performance.
• Develop analytics that connect production, inventory, order, shipment, service and cost outcomes; translate recurring drivers and risks into recommendations for planner review and continuous improvement.
• Document manual workflows, identify control gaps and support conversion of repeatable activities into standardized, automated cross-functional processes and systems.
• Operate with a one-team mindset, building cross-training and backup capability across production execution, inventory, customer operations, deployment and logistics workstreams during peak or hyper-care periods.

Key Internal Partners

Materials Planning, S&OP, S&OE, Procurement, Finance, Quality, Regulatory, Transportation, Warehousing, Customer Management, Sales, Marketing and Brand Teams.

Key External Partners

Third-Party Manufacturers, Suppliers, Logistics Providers and Warehousing Partners.

Core Competencies

Ownership and accountability Data-driven decision making Cross-functional collaboration Risk identification and mitigation Continuous improvement Cost awareness and business acumen One-team mindset and role flexibility Adaptability and change leadership Execution excellence and follow-through Stakeholder management and communication Process development and scalability Problem solving and root cause analysis Systems thinking Strategic thinking and decision support.

Qualifications

Bachelor’s degree in Supply Chain, Business, Engineering, Operations or a related field. Progressive experience in supply chain, planning, operations, commercialization, customer service, logistics or analytics. Experience working in an ERP environment; SAP experience strongly preferred. Advanced Microsoft Excel proficiency; Power BI or similar reporting tool experience preferred. Strong analytical, communication, organization and problem-solving skills. Demonstrated ability to manage detailed transactional work while identifying broader process, cost, inventory, service and customer implications. Ability to shift priorities, learn across workstreams and provide reliable backup coverage in a dynamic integration environment.

Preferred Qualifications

APICS/ASCM certification. CPG, beverage alcohol or manufacturing experience. Experience supporting acquisitions, business integrations or third-party manufacturing networks. Experience with SAP IBP, O9, Blue Yonder/JDA, Ariba, Power BI or similar tools.

Travel Requirements

Up to 10-15% travel.

Physical Requirements/Work Environment

Must be able