Supply Chain Business Analyst
Dallas, TX, US, 75240
Req ID: 243780
General Purpose
The Supply Chain Optimization Analyst will support the Supply Chain Network Design Manager. The Analyst will support the S&OP process. Responsible for pulling, reconciling, enhancing, maintaining, reporting and tracking various data tables/reports. This role will entail the development and/or the enhancement of various tools and reports in Blue Yonder, Power BI, and Coupa (LLamasoft).
Duties and Responsibilities
- Support Sales & Operations Planning (S&OP) cycle for manufacturing & transportation operations using Blue Yonder
- Analyze demand, supply, capacity, and inventory data to balance plans
- Develop and maintain production, capacity, and inventory forecasts
- Incorporate line maintenance schedules, planned shutdowns, and holidays into capacity planning
- Plan and evaluate purchase of externally sourced product when internal capacity is insufficient
- Identify supply constraints, risks, and mitigation scenarios
- Develop and run what-if scenarios (demand increases, capacity loss, etc)
- Analyze and recommend labor overtime and/or additional production shifts to meet demand
- Coordinate with Sales, Manufacturing, Planning, and Procurement teams
- Share proposals and strategies with planning and manufacturing teams
- Coordinate production from alternate manufacturing sources when planned sources are constrained
- Evaluate overcost and capacity impacts of Out Of Matrix (OOM) decisions
- Align OOM actions with Supply Chain, Manufacturing, Logistics, and Finance stakeholders
- Track and report OOM volumes, root causes, and financial impacts
- Recommend actions to minimize future OOM occurrences through improved planning accuracy
- Prepare S&OP dashboards, KPIs, and executive review materials
- Track plan vs. actual performance and recommend corrective actions
- Support continuous improvement in planning processes and data accuracy
- Ensure alignment between business strategy and operational plans
- Support ad-hoc projects as required
- Data extraction, analysis and reporting to support Product Supply Productivity Initiatives.
Qualifications
- BA/BS degree
- Blue Yonder or LLamasoft software experience strongly preferred
- Network design experience
- Important: Advanced Excel and PowerPoint
- Important: Network design modelling with Llamasoft software & Power BI, or Blue Yonder for S&OP
- Important: Responsible to do analysis of the network to detect savings according to the demand.
Applicants with disabilities may be entitled to reasonable accommodation under the Americans with Disabilities Act and certain Texas or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Coca-Cola Southwest Beverages. Please inform us at talentacquisition@cocacolaswb.com if you need assistance completing this application or to otherwise participate in the application process.
Know Your Rights dol.gov
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