Data Manager, Membership

Summary:

The ASPCA is seeking a dedicated Data Manager to support ASPCA programs and will serve as a critical member of the Membership team. Reporting to Senior Director, Database Strategy, the person in this role will assume primary responsibility for the management and integrity of constituent records in the ASPCA’s Salesforce fundraising database. 

The Data Manager will work primarily in the Salesforce and Azure platforms and will be responsible for managing the integrity of member and gift records, timely gift processing, and reconciling donor gift activity with the Finance department. This role will ensure adherence to all processes and procedures utilizing the highest level of data standards to support revenue tracking and responding to inquiries regarding transactions from internal and external constituents.

This remote-based position is open to all candidates based within the United States. Candidates based within commuting distance of New York City will be expected to work a hybrid schedule from our New York City 8th Avenue Office. 

Responsibilities:

Responsibilities include but are not limited to:

Gift Processing & Vendor Management (35%)   

• Ensure daily transaction files are posted successfully into Salesforce and Azure platforms in a timely manner, including the receiving, interpreting, and entering all contents of data files from external lockbox vendors, online data streams, and other sources.
• Run daily gift and data uploads and reconciliation reporting within data warehouse ensuring any errors and discrepancies are documented and reported.
• Resolve all discrepancies in daily gift data, collaborating with multiple vendors, external, and internal partners to ensure data is processed and submitted in a timely manner.
• Manage the day-to-day relationship with our external caging and gift processing vendors, including monitoring data entry quality. Promptly respond to vendor needs, working across teams to address data errors as needed and to perform necessary testing.
• Work closely with the Senior Director to manage and coordinate monthly reconciliation of gifts and annual audit requests.
• Lead the month-end reconciliation between fundraising and finance teams.

Reporting (30%): 

• Promptly notify supervisor of successful data transmissions, processing delays, or other changes in gift processing status that can impact teams’ work and reporting.
• Maintain status reports of all gift entries across giving platforms and channels; generate necessary gift reporting on a daily, weekly, and monthly basis.       
• With guidance from the Senior Director, support clear data standards, protocols, and process documentation for all Salesforce and Data Processes.

Quality Assurance (35%) 

• Examine data files for data input accuracy and alignment with ASPCA business rules for data input.
• Ensure complete, accurate, and timely information updates in the Customer Relationship Management (CRM) system; Maintain updated constituent information, including running NCOA updates, proactively finding and updating contact information, making record corrections, and merging duplicate records.
• Develop, maintain, and implement internal policies and procedures to ensure gift processing and administration quality and integrity. 
• Audit database for duplicate records and resolve duplicate error records in Master Data Management (MDM)
• With other Data Team members, maintain ongoing data hygiene, maintenance, and ad-hoc clean-up projects and other necessary tasks to ensure the integrity of the database
• Support the Data Team in database monitoring to ensure SQL server database performance, availability, security, and recoverability
• Provide support for various platforms managed by the Data Team that include but are not limited to: Informatica (MDM), Azure, Ownbackup, PowerBI, Salesforce
• Perform other appropriate assignments as requested by Senior Director, Database Strategy.

Exemplifies the ASPCA’s Core Values:

• Has Commitment and dedication to improving the lives of animals
• Demonstrates Ownership and feels responsible for outcomes
• Believes in Team – that we are stronger together
• Seeks to Elevate others and reimagine what is possible
• Focuses on Impact, specifically making change for animals

Compensation and Benefits:

The applicable target hiring range for this remote role is based on where the employee works, which for remote roles is the employee’s primary location of residence, and its respective cost of labor. We have organized the U.S. varying costs of labor index into three geographic zones. As a point of reference, below, we have included our ASPCA locations by geographic zone to illustrate what the hiring range would be in each of the following areas. 

Starting pay for the successful applicant will depend on a variety of factors, including but not limited to education, training, experience, location, business needs, internal equity, market demands or budgeted amount for the role. The target hiring range is for new hire offers only, and staff compensation may increase beyond the maximum hiring range based on performance over time. The maximum of the hiring range is reserved for candidates with the highest qualifications and relevant experience. The expected hiring salary ranges for this role are set forth below and may be modified in the future.  

• Zone 1 (For example: Asheville, NC; Champaign, IL; Columbus, OH; Gainesville, FL; Miami, FL; Oklahoma City, OK; Overland, KS; Union, MO; Weaverville, NC): $57,000 - $62,000 annually
• Zone 2 (For example: Washington D.C.; Los Angeles, CA): $64,000 - $69,000 annually
• Zone 3 (For example: New York, NY): $70,000 - $76,000 annually

You can view which zone applies to where you plan to work here. For questions regarding other locations not found on the list, please send an email to Careers@aspca.org for more information.  

Information on our Benefit offerings can be found here.

Stay Connected – Join Our Talent Community

If you are interested in joining our team but do not see a position listed that fits your experience or interests, please click this link and join our Talent Community to stay connected to future opportunities with the ASPCA.

Qualifications:

Language:

Education and Work Experience:

Our EEO Policy:

The ASPCA is an Equal Employment Opportunity employer.  All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, national origin, ancestry, gender, gender identity or expression, age, marital or domestic partner status, citizenship status, sexual orientation, disability, genetic information, military or veteran status, or any other characteristic protected by applicable federal, state or local laws, regulations or ordinances.

Applicants with disabilities may be entitled to a reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws.  A reasonable accommodation is a change in the ASPCA’s standard application process, which will ensure an equal employment opportunity without imposing undue hardship on the ASPCA.  Please inform the ASPCA’s People Team if you need an accommodation in order to complete any forms or to otherwise participate in the application process.

Individuals seeking employment are considered without regards to race, color, creed, religion, sex, national origin, ancestry, gender, gender identity or expression, age, marital or domestic partner status, citizenship status, sexual orientation, disability, genetic information, military or veteran status,  or any other characteristic protected by applicable federal, state or local laws, regulations or ordinances.

ASPCA is an Equal Opportunity Employer (M/F/D/V).