Data Manager, Membership at ASPCA – American Society for the Prevention of Cruelty to Animals

Data Manager, Membership

Remote

time type

Full time

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.

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