Business Analyst. 1. Job Title ALDI/COSTCO Business Analyst No. Positions 1 Location San Antonio/MX/Remote Department Sales Reports to: Director of Sales Main Purpose Support the Sales team by tracking and analyzing demand trends in order to provide forecasts along with insights to continue growing business at key customers 2. Position Requirements Education Business Administration or business discipline. Degree Bachelor’s degree Experience 1-2 years of experience in Fresh Produce or Consumer-Packaged Goods industry is preferred Language English Required 3. Key Job Accountabilities(3-5) 1. Analyzing shipment to customer projection data in order to provide demand forecasts (base & promotional) to the cross functional team 2. Provide ongoing analysis of customer service data & scorecards, providing insights that will help formulate strategic plans to improve OTIF performance 3. Complete customer administrative requests related to new item setup, promotional activity, pricing updates and supply projections 4. Use sales and syndicated data (IRI, Panel, etc) to identify trends and provide customers with insights for driving stronger category performance 5. Strong communication and collaboration to Sales Team, cross functional partners, and Customers. 4. AdditionalAccountabilities or Specific Functions (5-8)Order does not imply level of importance to successfuljob performance Specific Functions – Activities Periodicity (Weekly, Monthly, Always) Principal Indicators OTIF reporting & communication Daily/Weekly Daily reports w/ Weekly recaps Demand forecast updates Weekly/Monthly % Forecast Accuracy Customer communication of supply projections with callouts of shortages/excess Weekly % Completion Sales and category performance(panel) reporting Monthly % Completion 5. Knowledge andtechnical requirements (Only list skills and abilities required to do the job) Proficiency level Basic Proficient Expert Knowledge and technical requirements Competency in Microsoft Excel including pivot tables and v-lookup, to manage large datasets X Utilize multiple data sources to gather information to quickly identify business opportunities and gaps X Familiar with Syndicated Data solutions (IRI/Nielsen/Panel) and ALDI Produce Tendering Portal X 6. Skills andCompetencies (Only list skills and abilities required to do the job) Proficiency Level Basic Proficient Expert Business Insight X Manages Complexity X Ensures Accountability X 7. Changes HistoricalRecords Revision Changes Date (Month, year) 0 New Template 2018 1 The format was updated Point 5.0 and 6.0 were separated Section 6.0 was added, and the proficiency level was modified 2019