CRM Systems Programmer/Analyst - Location Flexible - Fully Remote

Posted Date: September 14, 2021
Location: Washington, District of Columbia
The Trust for Public Land – a national leader and innovator in land conservation and parks creation – seeks a new CRM Systems Programmer/Analyst to join the CRM Team within Philanthropy Operations. This position can be located in any TPL office, or fully remote.
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. Headquartered in San Francisco, The Trust for Public Land maintains offices in more than 30 locations nationwide. Get to know more about us.
Position Summary
Reporting to the Director of Philanthropy CRM (CRM Director), the CRM Systems Programmer/Analyst shares responsibility for system administration, data management, user support, and reporting of the Constituent Relationship Management system (ClearView CRM) and related systems. The Programmer/Analyst provides strategic support and solutions that leverage The Trust for Public Land’s information, technology, and business processes for the entire Philanthropy department of about 90 individuals located throughout the U.S., and the organization at large.

The Programmer/Analyst will support the CRM Director’s overall vision for ensuring that Philanthropy staff and the greater TPL customer base have the support resources they need to realize their goals. This position directly supports our marketing and communication efforts in cooperation with data stewards in other departments. This person participates in end-user support functions including business analysis, report generation, documentation, training, and service desk operation.
Performance Requirements
  • Act with integrity, honesty, and knowledge to promote the culture, values, and mission of The Trust for Public Land;
  • Deliver outstanding service to teammates and colleagues;
  • Perform data-centric tasks at a very high level of quality;
  • Anticipate the needs of teammates and colleagues, evaluating those individuals and the environment for cues, and taking initiative;
  • Commit to personal and team excellence with clearly defined, measurable goals;
  • Maintain an attitude of continual improvement and achievement;
  • Navigate barriers to progress thoughtfully and tactfully;
  • Maintain a calm demeanor during periods of high volume or unusual events;
  • Approach job functions and teammates with the flexibility to rapidly adjust and to address competing priorities;
  • Manage many simultaneous competing priorities and resolve them to deliver optimal outcomes;
  • Define needs, design and document solutions, and deliver desirable outcomes in a timely manner;
  • Effectively communicate complex technical concepts in a clear and understandable manner both verbally and in writing to technical and non-technical audiences;
  • Ability to work independently and as part of a team;
  • Maximize the potential of systems and information to increase Philanthropy support of The Trust for Public Land and its mission;
  • Analyze and assess systems and processes, and recommend enhancements to ensure Philanthropy systems support TPL’s short-term and long-term goals;
  • Manage information moving in and out of the Philanthropy CRM, including designing business rules or procedures for imports and administering exports or automated procedures for integrations with other systems;
  • Analyze, develop, and maintain CRM data solutions, including defining, implementing, and editing code to improve and facilitate access, understanding, and integrity;
  • Develop and support ad-hoc or recurring reports, queries, dashboards, data visualizations, and scorecards that answer specific business questions;
  • Create, execute, schedule, and maintain queries and scripts using SQL, PL/SQL, Windows batch scripting, and Python;
  • Use GIT version control software to track and manage changes to code;
  • Help develop, direct, and participate in user training and ongoing support;
  • Work collaboratively and cohesively within the CRM Team, customers, and consultants;
  • Interface with staff, administration, and subject matter experts to understand and translate business requirements into technical solutions;
  • Use system reports and analyses to identify potentially problematic data, make corrections, and eliminate root cause for data problems or justify solutions to be implemented by others;
  • Identify and assist with deployment of future data projects and serve as liaison between consultants, vendors, and various technical, operational, and donor facing teams;
  • Exercise sound judgment and discretion to maintain confidentiality of privileged information;
  • Understand and carry out oral and written instructions, requesting clarification when needed;
  • Partner with fellow team members to define, pursue, and execute best practices;
  • Foster a pleasant and appealing work environment;
  • Bachelor’s degree in computer science, business analytics, a related field, or a significant and comparable combination of education, training, and experience;
  • Experience using tools and strategies for project management, collaboration, and personal productivity;
  • Minimum of 3 years proficiency in
    • Database or information systems, to include data definition, manipulation, extraction, transformation, and load in and across varied, complex systems using SQL, Python, and/or other relevant scripting languages, APIs, and tool sets;
    • Developing reports, dashboards, data visualizations and scorecards using BI software like Tableau, Power BI, or Jaspersoft Studio;
    • Analyzing, developing, reporting from, and maintaining CRM database systems and/or similar technologies;
  • Demonstrated ability to solve problems with critical thinking;
  • Strong analytical and research skills; ability to gather, evaluate, and to develop well-reasoned conclusions and recommendations;
  • Preference for experience with:
    • ClearView CRM, and Jaspersoft BI;
    • Service desk/issue tracking systems (like Jira);
    • Software version control;
    • Collaborating with vendors and consultants.
  • Experience in these Microsoft products is considered a plus: Dynamics 365 and the related Nonprofit Accelerator, Power BI, and Power Automate
We know there are great candidates who won’t fit everything we’ve described above, or who have important skills we haven’t thought of. If that’s you, don’t hesitate to apply and tell us about yourself.