Database Specialist

Join one of the most effective community-based environmental groups in the country.

Title: Database Specialist

Supervisor: Chief of Staff

Office Location: Warrenton, VA

Job Classification: Full-time Non-Exempt

About PEC

The Piedmont Environmental Council (PEC) protects and restores the lands and waters of the Virginia Piedmont, while building stronger, more sustainable communities. Founded in 1972, PEC is a locally based, community-supported 501(c)(3) nonprofit and accredited land trust. At the core of PEC’s approach is a focus on educating, engaging and empowering people to effect positive change in their communities.

Your Role

The Database Specialist is responsible for managing, configuring and maintaining PEC's central database, primarily built on the Salesforce platform, along with various integrated systems and secondary applications. This role ensures seamless data integrity, automated business process flows, comprehensive event, donor and volunteer tracking, monthly financial reconciliations, and robust reporting for organizational leadership.

The Database Specialist will work closely with PEC’s management team and the rest of the staff to understand organizational needs, resolve system issues, maintain data integrity, improve workflows, and ensure that staff are able to use Salesforce effectively.

Key Responsibilities

The Database Specialist will report to the Chief of Staff and be responsible for the essential functions within our database environments, including:

• User Management - Configuration of accounts, permission sets, profiles and roles.
• Security and Access - Set up and control data visibility across departments and system-wide security settings.
• System Customization - Build custom fields, objects and standalone applications. Build and maintain custom page layouts, record types, picklist value sets and validations rules.
• Process Automation - Design and maintain automated business flows.
• Reporting and Analytics - Create and manage both custom and standard reports, along with custom dashboards.
• Data Integrity - Oversee data cleaning operations by managing day-to-day quality, running database health reports and managing backups.
• Support and Training - Troubleshoot daily user issues and system errors, train staff on system functionality and best practices, write and maintain staff training documentation.

Geographic Focus

Based at our Warrenton, Virginia headquarters, this role operates on a hybrid schedule, requiring a minimum of two on-site days per week to support in-house staff and up to three remote days. Core operational hours are 8:00 AM to 4:00 PM, with flexibility as needed to assist staff and board members with database-related inquiries.

Required Qualifications

• Strong work ethic and commitment to PEC’s core values, mission and vision.
• Minimum five years of experience working with Salesforce.
• Attention to detail with a thorough and meticulous approach for accuracy.
• Proactive in driving independent solutions with a strong focus on research skills and creative problem solving.
• Strong interpersonal skills and collaborative abilities, including the ability to work with people of diverse backgrounds and work styles.
• Ability to work effectively under multiple deadlines.
• Strong understanding of Salesforce user management, permissions, profiles, roles, reports, dashboards and basic configuration.
• Understand Salesforce integrations with other applications (e.g., our email marketing tool, EveryAction) and the ability to execute when necessary.
• The ability to develop and build interactive dashboards.
• Experience with data cleanup, deduplication and data quality management.
• Ability to work independently.

Preferred Qualifications

• Experience working at a nonprofit or donor-based organization.
• Experience with other applications such as EveryAction (Bonterra), Zapier and Google.
• Experience with other applications and how they integrate with Salesforce.
• Salesforce Administrator Certification.
• Experience with Salesforce Nonprofit Cloud, Nonprofit Success Pack (NPSP), or other nonprofit Salesforce environments.
• Experience with grant management and reporting.
• Experience developing Salesforce training materials and standard operating procedures.

Working Conditions and Physical Demands

This position will be completed in an office environment. Office work requires extended sitting or standing and the use of a computer, keyboard and mouse. Due to the public-facing nature of PEC's mission and community events, employees may occasionally be photographed, filmed or quoted for use (with permission) in organization publications, promotional materials, social media and website content.

The Piedmont Environmental Council recruits, employs, trains, compensates and promotes regardless of race, religion, creed, national origin, ancestry, sex (including pregnancy), sexual orientation, gender identity (including gender nonconformity and status as a transgender individual), age, physical or mental disability, citizenship, genetic information, past, current, or prospective service in the uniformed services, or any other characteristic protected under applicable federal, state or local law. We are proud to be an equal opportunity employer.

We recognize that people come with a wealth of experience and talent beyond just the technical requirements of a job, therefore our job descriptions are guidelines. Your experience, which may include paid and unpaid experience, including volunteer work, helps build the competencies and knowledge. Diversity of experience and skills combined with passion is a key to innovation and a culture of excellence. Therefore, we encourage people from all backgrounds to apply to our positions.

In accordance with the Americans with Disabilities Act (ADA), reasonable accommodations during the application or interview process may be requested. If you have any questions or

concerns, please email View email address on click.appcast.io.

If selected for this position, a background check will be conducted.