Fundraising Operations & Donor Analytics Coordinator

YWCA Lancaster; Lancaster (Lancaster County); On-site; USD 52,000 - 75,000; Full time

Benefits offered by this job

Medical, Dental, Vision after 30 days

Retirement plan with employer match

Employee Assistance Program (EAP)

403b plan

PTO and holidays

Training and Development Opportunities

Parental leave

Tuition discount at Widener University

Job summary

YWCA Lancaster is seeking a full-time Development Operations Coordinator to manage fundraising systems, donor database, reporting, and development operations. You will support revenue generation through donor cultivation, sponsorships, and community partnerships, serving as the Bonterra EveryAction administrator and ensuring data integrity.

You will build queries, reports, and dashboards, handle gift processing, and provide analysis of donor retention and giving trends to inform strategic

Qualifications

• Minimum of 2 years of experience in database management, CRM administration, fundraising operations, or nonprofit administration.
• Strong proficiency in Microsoft Excel, including formulas, pivot tables, filtering, and data analysis.
• Experience generating reports and analyzing performance metrics.
• Excellent organizational skills and attention to detail.
• Strong written and verbal communication skills.
• Ability to maintain confidentiality and handle sensitive donor information.
• Ability to manage multiple priorities and deadlines effectively.
• Experience with Bonterra EveryAction CRM preferred.
• Experience in nonprofit fundraising or advancement services.
• Experience soliciting, securing and processing charitable contributions, sponsorships, and donor acknowledgments preferred

Responsibilities

• Maintain accurate and complete donor records in the CRM.
• Perform data quality audits, cleanup, and deduplication.
• Develop data entry standards and database procedures.
• Create queries, segments, and constituent lists.
• Coordinate CRM updates with Development Director and Bonterra support.
• Process gifts, pledges, recurring donations, and acknowledgments.
• Reconcile donation records with accounting systems.
• Generate fundraising reports for leadership and Board.
• Develop dashboards and track fundraising metrics.
• Identify and cultivate donors, sponsors, and community partners.

Skills

CRM admin

Excel

Data analysis

Fundraising ops

Donor engagement

Reporting

Data integrity

Confidentiality

Communication

Education

Bachelor's degree or related field

Tools

Bonterra EveryAction

Job description

YWCA Lancaster is seeking a full-time Development Operations Coordinator to manage fundraising systems, donor database, reporting, and development operations. You will support revenue generation through donor cultivation, sponsorships, and community partnerships, serving as the Bonterra EveryAction administrator and ensuring data integrity.

You will build queries, reports, and dashboards, handle gift processing, and provide analysis of donor retention and giving trends to inform strategic