Business Analyst Rapid City, SD (http://maps.google.com/maps?q=2150+Coca-Cola+Lane+Rapid+City+SD+USA+57702) • Corporate Job Type Full-time Description Coca-Cola, with its many brands, has been recognized and enjoyed by people around the world for over a century. Founded in 1956, Coca-Cola Bottling Company High Country is a family owned, regional Bottler serving portions of Colorado, Minnesota, Montana, North Dakota, South Dakota, Utah, and Wyoming. Every day we honor our core values of Honesty, Integrity, Trust, and Respect through encouraging our team members to develop, grow and serve. Together we become more effective and productive… in life and work. Refresh your career and join us in refreshing the world! Apply Today! + Hourly pay for theBusiness Analyst role is $23.00 to $25.00 per hour Depending on Experience. + Robust benefits package including 100% paid employee health, dental and vision options! + 100% Employer Paid Life Insurance for Employees + 401K With Employer Match + Product Discounts + Much more! What will you do as a Business Analyst? As part of Business Support Services, the Business Analyst is responsible for applying analytical methods and tools to optimize customer routing, pricing, volume, and customer programs to ensure most efficient operations and customer service levels. This position will create, implement and monitor new routing solutions and maintain database information (customer, products, etc.) in all software systems for the company. The Business Analyst is the first point of contact for all authorized database changes. This position is also responsible for the implementation and monitoring of full-service vending commission plans and customer beverage agreements. ESSENTIAL DUTIES AND RESPONSIBILITIES + Customer contracts (beverage agreements) management. + Review information for contract customers in all software systems for the company. + Ensure various customer/volume contract accruals reported accurately to accounting. + Customer Funding and Program financial management. + Customer Trade Marketing/Customer Collaboration Funds (CTM/CCF) management. + Shared Market Funds (SMF) management. + Local Market Program (LMP) funding analysis. + Incidence based pricing management. + Monster fee distribution management. + Franchise company funding. + Assist in entering, monitoring, and reviewing pricing strategies to optimize operational efficiency and customer invoice accuracy to reflect accurate and timely net revenue. + Subject matter expert on pricing plans, off-invoice plans, and promotion plans in company systems. + First point of escalation for pricing overrides (point of contact for field sales). + Communicate and train all pricing strategies and changes with the sales staff. + Ensure no customers revert to wholesale if current on pricing. + Communicate pricing adjustments to AR Department. + Utilize Routing Software to build and restructure routes, analyze and determine the most cost-effective means of pre-selling and delivering customer orders. + Maximize delivery efficiencies to ensure lowest cost while working within the constraints of large geographic areas, proper sequencing, balanced workload and customer/driver continuity. + Ensure customer delivery parameters are accurate in Routing Software such as delivery windows and service times. + Perform standard route maintenance in the Routing Software and other applicable systems. + As the business changes with customers’ seasonal variations in demand, partner with the sales teams to make necessary adjustments to routing to continue to maximize route efficiency. + Ensure routing solutions comply with DOT hours and weight restrictions. + Assist in analyzing commission impacts on route changes. + Develop, implement and monitor management reports that measure the cost effectiveness of the routing and the utilization of the applicable software. + Monitor the adherence to routing solutions after session is completed using various reporting capabilities. + Solicit feedback and build rapport with senior sales and other employees to troubleshoot issues and find workable solutions to challenges which may arise during the routing implementation. + Assist in working with vendors on new developments and modifications of software to best service company needs. + Assist in training sales staff on new software systems and/or modifications. + Update and maintain the database information (customer, vendors, products, routes, etc.) in all software systems for the company and train sales staff on proper completion of documentation. + Ensure case volume is accurate per sales system which is used for incentives, commissions, and funding. + Ensure commissions are accurately reported to Payroll. + Report volume to outside parties and submit funding requests as assigned. + Conform to all safety rules and use all appropriate safety equipment. + Conform with, and abide by, and re-enforce all regulations, policies, work procedures and processes JOB KNOWLEDGE, SKILLS AND ABILITIES + Strong analytical, computer and project management skills. + Ability to work with all levels within a Sales Center location. + Adaptability – Ability to adapt to change in the workplace. + Communication – Ability to effectively, clearly and concisely communicate verbally and in writing. + Enthusiasm – Ability to bring energy to the day to day as well as long-term tasks and plans. + Judgment – Display willingness to make timely decisions and exhibit sound and accurate judgment. + Reliability – Demonstrate regular attendance and availability to staff and management. + Safety & Security – Promote and personally observe safety and security procedures and uses equipment and materials properly. + Organization – Must be exceptionally detail oriented and able to multi task. Ability to manage time, and plan and work independently under tight deadlines in a rapidly changing environment. + Confidentiality – Must maintain the highest level of confidentiality. + Honesty, Trust, Integrity, & Respect – Must be seen as truthful and credible and exhibit respectful behavior in all actions representing the company. Requirements EDUCATION AND EXPERIENCE + Bachelor’s degree in Accounting, Finance, Business, or Supply-Chain Management preferred. + 1-3 years’ experience in direct store delivery industry or comparable combination of education and experience preferred. + Highly skilled in Microsoft Office including Excel, Word and Outlook. + Experience with Routing Software preferred. TRAINING REQUIREMENTS + New Hire Orientation + Company Safety Training + Other training as required by Company PHYSICAL DEMANDS + Work in an office environment; sustained posture in a seated position for prolonged periods of time; may utilize a computer terminal for prolonged periods of time. + Work involves walking, talking and hearing, using hands to handle, feel or operate objects. Vision abilities required by this job include close vision and the ability to focus when using computer terminal. PERSONAL PROTECTIVE EQUIPMENT (PPE) + None WORK ENVIRONMENT + The noise level in the work environment can be moderately noisy due to manufacturing. + Working hours vary between 7 am to 5 pm depending upon schedules and the season. Typical work week of Monday through Friday and approximately 40 to 45 hours per week. Additional hours may be required occasionally and travel up to 10% is required. This position will be on call one week out of every 6 weeks. This job description lists the major duties and requirements of the job and is not all-inclusive. Incumbent(s) may be expected to perform job-related duties other than those contained in this document and may be required to have specific job-related knowledge and skills. Coca-Cola Bottling Company High country is an Equal Opportunity/Affirmative Action Employer, requires pre-employment drug testing for all applicable positions and adheres to an Alcohol and Drug-Free Workplace. Salary Description $23.00 - $25.00 per hour DOE