Senior FP&A & Consolidation Analyst (Remote)

Trust for Public Land; United States; Remote; USD 82,000 - 92,000; Full time

Job summary

The Trust for Public Land seeks a Financial Analyst – FP&A and Consolidation to drive organization-wide financial reporting and budgeting. The role emphasizes hands-on Excel analysis, cross-department collaboration, and improving recurring reporting processes across grants, allocations, and programs.

Remote in the USA with a hybrid benefits program; ideal for candidates with strong FP&A and consolidation experience who can communicate insights to non-financial partners.

Qualifications

• Progressive FP&A/financial reporting or budgeting experience.
• Bachelor’s degree in finance, accounting, or related field or equivalent experience.
• Strong analytical and communication skills across organizational levels.
• Advanced Excel including PivotTables, VLOOKUPs, and Power Query.
• Experience optimizing reporting processes and consolidations.

Responsibilities

• Consolidate monthly financial results, budgets, and forecasts across departments and reporting units.
• Review departmental submissions for completeness, accuracy, and consistent classifications.
• Analyze organization-wide revenue, expenses, and trends.
• Understand grant and philanthropic revenue sources and related award provisions.
• Maintain Excel models for allocating shared services and overhead costs.
• Assist in general accounting and finance functions as needed.
• Coordinate with program/field finance analysts to improve reporting.

Skills

FP&A

Consolidation

Budgeting

Excel

Power Query

Power BI

ERP systems

Education

Bachelor's degree in finance or accounting

Tools

ERP systems

Tableau

Job description

The Trust for Public Land seeks a Financial Analyst – FP&A and Consolidation to drive organization-wide financial reporting and budgeting. The role emphasizes hands-on Excel analysis, cross-department collaboration, and improving recurring reporting processes across grants, allocations, and programs.

Remote in the USA with a hybrid benefits program; ideal for candidates with strong FP&A and consolidation experience who can communicate insights to non-financial partners.