Advancement Services & Database Specialist

Concord Academy; Northern (KY); Hybrid; USD 60,000 - 70,000; Full time

Benefits offered by this job

Benefits-eligible

Job summary

Concord Academy in Concord, MA, seeks an Advancement Services & Database Specialist to manage end-to-end gift processing, donor data, and database administration in the Advancement and Engagement Office.

Reporting to the Director of Advancement Services, you will ensure accurate recording of gifts, reconcile with the General Ledger, support data migrations from Raiser's Edge to RE NXT, and provide timely donor communications.

Qualifications

• Experience with gift accounting, records management, and database operations.
• Database software proficiency and ability to learn complex systems.

Responsibilities

• Oversee daily gift accounting in Raiser's Edge (cash, checks, cards, wires, securities, recurring gifts, matching gifts, payroll deductions).
• Perform weekly/monthly reconciliations with General Ledger.
• Record pledges, manage balances, and generate reminders.
• Generate donor tax receipts and acknowledgments.
• Maintain gift files and ensure cash handling compliance.
• Provide donor support and respond to inquiries.
• Update constituent records and ensure data quality and privacy.
• Lead data hygiene efforts and regular audits in RE to ensure accuracy.
• Support migration from RE DB View to RE NXT WebView and related documentation.
• Build queries, exports, lists, and reports for Advancement.
• Execute data imports and global updates.

Skills

Gift accounting

Records management

Database operations

Raiser’s Edge RE NXT

Excel

Microsoft Office

Data quality

Education

Bachelor’s degree preferred

Tools

Raiser's Edge Database View

RE NXT WebView

GiveCampus

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Advancement Services & Database Specialist

Concord, MA, US

4 days ago Requisition ID: 1182

Salary Range: $60,000.00 To $70,000.00 Annually

Overview:

Concord Academy, an independent, all-gender, boarding and day school renowned for its world‑class faculty, passionate students, and graduates who make their mark on the world, is seeking an Advancement Services & Database Specialist in our Advancement and Engagement Office. The successful applicant will have a commitment to advancing the core tenets of the school’s mission.

The Advancement Services & Database Specialist is the primary operational cornerstone of the Advancement and Engagement Office. Reporting directly to the Director of Advancement Services, this individual is primarily responsible for the end-to-end, prompt, and accurate recording of all gifts and pledges, gift reconciliation, donor tax receipts, and the proactive maintenance and safeguarding of constituent data (alums, parents, donors, and friends) in accordance with IRS guidelines and CASE standards.

As a secondary function, in a streamlined two-person Advancement Services team, this role provides technical database support—including data imports, global updates, and assisting the Director with the ongoing operational transition from Raiser’s Edge Database View (7.x) to the RE NXT Unified WebView.

Key Responsibilities

1. Core Gift Processing & Financial Accounting

Comprehensive Gift Administration: Oversee all daily aspects of gift accounting. Accurately and promptly process gift batches in Raiser’s Edge (cash, checks, credit cards, wire transfers, stock/securities, recurring gifts, matching gifts, and payroll deductions) in compliance with CASE and IRS standards and internal financial controls.

• Financial Reconciliation: Partner closely with the Finance Office to perform weekly and monthly reconciliations between Raiser’s Edge and the General Ledger. Troubleshoot and resolve discrepancies, making necessary gift adjustments in a timely manner.
• Pledge Management & Review: Record pledges, review pledge agreements, track outstanding balances, and produce pledge reminders.
• Tax Receipts & Acknowledgments: Generate donor charitable gift tax receipts and acknowledgments.
• Gift Documentation & Security: Maintain physical and electronic gift files, ensure proper cash handling compliance, follow up with donors and staff to secure necessary gift support. Collaborate with Finance to provide gift documentation for audits.
• Donor Support: Handle gift-related customer service inquiries from donors with professionalism and courtesy.

2. Constituent Records & Data Integrity

• Biographical Data Upkeep: Perform timely updates to constituent records, including contact information, deceased status, and communication preferences, ensuring accuracy and adherence to privacy standards.
• Data Quality & Hygiene: Lead ongoing data quality standards managing data hygiene efforts including appends, cleanup projects, and routine data entry. Conduct regular data audits in RE to ensure consistent and accurate data entry, table entries and naming conventions. Develop and execute proactive strategies to constantly improve the accuracy, completeness, and consistency of constituents’ biographical data, leveraging vendor relationships and technology resources where necessary.
• Cross-Departmental Collaboration: Collaborate with campus partners to ensure the timely exchange and safeguarding of critical constituent information.

3. Technical Operations & Database Administration

• Database Modernization & Migration Support: Assist the Director during the department’s ongoing operational transition from Raiser’s Edge Database View to RE NXT Unified WebView, adapting workflows as web features evolve. Create and maintain related process documentation for gift and data processing.
• Queries & Reports: Build and maintain queries, exports, constituent lists and reports to support the database information needs of the Advancement and Engagement Office.
• Data Imports & Global Updates: Execute data imports, global adds, appends, and other data integration functions.

Qualifications, Skills & Experience

Required:

• Experience: Minimum 3 years of direct experience in gift accounting, records management, and database operations, preferably within an independent school, college, or non-profit setting.
• Education : Bachelor’s degree preferred, or an equivalent combination of education, professional experience, and relevant technical skills.
• Database & Software Expertise: Experience with Blackbaud Raiser’s Edge / RE NXT (Database View and WebView) strongly preferred. Experience with online giving tools, GiveCampus preferred, and data import functionality.
• Technical Skills: High proficiency in Microsoft Office, with intermediate-to-advanced Excel skills.
• Systems Aptitude: Demonstrated ability to learn and navigate complex software systems and apply established processes consistently.

Core Competencies:

• Uncompromising Accuracy: Exceptional attention to detail and high standards for data precision and financial recordkeeping.
• Discretion & Integrity: Demonstrated ability to handle sensitive biographical and financial donor information with complete confidentiality.
• Problem Solving & Autonomy: Strong analytical skills to reconcile financial discrepancies and perform under minimum supervision, making sound decisions in the absence of the Director.
• Service Orientation: Excellent written and verbal communication skills with a team-focused, customer-service approach to assisting donors and colleagues.
• Location: On-Campus. Physical presence on campus is required to process physical mail, paper checks, and secure financial records.
• Schedule: Full-time (Monday–Friday). Occasional early morning, evening, or weekend hours required during peak periods (Calendar Year-End in December, Fiscal Year-End in June, and major school events).

Candidates who do not meet every preferred qualification are encouraged to apply. We are particularly interested in candidates who demonstrate strong technical aptitude, attention to detail, curiosity, and the ability to learn complex systems quickly.

This is a full-time, year-round position. Salary is competitive and commensurate with experience. This position is benefits-eligible. Candidates must successfully complete a criminal background check.

Concord Academy actively seeks applicants who reflect and support our mission and commitment to join a diverse and inclusive school community.

To learn more about Concord Academy, please visit our website at www.concordacademy.org. We are unable to respond to phone or email inquiries.