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 8thAvenue 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 rangeis 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 hiringsalary 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 workhere. 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 foundhere.

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:

Ability to understand the company's data needs and database environment, Advanced proficiency in Excel required, Detail oriented and organized with ability to multi-task in a fast-paced environment, Excellent oral and written communication skills, Exceptional ability to plan and organize work and meet deadlines, Nonprofit fundraising experience preferred, Salesforce experience a plus, Self-motivated, independent and able to work with minimal supervision and guidance, SQL experience a plus, Strong critical thinking, problem solving, and decision-making skills, Strong quantitative and analytical skills with ability to manage and analyze large data sets

Language:

English (Required)

Education and Work Experience:

Bachelors (Required)

Database Experience, Managing data hygiene and uploads in Salesforce

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 o.