Business Analyst (Supply Chain Forecasting) AO7167575

BTI Solutions•Plano, TX

6d•Onsite

About The Position

Business Analyst (Supply Chain Forecasting) AO7167575 KEY RESPONSIBILITES/REQUIREMENTS: Essentials/Duties and Responsibilities • Hands-on to build Sales forecasting using several variables (Traffic, Seasonality, multiple promos etc.) • Develop weekly/monthly/quarterly sales forecast for quantity, sales price and revenue and track Achievement rate KPIs • Promotional analysis to develop forecasts, and average sales price • Own and build PSI at sku level for sellout, selling, shipment and delivery along with inventory view each week • Upload forecasts into SCM systems accurately each week • Develop long term forecast and NPI forecasts and upload into SCM system • Track inventory arrival and movement to warehouse • Manage aging, confirm SOP and manage all part of supply chain for assigned category • Deep understanding of Mobile business • Lead category calls and get alignment on sales forecast, demand and inventory plan • Work with Category Management, Finance, supply chain, business operations and logistics team to deliver monthly revenue Background/Experience • 6+ years of experience in Ecommerce business planning, supply chain management, category management and/or data and analytics-intensive role with an emphasis on Quantitative analytics • Bachelor’s degree in Business/Economics or in math/analytics/engineering is required • MBA would be a plus • Hands-on with advanced excel with attention to detail to integrate complex data to build forecasting and to perform analysis • Experience of working with a large national retailer or carrier for consumer electronics would be a plus • Experience of handling PSI for Mobile business will be a plus • Knowledge of ML/AI models for forecasting, pricing and promotional analytics for business analytics will be a plus • Creative thinker with excellent business acumen, analytical skills and experience with statistical modeling • High level of confidence, integrity, enthusiasm, executive presence that fits a fast-paced, energetic and proactive organization • Adaptability, using advanced preparation to quickly pivot throughout the week • Exceptional presentation skills with good Microsoft PowerPoint capabilities • Experience of working with Consumer Electronics and/or National Retail is strongly preferred

Requirements

6+ years of experience in Ecommerce business planning, supply chain management, category management and/or data and analytics-intensive role with an emphasis on Quantitative analytics
Bachelor’s degree in Business/Economics or in math/analytics/engineering is required
Hands-on with advanced excel with attention to detail to integrate complex data to build forecasting and to perform analysis
Creative thinker with excellent business acumen, analytical skills and experience with statistical modeling
High level of confidence, integrity, enthusiasm, executive presence that fits a fast-paced, energetic and proactive organization
Adaptability, using advanced preparation to quickly pivot throughout the week
Exceptional presentation skills with good Microsoft PowerPoint capabilities
Experience of working with Consumer Electronics and/or National Retail is strongly preferred

Nice To Haves

MBA would be a plus
Experience of working with a large national retailer or carrier for consumer electronics would be a plus
Experience of handling PSI for Mobile business will be a plus
Knowledge of ML/AI models for forecasting, pricing and promotional analytics for business analytics will be a plus

Responsibilities

Hands-on to build Sales forecasting using several variables (Traffic, Seasonality, multiple promos etc.)
Develop weekly/monthly/quarterly sales forecast for quantity, sales price and revenue and track Achievement rate KPIs
Promotional analysis to develop forecasts, and average sales price
Own and build PSI at sku level for sellout, selling, shipment and delivery along with inventory view each week
Upload forecasts into SCM systems accurately each week
Develop long term forecast and NPI forecasts and upload into SCM system
Track inventory arrival and movement to warehouse
Manage aging, confirm SOP and manage all part of supply chain for assigned category
Deep understanding of Mobile business
Lead category calls and get alignment on sales forecast, demand and inventory plan
Work with Category Management, Finance, supply chain, business operations and logistics team to deliver monthly revenue