Fundraising Data Analyst

Employer
AARP
Location
Washington, DC
Posted
Sep 20, 2021
Closes
Oct 20, 2021
Ref
12461290
Function
Analyst, Fundraising
Industry
Nonprofit
Hours
Full Time
Business Unit Description

AARP is a nonprofit, nonpartisan organization, with a membership of nearly 38 million that helps people turn their goals and dreams into 'Real Possibilities' by changing the way America defines aging. With staffed offices in all 50 states, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands, AARP works to strengthen communities and promote the issues that matter most to families such as healthcare security, financial security and personal fulfillment. AARP also advocates for individuals in the marketplace by selecting products and services of high quality and value to carry the AARP name. As a trusted source for news and information, AARP produces the world's largest circulation magazine, AARP The Magazine and AARP Bulletin.

AARP Foundation is AARP's 501 c3 charitable affiliate. We are a public charity with revenue from federal agencies, corporations, foundations and individuals. AARP Foundation's vision is a country free of poverty where no older person feels vulnerable. Staff are located in Washington DC and throughout the US.

Every year, AARP Foundation helps millions of struggling older adults 50 and over win back opportunity by being a force for change on the most serious issues they face each day. Through the Foundation's many groundbreaking and innovative programs and services, we create and advance effective solutions to meet their basic needs for nutritious food, safe and affordable housing, adequate income and much-needed personal connections.
Summary

The Fundraising Data System Analyst is a dual employee who will aid in supporting the department's multichannel fundraising processes associated with the organization's C3 and C4 fundraising databases. They will assist in maintaining the accuracy and integrity of our constituent data, work closely with the Integration and Implementation Systems Manager and consult with team's internal collaboration band. Day to day activities include data monitoring, data quality improvements, database administration, system reporting and internal client management.
Responsibilities

This position will be a technical expert and effective communicator who will work closely with a cross functional team (comprised of multiple business units) aiding with the administration of our donor databases. Primary constituent solutions include:

  • Salesforce Ecosystem (CRM)
    • Nonprofit Success Package CRM (NPSP)
    • Springboard (Online fundraising and engagement forms)
    • Salesforce Marketing Cloud (Email engagements)
    • Conga (Exception acknowledgments)
    • Qualtrics (Online surveys)
    • Clearview (Major Gifts CRM)


The Analyst will:

  • Extract and transmit critical files on a weekly, biweekly and monthly basis that synchronize records across databases (manually and through upload processes) including:
    • Select donors
    • Recently deceased
    • Ad-hoc requests
    • Weekly syncs
    • Etc.
  • Tag and update donor records daily with contacts, interest code/affiliations, donations, preferences, etc.
  • Conduct weekly data hygiene tasks monitoring data for quality, errors and corrections
  • QC daily weekly uploads
  • Respond to data inquiries from various internal clients and stakeholders
  • Create and publish recurring and or ad hoc reports as needed
  • Document reporting requirements related to data manipulating and operating procedures
  • Provide end-user support for CRM systems
  • Support all database projects to ensure the accuracy and integrity of our donor data including but not limited to the process of uploading transaction files from multiple sources
  • Ensure all documentation and workflow processes remain up to date
  • Clearly and accurately communicate with internal and external stakeholders
Requirements

Bachelor Degree preferred
An equivalent combination of experience (four or more years) with fundraising relational databases and knowledge of querying tools and/or statistical software may be accepted as a satisfactory substitute for the specific education requirement
Ability to create pivot tables and macros with MS Excel
Knowledge of SQL preferred
Effective verbal and written communications skills
Compensation and Benefits

AARP offers competitive benefits with a 401(k); 100% company-funded pension plan; health, dental, and vision plans; life insurance paid time off to include company and individual holidays, vacation, sick, caregiving, and parental leave; performance-based and peer-based recognition; tuition reimbursement; among others. Visit careers.aarp.org/benefits for more information.

As a result of the COVID pandemic, all interviews will be held virtually and all non-essential employees will continue to work remotely until further notice.
Equal Employment Opportunity

AARP is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. AARP does not discriminate on the basis of race, ethnicity, religion, sex, color, national origin, age, sexual orientation, gender identity or expression, mental or physical disability, genetic information, veteran status, or on any other basis prohibited by applicable law.

Similar jobs