Associate Director of Philanthropy Data Strategy and Analytics - Location Flexible

Posted Date: January 24, 2022
Location: Washington D.C., California
The Trust for Public Land – a national leader and innovator in land conservation and parks creation – seeks a new Associate Director of Philanthropy Data Strategy and Analytics. Since 1972, The Trust for Public Land has connected communities to the outdoors and to each other. Today, millions of Americans live close to a park or natural area created by The Trust for Public Land, and countless more visit each year. From neighborhood parks to national parks, the organization has completed more than 5,000 projects, protected more than 3.5 million acres of land, helped to secure over 70 billion dollars of public funds for land protection and park creation, and inspired cities and towns nationwide to work to create a park or open space within a 10-minute walk of all their residents.

Join a diverse team of dedicated and passionate people working toward a mission you can believe in—creating parks and protecting land for people, ensuring healthy, livable communities for generations to come. The Trust for Public Land maintains offices in more than 30 locations nationwide. This position is part of the Philanthropy Operations team which has members located throughout the U.S. The Manager may be located anywhere in the U.S. and can work fully remotely or in a TPL office if one is accessible. Get to know more about us.

Position Summary

Reporting to the Associate Vice President for Philanthropy Operations (AVP), the Associate Director of Philanthropy Data Strategy and Analytics (Associate Director) is both a partner to the AVP and other philanthropy operations directors and is responsible for all analytics needs for the team. This position provides the entire scope of functions for our fundraising analytics needs, from data extraction using SQL, through synthesizing, analyzing, and interpreting data, to producing final reports which include narratives, summary tables, and visualizations.

Performance Requirements
  • Act with integrity, honesty, and knowledge that promote the culture, values, and mission of The Trust for Public Land;
  • Maintain a calm demeanor during periods of high volume or unusual events;
  • Anticipate the needs of teammates and colleagues;
  • Deliver outstanding service to teammates and colleagues;
  • Perform data-centric tasks at a high level of quality;
  • Approach job functions and teammates with the flexibility to manage competing priorities;
  • Define needs, design solutions, and deliver desirable outcomes in a timely manner.

Required Knowledge, Skills & Abilities
  • Intermediate knowledge of SQL scripting and relational database architecture, ability to properly query information with SQL from Oracle database;
  • Aptitude with creating Pivot tables/Power Pivots, and querying data using Microsoft Excel, SQL Developer, or similar;
  • Ability to integrate disparate sources of information/data to provide appropriate level of analysis and support;
  • Solid project management, research, and analytical skills;
  • Communications skills (written, verbal and interpersonal), with the ability to synthesize and accurately present relevant data analytics information with both technical and non-technical personnel at various levels in the organization;
  • Adapt to rapidly changing dynamics and priorities;
  • Pre-hire proficiency required in Microsoft Windows, Office, and Google Workspace;
  • Proficiency required, with post-hire training as needed, in ClearView CRM, Jira & Jira Service Desk, and Jaspersoft.

Essential Functions
  • Work independently and, as applicable, with internal and external partners, to identify and implement solutions to complex data questions;
  • Establish and review logic, criteria, and definitions to incorporate into data models to extract functional data sets for reporting;
  • Develop and refine techniques for gathering and integrating data from disparate sources;
  • Formulate, design, and develop reports, tools, and analyses to enable informed decision making;
  • Prepare analysis and data visualizations for a wide range of users at all levels of the organization, including Senior and Executive Leadership to support presentations, budget forecasting, fundraising goal setting, and other needs;
  • Identify and recommend opportunities to improve and consolidate reporting with an eye to efficiency and program outcomes; determine the right data, the right question, the right tool, and the appropriate audience for work;
  • Analyze internal and external reports and recommendations from consultants or other stakeholders and prepare critical analysis, documentation, and presentations to explain changes, inconsistencies, identify patterns and strategic opportunities, and critique recommendations;
  • Participate in developing, enhancing, and performing standard operating procedures for data governance and hygiene;

  • Demonstrated track record of strategic and creative approaches to fundraising analytics with collaboration with fundraisers, system administrators, and senior-level management.
  • Minimum 3 years experience working with databases and reporting, preferably in a nonprofit fundraising environment; or equivalent combination of experience and education;
  • Experience analyzing complex relational datasets, including the  use of views, tables, queries, data extraction, manipulation, and reporting;

We know there are great candidates who will not fit everything we have described above, or who have important skills we have not considered. If that’s you, do not hesitate to apply and tell us about yourself.


As a full-time exempt employee, you will be eligible for The Trust for Public Land’s comprehensive benefits program which includes medical, dental, and vision insurance, three weeks of vacation annually plus ten holidays, and a 403(b) retirement plan, currently with a 5.5% company matching. We offer competitive salaries commensurate with experience; the range for this position is $75,000 to $95,000 annually.

Our search team will start reviewing application materials the week of January 21, 2022. 

The Trust for Public Land is an Equal Opportunity Employer and encourages diversity in the workplace. We welcome people of all backgrounds and seek to foster a culture of respect, openness, learning, integrity.