Share this Job

Business Intelligence Analyst

Date:  May 13, 2022

Dallas, TX, US, 75240


General Purpose

Southwest OU generates and maintains a package and chain level volumetric and financial forecast and validates all data across Southwest systems. The incumbent analyzes the CRAFT Demand Forecast at the key account level and works closely with NRS, KA, Demand Planning and RGM to improve the operational and monthly forecast accuracy and as the liaison between IT and the Commercial teams to ensure consistent, unified, clean data for reporting and analysis across multiple systems

Duties and Responsibilities

  • Analyze volumetric and financial (rates) performance data to identify business plan variances using established systems and ad-hoc problem solving
  • Develop and own the Southwest volumetric and financial (rates) forecast for Key account and AO chains
  • Utilize a collaborative approach to obtain current and accurate information for package and chain level forecasts
  • Work with RGM, Finance, Demand Planning and Key Account teams to reach forecast consensus
  • Identify and serve up Operating Unit forecast risks and opportunities
  • Proactively analyze forecast accuracy against usage trends, market intelligence and economics, making and communicating adjustments as needed as well as develop techniques to improve or influence results 
  • Provide and/or present monthly demand review content as part of the S&OP process
  • Perform weekly analysis on Key account and AO forecasts and manually override volume/rates as needed
  • Perform deep dives into the data framework of each of the SW systems and become the expert on the inner workings of each system
  • Support the annual CRAFT realignment for the Operating Unit
  • Continuously improve forecasting techniques, method, and approach
  • Support EOM reporting, provide system maintenance support for CRAFT and MM, and ensure master data alignment across systems
  • Proactively analyze system data and usage as Data Standard Board recommended changes take place and communicating adjustments as needed
  • Assist in validating new automated reporting system requirements and data alignment
  • Prepare Ad hoc reporting and analysis for the RGM and Commercial teams


  • Bachelor's Degree in Business, Accounting, Finance, Statistics or equivalent, or combination of education and relevant work experience 
  • Must possess a minimum of 3 years Demand Planning, Financial analysis or Supply Chain analytics experience
  • Business Planning: Knowledge of specific supply chain capabilities, strategies and interdependencies to perform short and long-term business planning. 
  • Knowledge of statistical and mathematical /computer programs and modeling techniques
  • Must be able to generate innovative ideas and solutions to address problems
  • Demonstrated ability to present data to drive decision making
  • Ability to apply and analyze large amounts of data for developing projections and estimates
  • Demonstrated ability to produce reports using UFP, UPVR, OLAP, Excel, SAP, MM, Pivot Tables, Access and Flat Files
  • Experience with CRAFT preferred
  • Detail orientated with strong analytical and math skills
  • Ability to collaborate cross-functionally and coordinate efforts around process improvement
  • Strong oral and written communication
  • Proactive thinker and problem solver
  • Strong follow through and organizational skills

Coca-Cola Southwest Beverages LLC is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class.

Nearest Major Market: Dallas
Nearest Secondary Market: Fort Worth