Business Intelligence Developer - Philanthropy Operations (Location Flexible/Remote)

Trust for Public Land – a national leader and innovator in land conservation and parks creation – seeks a new Business Intelligence Developer to join the Fundraising Information Systems (FIS) Team within Philanthropy Operations. This position can be located in any TPL office, or be 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 Information Systems (PhIS), the Business Intelligence Developer (Developer) shares responsibility for system administration, data management, user support, and reporting of the ClearView CRM and related systems. The Developer supports the development of solutions that leverage The Trust for Public Land’s information, technology, and business processes for the entire Philanthropy department of about 100 individuals located throughout the U.S., and the organization at large.

The Developer will support the Director’s overall vision for ensuring that Philanthropy staff and the larger TPL internal customer base have the support resources they need to realize their goals. This position's work products directly impact 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.

Responsibilities
● Develop and maintain 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;
● Manage information moving in and out of the Philanthropy CRM, designing and implementing 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 data integrity;
● Analyze and assess systems and processes, recommending and implementing enhancements to ensure Philanthropy systems support TPL’s short- and long-term goals;
● Develop and implement practical and resilient data governance measures;
● Identify and implement improvements to enhance data quality and meaning;
● Work collaboratively and cohesively with the PhIS 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 causes for data problems or justify solutions to be implemented by others;
● Identify and assist with deployment of future data projects and serve as a liaison between consultants, vendors, and various technical, operational, and donor-facing teams;
● Exercise sound judgment and discretion to maintain confidentiality of privileged information; ● Partner with fellow team members to define, pursue, and execute best practices;
●Collaborate in developing and facilitating user training and ongoing support.

Qualifications
● Bachelor’s degree in computer science, business analytics, a related field, or a significant and comparable combination of education, training, and experience;
● 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. Additional experience with Python and/or other relevant scripting languages, APIs, and toolsets is a plus;
 ○ Developing reports, dashboards, data visualizations, and scorecards using Jaspersoft Studio, SSRS, or other BI software like Tableau, Power BI, or Looker;
○ 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 develop well-reasoned conclusions and recommendations; ● Preference for experience with software version control using BitBucket or GitHub.

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 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;
● Foster a pleasant and appealing work environment.

We know there are great candidates who will not fit everything we have described above, or who have important skills we haven’t thought of. If that is you, don’t hesitate to apply and tell us more about yourself.

Compensation
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 17 holidays, and a 403(b) retirement plan, currently with a company matching up to 7%. We offer competitive salaries commensurate with experience; the range for this position is $85,000 to $95,000 annually.

 Trust for Public Land’s active goal is to be an inclusive and equitable place to work.  As the organization actively works to eliminate racial and other disparities, it welcomes candidates with diverse backgrounds of all types and/or multicultural skill sets and experiences.