Analyst, Imports & Distribution Requirements Planning (Drp)

Job Description

Company Summary

We're the producers, creators and marketers of beer, wine and spirts brands that people love. At Constellation Brands, we're driven to push boundaries and think beyond today to deliver products and experiences that resonate now, tomorrow and well into the future. Because of this approach, we're the fastest-growing large CPG company in the U.S. at retail, with operations in the U.S., Mexico, New Zealand and Italy. Our premium portfolio of iconic brands like Corona Extra, Modelo Especial, Kim Crawford, Robert Mondavi, Meiomi, The Prisoner, SVEDKA Vodka, High West Whiskey, and more drive industry-leading growth for us today. But we're just getting started. Our ability to stay on the forefront of consumer trends has fueled our success since our founding in 1945 and will guide us in creating the next generation of products and experiences Worth Reaching For.

Position Summary

The Planning Analyst, Distribution Requirements Planning (DRP) is responsible for supporting the planning of finished good internal inventory movement and providing key analytical insights to ensure product is at the right place at the right time. The planning analyst will support the development, implementation, and sustainment of processes, behaviors and tools that facilitate the planning and transfer inventory in a cost effective and efficient fashion while being mindful of the needs of the customer. This is a great opportunity to support our expanding Wine & Spirits distribution footprint and implement best practice procedures as we look to optimize our network.

Responsibilities

• Develop and manage processes, behaviors, and plans to facilitate effective Distribution Requirements Planning between our production facilities and distribution centers

• Generate reporting that provides insights needed to identify and manage risk related to supply availability, overstock and stranded inventory, and inventory imbalances between distribution centers

• Execute transfers of inventory between distribution centers to proactively mitigate supply risk and minimize obsolescence risk in a cost effective manner

• Participate in collaboration meetings with key Operations business partners including Logistics, Transportation, Supply Planning, Demand Planning, and Production teams to align on distribution needs and develop risk mitigation plans

• Support weekly Sales & Operations Execution (S&OE) meetings by advising on DRP related risk and supporting actions needed to deliver on business needs

• Develop process documentation to detail best practice activities and standardize work to support DRP tasks, particularly related to new processes required to support our expanding distribution center network

• Support DRP and Imports Planners by performing ad-hoc analyses as needed

• Develop comprehensive knowledge of company's internal operations to develop forward-looking focus for business, and work to achieve the organization's operational and financial goals

• Other duties as assigned.

Minimum Qualifications:

• Bachelor's degree from four-year college or university majoring in Supply Chain, Engineering, Finance, Statistics, Mathematics, or another business-related field

• 1-2 years' experience in Planning, Finance, Optimization, Engineering, Continuous Improvement, Supply Chain, or other analytical roles

• Ability to deliver concise, summarized assessments that drive effective business decisions

• Proficiency in Excel, including experience using pivot tables, slicers, nested formulas, etc.

• Strong critical thinking & problem-solving skills

• Highly developed interpersonal skills and ability to work collaboratively with co-workers, related internal functions, external partners, and on project teams.

• Flexibility with hours on occasion to accommodate business partners across a variety of time zones

Preferred Qualifications

• 2+ years' experience in supply chain role in CPG industry or beverage manufacturer

• Ability and high comfort level with presenting across all levels of an organization

• Solid understanding of Excel including experience with Power Query and Power Pivot, modeling with large, disparate datasets and visualization techniques

• Solid understanding of relational databases

• Model building expertise to answer "what if" scenarios

• Visualization software experience (MicroStrategy, Tableau, PowerBI)

• SQL, VBA and/or other programming language skills a bonus

• APICS Certification (CPIM, CSCP, CLTD)

• ERP systems knowledge (JDA, SAP S/4HANA)

ADA Physical/Mental/Workplace Requirements:

Must be at least 21 years of age. Must be able to sit and/or stand for long periods of time and work on a computer for extended periods. Lifting may be required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Location

Rochester, New York

Additional Locations

Chicago Office, Virtual - US

Job Type

Full time

Job Area

Supply Chain

The salary range for this role is:

$56,200.00 - $115,400.00

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee's pay position within the salary range will be based on several factors including, but limited to, the prevailing minimum wage for the location, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, any collective bargaining agreements, and business or organizational needs. We offer comprehensive package of benefits including paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company's sole discretion, consistent with the law.

Equal Opportunity

Constellation Brands is committed to a continuing program of equal employment opportunity. All persons have equal employment opportunities with Constellation Brands, regardless of their sex, race, color, age, religion, creed, sexual orientation, national origin or citizenship, ancestry, physical or mental disability, medical condition (cancer or genetic characteristics), marital status, gender (including gender identity or gender expression), familial status, military or veteran status, genetic information, pregnancy, childbirth, breastfeeding, or related conditions (or any other group or category within the framework of the applicable discrimination laws and regulations).

Not sure you meet all qualifications? Research shows that women and members of other under-represented groups tend to not apply to jobs when they think they may not meet every qualification, when, in fact, they often do! We are committed to creating a diverse and inclusive environment and strongly encourage you to apply.