View all jobs
Financial Analyst – FP&A and Consolidation
Who We Are:
Trust for Public Land (TPL) is the leader of a movement to connect everyone in America to the outdoors. A national nonprofit, TPL partners with communities to create high-quality parks and protect public lands—especially in communities that need them most—to improve public health, create social cohesion, strengthen historic and cultural connection to place, and increase climate resilience. Since 1972, TPL has protected more than 4 million acres of public land, created more than 5,500 parks, trails, schoolyards, and iconic outdoor places, generated over $112 billion in public funding for parks and public lands, and connected nearly 10 million people to the outdoors. To learn more, visit tpl.org.
Position Summary:
The Senior Financial Analyst, FP&A, supports organization-wide financial consolidation, including function department reporting, allocations, planning, analysis, and management reporting. The position combines financial information across departments, helps to coordinate and consolidate budgets and forecasts, analyzes performance against plan and prior periods, and prepares clear financial reports. The Trust for Public Land receives funding from a variety of public and private sources. This role requires extensive hands-on Excel analysis, including working with large datasets, building financial models, reconciling information from multiple systems, and improving recurring reporting processes. The analyst works with Accounting, Development, grants staff, department leaders, and field and program finance analysts to produce accurate reporting and useful financial insights.
Essential Functions:
Department and Consolidation Analysis (40%)
Support Function Planning and Analysis (35%)
Advanced Excel Analysis (25%)
Qualifications:
Trust for Public Land is a hybrid work environment, and this role will ideally be located near a Trust for Public Land office. As a full-time employee, you will be eligible for the Trust for Public Land’s comprehensive benefits program which includes medical, dental, and vision insurance, vacation and sick pay plus holidays, a year end office closure, and a 403(b)-retirement plan, currently with up to a 7% company match. We offer competitive salaries commensurate with experience; the anticipated hiring range for this position is $82,000-$92,000 per year.
Trust for Public Land’s active goal is to be an inclusive and equitable place to work and build community. As the organization actively works to eliminate racial and other disparities it welcomes candidates with diverse backgrounds and/or multicultural skillsets. We are open to the possibility that a great candidate for this job may not precisely meet all the above criteria; if you believe you are the right person for this job and can persuasively make that case, we encourage you to apply.
Trust for Public Land (TPL) is the leader of a movement to connect everyone in America to the outdoors. A national nonprofit, TPL partners with communities to create high-quality parks and protect public lands—especially in communities that need them most—to improve public health, create social cohesion, strengthen historic and cultural connection to place, and increase climate resilience. Since 1972, TPL has protected more than 4 million acres of public land, created more than 5,500 parks, trails, schoolyards, and iconic outdoor places, generated over $112 billion in public funding for parks and public lands, and connected nearly 10 million people to the outdoors. To learn more, visit tpl.org.
Position Summary:
The Senior Financial Analyst, FP&A, supports organization-wide financial consolidation, including function department reporting, allocations, planning, analysis, and management reporting. The position combines financial information across departments, helps to coordinate and consolidate budgets and forecasts, analyzes performance against plan and prior periods, and prepares clear financial reports. The Trust for Public Land receives funding from a variety of public and private sources. This role requires extensive hands-on Excel analysis, including working with large datasets, building financial models, reconciling information from multiple systems, and improving recurring reporting processes. The analyst works with Accounting, Development, grants staff, department leaders, and field and program finance analysts to produce accurate reporting and useful financial insights.
Essential Functions:
Department and Consolidation Analysis (40%)
- Consolidate monthly financial results, budgets, and forecasts across departments, programs, and other reporting units. As needed, complete monthly close responsibilities including reconciling cash and accrual balances for specific support departments.
- Review departmental submissions for completeness, accuracy, consistent classifications, and agreement to source systems. Maintain account mappings, reporting hierarchies, reporting calendars, and consolidation schedules.
- Collaborate closely with Analysts that support Field and Program departments.
- Analyze organization-wide revenue, expenses, operating results, overhead and financial trends.
- Understand grant and philanthropic revenue sources. Assist in reviewing award or contract documentation and meet with key contacts to go over major provisions concerning budget and restrictions, period of award, and deadlines for progress invoices.
- Provide supporting schedule analysis related to balance sheet accounts.
- Maintain Excel models for allocating shared service and overhead costs to departments and programs.
- Assist in other general accounting and finance functions as needed.
Support Function Planning and Analysis (35%)
- Serve as the Financial Analyst for assigned support functions, such as Talent, Information Technology, Finance, and Legal. Prepare departmental reporting and help budget owners understand spending and forecast changes.
- Prepare and maintain annual budgets and forecasts for compensation, benefits, headcount, professional services, technology, occupancy, and other overhead costs. Validate assumptions with department leaders.
- Analyze recurring costs, spending commitments, staffing changes, and timing differences; distinguish temporary variances from ongoing changes and identify potential savings or resource needs.
- Coordinate with Accounting on accruals, prepayments, coding corrections, and other close inputs for assigned departments. Develop financial models and ad hoc analyses to support operating decisions.
Advanced Excel Analysis (25%)
- Comprehensive experience with Excel is essential (i.e. pivot tables, vlookups, and manipulating data from multiple sources to identify trends and build reports) and comfort with large datasets.
- Extract, combine, clean, and analyze large financial datasets from multiple systems. Use Power Query and other Excel capabilities to automate recurring data preparation and reporting. Improve manual processes and reduce repetitive spreadsheet work. Familiarity with Power BI, Tableau, or similar report systems is a plus.
- Experienced with ERP, financial systems and tools, and multi-dimensional databases.
Qualifications:
- Strong commitment to TPL’s shared values (Belonging, Creativity, Collaboration, Impact, and Hope) to effectively work across the organization.
- Approximately five years of progressive experience in FP&A, financial reporting, budgeting, consolidation, or related accounting and analytical work. Bachelor’s degree in finance, accounting, or a related field, or an equivalent combination of education and relevant experience.
- Excellent communication skills are required, as is the ability to work cooperatively with different personalities and financial aptitudes across the organization.
- Superior analytical and organizational skills are required, as are strong attention to detail, good recordkeeping, responsible time management, and the ability to juggle many projects and deadlines at once.
- Advanced, hands-on Excel capability, including PivotTables, formula applications, dynamic array formulas, and Power Query for importing, combining, cleaning, and refreshing data from multiple sources. Ability to build and maintain linked financial models, allocation schedules, scenario analyses, and management reports using large datasets.
- Strong spreadsheet controls, including reconciliations, validation checks, documented assumptions, version control, and clear model structure. Ability to troubleshoot complex workbooks and reduce repetitive manual reporting.
- Experience extracting and reconciling data from ERP, general ledger, budgeting, or other financial systems. Ability to manage concurrent deadlines, work independently, communicate findings to non-financial colleagues, and protect confidential information.
- Ability to problem solve and come up with strategies to improve processes and systems. Self-starter with a can-do attitude and a team player.
- Contribute to the creation of a diverse, equitable and inclusive work culture that encourages and celebrates differences.
Trust for Public Land is a hybrid work environment, and this role will ideally be located near a Trust for Public Land office. As a full-time employee, you will be eligible for the Trust for Public Land’s comprehensive benefits program which includes medical, dental, and vision insurance, vacation and sick pay plus holidays, a year end office closure, and a 403(b)-retirement plan, currently with up to a 7% company match. We offer competitive salaries commensurate with experience; the anticipated hiring range for this position is $82,000-$92,000 per year.
Trust for Public Land’s active goal is to be an inclusive and equitable place to work and build community. As the organization actively works to eliminate racial and other disparities it welcomes candidates with diverse backgrounds and/or multicultural skillsets. We are open to the possibility that a great candidate for this job may not precisely meet all the above criteria; if you believe you are the right person for this job and can persuasively make that case, we encourage you to apply.