SUMMARYThe Sales Planning Business Analyst is responsible for high level data collection while providing insights and implementing action plans regarding current and future business trends on all NL National Accounts as well as NL Independent Retail Channel. This desk has a high level of accountability around writing reports, conducting research, analyzing data, and making recommendations to improve effectiveness and efficiency, working closely with planning to consistently evaluate and re-tool the forecast as needed. This role will also be key in item setups and GTIN management.DUTIES and RESPONSIBILITIES•National Account Leadership ResponsibilitiesoDaily and weekly updates on all reporting aspects for National Accounts such as Walgreens stores using STIBO, Amazon.com using Vendor Central and other National Accounts platforms. oDownload customer portal sales data and manipulate into meaningful reports, distribute those reports to NL stakeholders each week.oManage Walgreens weekly, monthly, and quarterly plans outlining inventory needs and goals through excel. This includes the weekly inventory pipeline sheet that is distributed to buying team.oCreate a weekly report for fulfillment to help keep stock in inventory for National Accounts and Independent Retail ChanneloCompile and manage data for inventory feedback and actionable insights regarding current and future business trends. oWork with buyers and replenishment managers to assure we are meeting/exceeding standards in inventory control, on-time shipments, and line management.oBack up for order entry for all National accounts.oComplete item set-up sheets for National accounts managers as needed.oDevelop detailed reporting through D365 and PowerBI for Walgreens, Meijer, Cracker Barrel, Joann, Wegmans, and any other accounts where reporting is readily available.•Thought Leadership ResponsibilitiesoDevelop and understand new marketing research software (i.e. Nielsen or NPD) to help drive top line business insights to key leadership on current and future business trends. oAssist Director of Sales and Sales Managers in creating deck presentations for customer meetings which includes providing high level data and business insights regarding current or future business trends. oAnalyze sales and provide customers both internal and external with actionable sales insights and action plans.oCreate high level reporting, charts, graphs and other materials to help in analyzing our business on a chain-by-chain basis.•Inter-Departmental Communication ResponsibilitiesoMeet with Planning bi-weekly to ensure forecasts align with business evolvements; promotion participation, new customer inventory holding strategy, store count adjustments, etc.oHelp plan and design business processes and make recommendations for improvementoPerform research and analysis in support of operationsoAssist in resolving business issues using systems and dataoEstimate costs and benefits of multiple actions and/or solutions and provide recommendations oWork with planning and transportation team on supply chain needs and challenges to ensure timely order deliveries. •Other DutiesoMaintain Global data information through GS1 standards. oCreation of GTINs as requested and maintains the used GTINs so they are not duplicated by GS1 standards.oFacilitate SDS requests and maintain information through on-line site, WERCS.oDevelop and maintain Sales Spec Sheets for new products which include weights, dimensions, UPC codes, product numbers, etc. oOrder and Maintain sample inventories in NL Sample Room. oCollect all needed paperwork in coordination with credit dept to ensure accuracy of allowance deductions and dispute payment.oPerform related duties or special assignments as assigned.EDUCATION & QUALIFICATIONS•Bachelor’s degree in related field •Advanced Microsoft Office Suite abilities (most especially with Excel and PowerPoint)•Daily Working Knowledge of the following is highly desirableoCustomer retail portals like; STIBO, Supplier Net, 1 World Sync and other data sync supported services, Kroger Portals, Amazon Vendor Central, etc. oExperience with PowerBI COMPETENCIESTo perform the job successfully, an individual should demonstrate the following competencies to perform the essential functions of this position.•Teamwork Skills—coordination, communication, and customer service skills.•Analytical—High degree of analytical skill with ability to analyze statistics and other data to interpret and evaluate results, and then create reports and/or presentations based on the said data.•Interpersonal Skills—the individual exhibits care and concern for consumer issues (customer-oriented), maintains confidentiality, exhibits tact and diplomacy, understands and practices ethical behavior, remains open to others’ ideas and exhibits willingness to try new things.•Planning/organizing—the individual prioritizes and plans their work activities and uses time efficiently-quick response times. •Oral communication—the individual speaks clearly and persuasively in positive or negative situations.•Written Communication—the individual edits his or her work for spelling and grammar, presents numerical data effectively and can read and interpret written information.•Quality control—the individual demonstrates accuracy and thoroughness and monitors own work to ensure quality.•Adaptability—the individual adapts to changes in the work environment, manages competing demands and can deal with frequent change, delays or unexpected events.•Dependability—the individual is consistently at work and on time, follows instructions, responds to management direction and solicits feedback to improve performance.

Minimum Salary: 21.60 Maximum Salary: 25.56 Salary Unit: Hourly