Manager Business Analytics/Forecasting

Reference Number: wBaoRp
Location: Parsippany, New Jersey, US

The Manager, Business Analytics & Forecasting is responsible for monitoring business developments and market trends, and maintaining on-going analytical tools, reports, and systems. Primary responsibilities encompass the creation, refinements, and updates to business report presentations, dashboards, and routine analyses; in addition to various ad hoc analysis requests to support management decision making. This role supports Finance, Market Access & Ops, and Commercial as a centralized hub of reporting & short term Revenue forecasts development. Responsibilities include providing management with timely, accurate monthly, quarterly and ad hoc Revenue reports and analytics as well as ad hoc insights and forecasts including developing analytics requests from key stakeholders.


• Maintains data warehouse, analytical applications & reporting cubes to ensure integrity of account and IDN infrastructure through ongoing QC and system updates/enhancements in conjunction with IT, Trade, and Sales Operations

• Update and process secondary data feeds from industry sources (e.g. Lexus Nexus, Definitive, etc.) and internal data (call file, sales data, etc.) into Excel and other environments using automated procedures and custom programming.

• Drive national reporting (including monthly flash reporting, ELT presentations, and dashboards) with various sub-national analyses to support meaningful diagnosis as to key business drivers of performance

• Develop detailed Revenue Forecasts and provide ongoing analysis including: Quarterly Latest Estimates and annual Budgets by sku; Monthly rolling forecasts; Ad hoc analysis of current vs. historical trends and implied projections

• Track and report Gross-to-Net • Develop appropriate customer segment analysis and reports

• Prepare and distribute timely and insightful financial reports used to determine progress against strategic plan, budget forecasts, and prior years

• Develop and refine timely on-going slides and reports to concisely communicate relevant business issues in an independent manner with supervisor and identified key stakeholders

• Effectively presents analysis results to supervisor and dotted line stakeholders with meaningful takeaways and next step recommendations

• Independently leads the development and design of ad-hoc custom analysis and assessments utilizing relevant data sources

• Maintain detailed master-calendar of key deliverables, including lead times for editing and approval processes

• Pro-actively streamline and document processes supporting the generation of all tracking reports

• Responsible for providing expert-level training and assistance to appropriate department staff members in use of analytical tools and data sources


The qualified candidate will possess the following:

Bachelor’s degree in finance, accounting or closely related field from accredited college or university. CPA or MBA preferred


Minimum 5 years of experience in financial analysis, revenue forecasting, management reporting, financial planning/budgeting or related area 

Proficient with MS Office applications (Excel,Word, PowerPoint, Access)


Demonstrated knowledge of accounting and financial reporting software.


Proven excellent analytical and quantitative skills.


Proven excellent financial modeling skills.


Minimum 2 years’ experience in a corporate environment required; experience supporting Sales & Marketing depts. and revenue forecasting; pharmaceutical industry experience preferred


Demonstrated knowledge of continuous improvement initiatives and tools.


Demonstrated working knowledge of US GAAP


Excellent written and verbal English communication skills including technical writing and presentation skills


Demonstrated detail- and results-orientation with strong problem solving, research and resolution skills. Proven ability to manage multiple projects, set priorities and meet deadlines.

Experienced Professional (Non-Manager)