Financial Analyst, Program Finance

Regeneron Pharmaceuticals • Sleepy Hollow, WY

2d • Onsite

About The Position

The Program Finance Analyst is an integral part of the program finance team responsible for development programs within assigned therapeutic areas, providing analyses and interpretation for relevant stakeholders including Senior Management, Program Management, Development teams, Clinical Project managers, Strategic Alliance Management, and external collaborators. The Program Finance Sr. Analyst will also play a critical role in clinical trial and regulatory budget planning and forecasting. The Program Finance Analyst will maintain a solid command of all aspects of programs, can readily identify and update assumptions incorporated in forecasts/budgets to reflect the latest information and works closely with functional finance subject matter experts to test all assumptions. He/she uses a repertoire of financial analyses to support decision making and to validate that program and study budgets are based on "realistic" assumptions. The candidate will also implement best practices to drive efficient management across their therapeutic areas, develop detailed and accurate financial forecasts and deliver other financial reviews as required.

Requirements

• BS/BA in a Financial or other quantitative discipline with at least 2+ years of experience in financial analysis and/or data analysis.
• Strong verbal and written communication skills to develop and maintain relationships with various levels of personnel.
• Strong analytical skills and the ability to translate findings into actionable solutions and processes.
• Strong attention to detail and organization skills required.
• Proficiency in MS Office with emphasis on Excel.
• Advanced Excel skills needed to manipulate raw data and provide meaningful analysis (Vlookup, Pivot tables, IF statements, INDEX, MATCH, macros).
• Demonstrated ability to manage multiple priorities in fast paced and dynamic work environment.
• Ability to identify and implement various process efficiencies.

Nice To Haves

• Python experience a plus.
• Experience with Hyperion, ClearTrial and Qlik dashboarding is a significant plus.

Responsibilities

• Assist the Program Finance Team on the planning, forecasting and Reconciliation of financials for the designated Therapeutic Area Programs.
• Own the Financial Reporting and Analysis for programs within assigned therapeutic areas including monthly actuals reporting, quarterly forecast analysis and deck preparation to effectively communicate the status of each project’s/program’s financial execution and variance to plan/forecast.
• Work with cross-functional teams and subject matter experts to manage and communicate P&L and Balance Sheet implications to the business, accounting, and Corporate Finance; Monthly and quarterly activities include working with the Accounting group to ensure accuracy and completeness of journal entries
• Create budgets for clinical trials and analyze actual costs against budgets, track commitments and efforts with emphasis on performance against plans to ensure effective and accurate program cost reporting.
• Reviews documents for Purchase Order requisitions and track vendor payments / outstanding commitments
• Support clinical FTE forecasts through project management (Compass) system downloads and analyzes internal costs to reflect Partners with Accounting to communicate clinical trial accruals and translate actuals impact to forecasts as well as investigates clinical trial actual to forecast variances.
• Support Program Finance in preparation and analysis of the Annual Operating Plan, and quarterly forecast updates for assigned programs
• Prepare financial analysis in support of various ad hoc requests and projects.

Benefits

• health and wellness programs (including medical, dental, vision, life, and disability insurance)
• fitness centers
• 401(k) company match
• family support benefits
• equity awards
• annual bonuses
• paid time off
• paid leaves (e.g., military and parental leave)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees