Business Analyst 5

Intelliswift$145K — $153K *
Plano, TX 75025In-Person
Retail & Consumer Goods
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6+ years of experience in ecommerce business planning or supply chain management.
  • Bachelor's degree in Business, Economics, Math, Analytics, or Engineering required.
  • MBA from a premier institution is a plus.
  • Advanced Excel skills for complex data integration and forecasting analysis.
  • Experience with SQL/Tableau for historical data analysis and insights.

Responsibilities

  • Develop short-term and long-term sales forecasts for the Mobile business.
  • Conduct promotional analysis to inform pricing strategies and forecasts.
  • Lead category calls to align on sales, demand, and inventory plans.
  • Manage inventory tracking, including aging and supply chain operations.
  • Integrate multiple variables to create hands-on sales forecasting models.

Benefits

  • Hybrid work schedule: 4 days onsite, 1 day remote.
  • Opportunity to influence sales and operations in a fast-paced environment.
  • Work with cross-functional teams to achieve business goals.
Full Job Description
Job ID: 25-09622 Pay rate range - $70/hr. to $74/hr. on W2
Schedule: Hybrid, 4 days onsite, 1 day WFH/remote

Top skills: Supply Chain Management, Strong hands-on advanced Excel, Promotion Analysis, and Business planning

KEY RESPONSIBILITIES/REQUIREMENTS:

The direct-to-consumer ecommerce team is looking for an experienced supply chain professional to develop both short-term and long-term forecasts and a business plan for the Mobile business. This candidate will be responsible for managing weekly/monthly/quarterly sales forecasts for both Quantity and Average Sales Price with high accuracy using analytics and building models based on Ecommerce sales drivers, promotional analysis, and using category-specific business knowledge.

The individual is expected to be hands-on to prepare Sales forecasting, Pricing forecast, and to evaluate Ecommerce sales drivers (Traffic, conversion rate), impact of promotions on different sales platforms, and create what-if scenarios to achieve business goals.

The role also requires building PSI at sku level for assigned categories and working with the category team to align on the forecast and work with central PM and SCM teams to align on the supply plan and inventory management.

The candidate should analyze pricing drivers and build an 'investment profile' based on pricing changes for assigned categories.

A successful candidate is highly analytical with critical thinking skills and business savvy, is adaptive and able to work cross-functionally to influence sales and operations teams working towards a common goal in a highly matrixed, fast-paced organization.

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 forecasts and NPI forecasts and upload into the SCM system
• Track inventory arrival and movement to the warehouse
• Manage aging, confirm SOP, and manage all parts of the supply chain for the 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
• A bachelor's degree in Business/Economics or math/analytics/engineering is required
• An MBA from a premier institute 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 working with a large national retailer or carrier for consumer electronics would be a plus
• Experience in handling PSI for Mobile business will be a plus
• Knowledge of SQL/Tableau to pull historical promo data for analysis and statistical analysis
• 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, and 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

Similar Jobs

More Retail & Consumer Goods Jobs

Find similar Business Analyst 5 jobs: