Intelliswift Software - Ridgefield Park, NJ

posted 5 months ago

Full-time
Ridgefield Park, NJ
Professional, Scientific, and Technical Services

About the position

The Ecommerce Demand Forecasting Analyst plays a crucial role in the organization by leveraging data to predict future sales trends and optimize promotional strategies. This position requires a strong analytical mindset and the ability to work with large datasets to derive actionable insights. The analyst will be responsible for collecting and organizing promotional data from various internal sources, ensuring that the data is categorized effectively to facilitate analysis. This includes developing a centralized data repository that allows for easy access and manipulation of data, which is essential for accurate forecasting. In addition to data collection, the analyst will utilize historical sales data and apply time series forecasting techniques to establish baseline sales forecasts. This involves cleansing promotional lifts from the baseline forecast to ensure accuracy and supporting the development of a weekly rolling forecast that incorporates both baseline sales and promotional impacts. The role also includes conducting comprehensive price elasticity analysis for different product categories and price points, which is vital for understanding how pricing changes can affect sales volume. The analyst will calculate sales lift multipliers based on historical data and promotional performance, creating a standardized menu of these multipliers for use in order forecasting. Reporting and analysis are key components of this position. The analyst will prepare regular reports on demand forecasts and promotional performance, as well as conduct ad-hoc analyses to identify trends and opportunities for improvement. This role requires excellent communication and presentation skills to effectively convey findings and recommendations to stakeholders. The ideal candidate will have a strong background in demand forecasting, particularly within an ecommerce or retail environment, and be proficient in data analysis tools such as Excel and SQL.

Responsibilities

  • Gather and organize promotional data from internal system sources
  • Categorize promotions based on themes (e.g. national promotions, members-only offers, product bundles etc)
  • Develop a centralized data repository for easy access and analysis
  • Utilize historical sales data and appropriate time series forecasting techniques to establish sales forecasts
  • Assist in cleansing promotional lifts from the baseline forecast to ensure accuracy
  • Support the development of a weekly rolling forecast that incorporates baseline sales and promotional impacts
  • Conduct comprehensive price elasticity analysis for different product categories and price points
  • Calculate sales lift multiplier based on historical data and promotional performance
  • Develop a standardized menu of sales lift multipliers to be used in order forecasting
  • Prepare regular reports on demand forecasts and promotional performance
  • Conduct ad-hoc analysis to identify trends and opportunities for improvement.

Requirements

  • Bachelor's degree in Business, Statistics, Mathematics or a related field
  • 2+ years of experience in demand forecasting, preferably in an ecommerce or retail environment
  • Strong analytical and problem-solving skills
  • Proficient in data analysis tools such as Excel and SQL
  • Excellent communication and presentation skills
  • Ability to work independently and as part of a team

Nice-to-haves

  • Experience with ecommerce platforms and promotions tools
  • Experience using forecasting techniques like ARIMA, Prophet, exponential smoothing
  • Experience using Jira, Confluence, Tableau, Adobe Analytics
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service