Business Analyst / Allocations Manager (Wine Jobs: Management & Administration)

  Empire Merchants North

  Coxsackie, New York

Job Description

Empire Merchants North is the premier wine and spirits distributor in Upstate New York with roots going back to the end of Prohibition. With more than 700 dedicated associates and state-of-the-art facilities, Empire Merchants North has become synonymous with both service and quality and has earned the loyalty of more than 9,000 area restaurants, bars, hotels, nightclubs, and retail outlets. Empire Merchants North acts as a marketing agent for the brands that we represent and is proud to employ the most knowledgeable and well-equipped sales force in Upstate New York.

We are seeking a high energy, motivated Business Analyst / Allocation Manager in Coxsackie, NY.

Assist the Business Management Department with a coordination of duties including but not limited to product allocation methods, compliance, new supplier setup and business analytics. Responsible for maintaining & communicating allocation methods along with drawing conclusions and making recommendations to management on an appropriate course of action by analyzing sales data, competitive information, pricing figures, industry data related data and any other applicable sources of information.  Analyses may include sales forecasting, opportunity identification and evaluation of program performance.  Role also entails the development of sales templates and goal development as needed.   

ESSENTIAL POSITION RESULTS

•    Creates, loads, maintains and communicates allocation related information as necessary.
•    Audits all information related to allocated items including but not limited to allocation records, sales orders and material statuses to ensure compliance with Empire Merchants North Policy and State Regulations.
•    Reviews and suggests improvements to current policy, procedures and forms.
•    Enters all appropriate data necessary for new supplier set up including preparing initial pricing calendars and profitability reports (Proforma)
•    Coordinates with all departments (Business Management, Purchasing, Finance, and Price Posting) to ensure all aspects are complete for sale.
•    Prepares materials for supplier planning meetings by aggregating and reviewing Focus Marketing data, internal sales data, spend data, important demographic and socioeconomic developments and pricing and category trends.  
•    Attends and contributes to meetings as appropriate by providing any commentary on analyses or pulling relevant data during the meeting as necessary.
•    Evaluates the potential impact of pricing modifications or prospective programming elements by reviewing pertinent sales data, research and comparable examples to forecast sales.
•    Uncovers market and brand opportunities by developing an understanding of category, customer and market dynamics and using this knowledge to assess brand performance.
•    Measures risk to sales plan (gap analysis) by comparing the plan to historical sales data, current trend information and marketplace developments; reports potential shortfalls to management.
•    Develops sales templates; collaborates with Business Managers, Division Manager or General Sales Manager to identify business needs and designs appropriate, replicable reports.
•    Trains administrative staff on process to recreate/run templates.
•    Package data for sales materials by working with Business Manager/Marketing Director to ascertain needed information and converting data into concise facts and visuals that can be easily incorporated into sell sheets, concept sells or presentations.
•    Uncovers drivers for important changes in sales performance by reviewing appropriate competitive and internal data.  
•    Measures ROI on selected programming by working with Business Managers and Marketing Director to determine evaluation criteria.
•    Develops business review content by working with the Supplier, Business Manager and Sales Management to analyze sales performance, develop business case, and incorporate data into templates.
•    Completes all necessary training programs by attending, participating, and passing all required tests as defined by management. (e.g. FOCUS MARKETING, ANALYTICAL TRAINING).
•    Maintains customer and supplier confidence by keeping appropriate information confidential.  
•    Maintains a safe and clean working environment by complying with procedures, rules and regulations.
•    Contributes to team effort by accomplishing related results as needed.

SUPERVISORY RESPONSIBILITIES

 None

Skills & Requirements

MINIMUM QUALIFICATIONS

Education, Certifications and /or licenses:

•    Bachelor’s degree and/or equivalent training and work experience
•    Must have a valid driver’s license and can operate a motor vehicle.
Experience:

•    Financial, marketing or business analyst experience; consumer packaged goods or data provider (e.g. IRI, Nielsen) background a plus.  
•    A minimum of 2 years in sales/marketing or industry related experience is required.

•    Experience with SAP and Winshuttle a plus.
Knowledge/Skills:

•    Highly fluent in Excel and relational database programs.  Strong knowledge of Power Point.
•    Must be a results oriented professional with excellent verbal/written communication skills using diplomacy and discretion as well as strong customer service skills.  
•    Ability to multi-task, work independently and/or within a team, pay attention to detail and meet deadlines.

How To Apply