Sales Demand Forecasting & Analytics Lead

Amneal • Bridgewater, NJ

1d • $145,000 - $165,000

About The Position

The Demand Forecasting & Analytics Manager develops multivariate monthly demand forecasts and delivers analytical insights supporting the generic injectable portfolio. This hands-on role combines forecasting expertise with development and maintenance of Power BI dashboards, advanced Excel models, SQL queries, and automated Alteryx workflows. The role partners with Supply Chain, Sales, Commercial Operations, Contracting, Finance, and IT to align forecasts, identify risks and opportunities, and support data-driven business decisions.

The position develops rolling monthly forecasts using multiple business drivers and statistical methods, integrates commercial and distribution data, and accounts for supply constraints that may mask underlying demand. It leads forecast reviews, measures accuracy and bias, and explains forecast changes to support planning and commercial decisions. The role also develops and maintains reporting, data preparation, and automation processes, with an emphasis on reliable data, reduced manual effort, timely reporting, and clear documentation.

A bachelor's degree in a relevant field is required; a master's degree is preferred. The role requires at least five years of relevant experience in demand planning, forecasting, or business analytics, including at least three years developing monthly forecasts using multiple demand drivers. The base salary is $145,000–$165,000 per year, with a short-term incentive opportunity within the first 12 months. Eligible positions receive a flexible benefits program including health and insurance benefits and a 401(k) matching contribution.

Requirements

• Bachelor's degree in Supply Chain, Business Analytics, Statistics, Mathematics, Economics, Information Systems, or a related field.
• At least five years of relevant experience in demand planning, forecasting, or business analytics, including at least three years developing monthly forecasts using multiple demand drivers.
• Hands-on experience building and maintaining Power BI dashboards and complex Excel models, including data connections, model relationships, scheduled refreshes, and report validation.
• Working knowledge of SQL queries and joins, relational data concepts, and DAX measures used in business reporting.
• Hands-on experience developing automated data-preparation workflows and experience with scheduled workflows.
• Understanding of multivariate forecasting, seasonality, model validation, forecast accuracy, bias, and the effect of supply constraints on observed demand.
• Ability to interpret manufacturer shipments, wholesaler inventory, downstream activity, and customer demand without double-counting channel movements.
• Advanced Excel skills, including complex formulas, lookups, SUMIFS, PivotTables, charts, and Power Query.
• Practical knowledge of Power BI data modeling, DAX, gateways, cloud connections, and refresh troubleshooting.
• Ability to translate business requirements into reliable dashboards, repeatable analytical processes, and actionable alerts.
• Strong analytical, problem-solving, communication, and presentation skills, with attention to data accuracy and documentation.
• Ability to manage competing priorities, work independently, and lead cross-functional forecasting and analytics initiatives.

Nice To Haves

• Master's degree in Business Analytics, Supply Chain, Statistics, or Business Administration.
• Experience with pharmaceutical distribution and wholesaler/customer demand data.
• Generic injectable experience.

Responsibilities

• Design, publish, and maintain interactive Power BI reports and dashboards covering demand, shipments, forecast accuracy, inventory, and customer performance.
• Connect Power BI to databases, on-premises sources through data gateways, and cloud data sources; configure and maintain connections and scheduled refreshes with IT.
• Monitor refresh performance and troubleshoot connection, credential, gateway, and data-quality issues.
• Use SQL to query, filter, aggregate, and join source datasets; use Power Query to prepare data and Power BI Model view to manage relationships, cardinality, and filter direction.
• Use DAX to create measures and calculated columns for KPIs, forecast variances, trends, and time-based comparisons; document KPI definitions, validate report results, and manage access with business owners and IT.
• Develop and maintain rolling monthly forecasts using multivariate methods, including multiple regression and time-series models with multiple business drivers.
• Incorporate historical shipments, customer ordering trends, seasonality, contract changes, customer commitments, wholesaler inventory, competitive supply disruptions, and product launches into forecast assumptions.
• Account for backorders, allocations, stockouts, and supply interruptions so constrained shipments do not understate underlying demand.
• Lead monthly forecast reviews, reconcile statistical forecasts with commercial input, and communicate forecast changes and scenarios to Supply Chain and leadership.
• Measure forecast accuracy and bias at appropriate product and customer levels, including volume-weighted error measures; use backtesting and variance analysis to improve model performance.
• Analyze direct outbound shipments alongside wholesaler purchases, inventory movements, and downstream customer shipments or indirect sales data where available.
• Identify stocking changes, order timing shifts, demand spikes, customer gains or losses, and potential supply gaps affecting monthly forecasts.
• Reconcile product/NDC and customer identifiers, units of measure, and reporting periods across data sources, and prevent duplicate counting of shipments through the distribution channel.
• Explain forecast changes and recommend actions to support inventory planning, customer service, and commercial decisions.
• Build and maintain complex Excel workbooks, forecasting models, scenario analyses, and interactive dashboards using advanced formulas, PivotTables, charts, and Power Query.
• Design reusable Excel templates with clear assumptions, input controls, and validation checks for monthly planning and ad hoc analysis.
• Create and maintain Alteryx workflows to extract, cleanse, transform, join, and validate data from multiple sources for forecasting and reporting.
• Automate recurring data flows and alerts for forecast deviations, unusual demand, inventory exceptions, data-quality failures, and workflow errors.
• Schedule and monitor workflows using available Alteryx Server or scheduling capabilities; troubleshoot failures and document dependencies and recovery procedures.
• Reduce manual reporting effort while improving data accuracy, timeliness, and consistency.

Benefits

• Short-term incentive opportunity, such as a bonus or performance-based award, within the first 12 months.
• Comprehensive, flexible, and competitive benefits program for eligible positions.
• Health and insurance benefits.
• 401(k) matching contribution.
• Employee well-being programs.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior