Lead Financial Analyst, Financial Planning & Analyst & Systems

Broad Institute•Cambridge, MA

4d•$104,000 - $145,333•Hybrid

About The Position

The Broad Institute of MIT and Harvard is seeking an analytical, collaborative, and systems-savvy Lead Financial Analyst- Financial Planning & Analysis (FP&A) & Systems. Reporting to the Director of FP&A, this role serves a dual purpose: driving institutional financial modeling, budgeting, and forecasting across scientific platforms and operational programs, while serving as the primary administrator and subject matter expert for the Institute's financial planning system (Workday Adaptive Planning). The ideal candidate bridges corporate financial rigor with mission-driven research, using Adaptive Planning to streamline forecasting, enhance multi-year financial strategy, and optimize reporting across sponsored grants, gifts, and operating funds.

Requirements

Bachelor’s degree in Finance, Accounting, Economics, or a related quantitative field required
At least 7 years of progressive FP&A experience
At least 2+ years serving as a hands-on Administrator or Lead Developer for Workday Adaptive Planning.
Demonstrated mastery of Adaptive Planning building blocks (Modeled Sheets, Cube Sheets, Master Formulas, OfficeConnect, Integration Tasks).
Deep understanding of non-profit accounting principles, grant accounting dynamics (direct vs. indirect costs), and multi-fund accounting.
Outstanding written and verbal communication skills with a proven track record of synthesizing technical data into clear narratives for executive and scientific stakeholders.

Nice To Haves

MBA or MS in Finance/Data Analytics preferred.
Prior experience in academic medicine, life sciences, biotechnology, or non-profit/research institutes with sponsored program funding is strongly preferred.
Advanced Excel skills (complex formulas, financial modeling)
Proficiency with data visualization platforms (e.g., Power BI, Tableau) or SQL is a plus.

Responsibilities

Lead the administration of Workday Adaptive Planning, serving as the critical driver to successfully complete the paused system implementation. Ensure uninterrupted system functionality and continuous operational support across all core planning processes, including forecasts, annual operating budgets, capital expenditures, headcount/workforce planning, and related financial workflows.
Serve as the hands-on Administrator for Workday Adaptive Planning, managing system security, user permissions, version controls, workflows, and integrations with enterprise systems (e.g., Workday HCM/Financials or ERP).
Design, build, and maintain sheets, accounts, assumptions, formulas, and dashboards within Adaptive Planning to evolve with institutional growth and complex funding models.
Build and maintain OfficeConnect templates and native Adaptive reports to automate monthly/quarterly executive reporting packages. Ensure data synchronization across systems.
Train, onboard, and support finance team members and budget holders across the Institute on Adaptive Planning tools and best practices.
Lead the annual institutional budget process and quarterly rolling forecasts, partnering with scientific program leaders, platform directors, and administrative department heads.
Build and refine multi-year financial models incorporating complex funding mechanisms (federal/NIH grants, foundational funding, sponsored research, and philanthropic revenue).
Perform monthly and quarterly variance analyses (Actuals vs. Budget/Forecast), translating complex trends into actionable financial insights for senior leadership and board committees.
Support financial planning for indirect cost rates (F&A), fringe benefit projections, capital investment allocations, and chargeback center modeling (work force allocations).