Sales Demand Forecasting & Analytics Lead

The Demand Forecasting & Analytics Manager is responsible for developing multivariate monthly demand forecasts and delivering analytical insights that support the generic injectable portfolio. This hands-on role combines forecasting expertise with the ability to build and maintain Power BI dashboards, advanced Excel models, SQL queries, and automated Alteryx workflows. This role will partner with Supply Chain, Sales, Commercial Operations, Contracting, Finance, and IT to align forecasts, identify risks and opportunities, and support data-driven business decisions. Job Description The Demand Forecasting & Analytics Manager is responsible for developing multivariate monthly demand forecasts and delivering analytical insights that support the generic injectable portfolio. This hands-on role combines forecasting expertise with the ability to build and maintain Power BI dashboards, advanced Excel models, SQL queries, and automated Alteryx workflows. This role will partner with Supply Chain, Sales, Commercial Operations, Contracting, Finance, and IT to align forecasts, identify risks and opportunities, and support data-driven business decisions. Essential Functions Power BI Dashboard Development and Management: Design, publish, and maintain interactive Power BI reports and dashboards for 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 in partnership 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 Model view to create and manage table relationships, cardinality, and filter direction; Apply working knowledge of DAX to create measures and calculated columns for KPIs, forecast variances, trends, and time-based comparisons; Maintain documented KPI definitions, validate report results, and manage appropriate access with business owners and IT Monthly Demand Forecasting: 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 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. Wholesaler and Customer Demand Analytics: 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 that affect monthly forecasts; Reconcile product/NDC and customer identifiers, units of measure, and reporting periods across data sources; prevent duplicate counting of shipments as they move through the distribution channel; Present clear explanations of forecast changes and recommend actions to support inventory planning, customer service, and commercial decisions. Advanced Excel Modeling and Reporting: Build and maintain complex Excel workbooks, forecasting models, scenario analyses, and interactive dashboards using advanced formulas, PivotTables, charts, and Power Query; Design reusable templates with clear assumptions, input controls, and validation checks to support 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 through available Alteryx Server or scheduling capabilities, troubleshoot failures, and document dependencies and recovery procedures; Continuously reduce manual reporting effort while improving data accuracy, timeliness, and consistency.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 through available Alteryx Server or scheduling capabilities, troubleshoot failures, and document dependencies and recovery procedures; Continuously reduce manual reporting effort while improving data accuracy, timeliness, and consistency. Qualifications Education Bachelors Degree (BA/BS) Supply Chain, Business Analytics, Statistics, Mathematics, Economics, Information Systems, or a related field - Required Master Degree (MS/MA) Business Analytics, Supply Chain, Statistics, or Business Administration - Preferred Experience 5 years or more in Relevant experience in demand planning, forecasting, or business analytics, including at least 3 years developing monthly forecasts using multiple demand drivers. Demonstrated 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; experience with scheduled workflows Experience with pharmaceutical distribution and wholesaler/customer demand data; generic injectable experience Specialized Knowledge 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 and 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. Licenses The base salary for this position ranges from $145,000 to $165,000 per year. In addition, Amneal offers a short-term incentive opportunity, such as a bonus or performance-based award, with this position within the first 12 months. Amneal ranges reflect the Company’s good faith estimate of what Amneal reasonably believes that it will pay for said position at the time of the posting. Individual compensation will ultimately be determined based on a variety of relevant factors, including but not limited to, qualifications, experience, geographic location and other relevant skills. At the heart of our Total Rewards commitment is a comprehensive, flexible and competitive benefits program for eligible positions that enables you to choose the plans and coverage that meet your personal needs. This includes above-market, diverse and robust health and insurance benefits to meet the varied needs of our employees as well as a significant 401(k) matching contribution to help our employees save for retirement. We also promote employee well-being with programs that help you enjoy your career alongside life’s many other commitments and opportunities. #J-18808-Ljbffr Amneal Pharmaceuticals LLC