Finance Manager

Job Title: Finance Manager (Project-Based)Location:Mettawa, IL 60045 (Hybrid: 3 days onsite, Tue-Thu / 2 days remote)Duration:Short-Term Project Support (Slated through 07/31/2026)Note to Candidates:This is a focused, project-based role supporting "Phase 2" of a transition. Most of the initial groundwork is complete; the focus now is on execution, documentation, and internalizing ownership before the project conclusion in July 2026.Position Summary:The primary objective of this position is to lead the transition of forecast ownership from external vendors to the internal Finance team. This role is a critical bridge for a project aimed at the 2026 launch. You will focus on closing existing gaps in automation, enhancing visibility into vendor-built forecasts, and establishing robust financial models and reporting tools to support Brand and Patient Services teams.Key Responsibilities:Project Leadership & Liaison:Serve as the primary Finance liaison between external vendors, internal finance teams, and documentation leads. Act as a project manager to ensure all workstreams remain on track for the 2026 deadline.Vendor Engagement & Data Analysis:Gather and document forecast assumptions and driver inputs from vendors. While specific vendor tools are currently undefined, you will analyze inputs/outputs based on generalized data (expenses, enrollment data, service/prescription counts) and present insights to leadership.Model Ownership & Transition:Build or adapt complex Excel-based financial models. Shadow vendor-produced forecasts to create Finance-owned versions for comparison and assist in the phased transition of model ownership.Reporting & Automation:Design and produce automated management reporting tools and variance analysis frameworks. Address current gaps in reporting efficiency to better support business and finance leadership.Team Enablement:Create templates, trackers, and process documentation. Regularly interact with business teams and patient services (5-member team) to align on priorities and resource planning.Qualifications & RequirementsExperience:7-10 years of progressive experience in Accounting or Finance.Technical Skills:AdvancedExcelmodeling skills are mandatory. Proficiency inPower BIandPowerPointis required for data visualization and executive presentations.Project Management:Strong ability to drive results in a matrixed environment. Project management is the most critical skill for this role to ensure the transition phase is completed by mid-2026.Communication:Proven ability to proactively evaluate business problems and communicate technical financial data to non-finance stakeholders.Industry:Open to any industry background; pharmaceutical experience is a plus butnot required .Top Critical SkillsProject Management:Ability to keep the transition on schedule.Financial Modeling:Expert-level Excel design for scenario planning.Financial Reporting Package Design:Building automated dashboards and management reports.Stakeholder Coordination:Acting as a functional bridge between vendors and internal teams.