Data Manager, Membership
- City, State: Remote
- Job Type: Regular
- Schedule: Full time
- Posted Date: 9/26/2024
- Req. Number: 2024-433
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:
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 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).
About Us:
The ASPCA was founded in 1866 on the belief that animals are entitled to kind and respectful treatment by humans and must be protected under the law. As a 501(c)(3) not-for-profit corporation with more than two million supporters nationwide, the ASPCA is committed to preventing cruelty to dogs, cats, equines, and farm animals throughout the United States.
The ASPCA is headquartered in New York City, where we maintain a full-service animal hospital, spay/neuter clinic, mobile spay/neuter and primary pet care clinics, a rehabilitation center for canine victims of cruelty, kitten nursery, adoption center, and two community veterinary centers.
The ASPCA also operates programs and services that extend nationwide. We assist animals in need through on-the-ground disaster and cruelty interventions, behavioral rehabilitation, animal placement, legal and legislative advocacy, and the advancement of the sheltering and veterinary community through research, training, and resources.
At the ASPCA, we are committed to fostering a collaborative and compassionate culture and we welcome all voices to contribute to our lifesaving mission. Our staff represent a vast array of backgrounds and diversity dimensions, bringing with them valuable experiences and perspectives. They join the ASPCA to learn, grow, and continually do their best work on behalf of animals. We are inspired by our staff, partners, and the communities we support across the country who work to improve animal lives. We are committed to diversity, equity, and inclusion at the ASPCA because it elevates our organizational culture, aligns with our Core Values, and enables us to move further and faster toward the ASPCA’s vision – that all animals live good lives; valued by society, protected by its laws, and free from cruelty, pain and suffering.
Applicants that are residents of Colorado: Per CO Senate Bill 23-058, we cannot generally request or require any age-related information (i.e., age, DOB, attendance or graduation dates from an educational institution) on an initial employment application; this includes any age-related inquiries in the initial interview. We are permitted to require/request additional application materials; if those materials contain any age-related information, an applicant may redact the information before submitting an initial employment application.